New Netsuite connector - Merge Not Working
The Netsuite connector now has a feature to 'Merge' (UPSERT) records from a saved search and you get to identify the primary key of the record (to check if it exists).
Since there was no information I could find about the 'Remove Duplicate' records feature (ie: What does Domo check to figure out what is a duplicate?). For example, I had a bad cost on an invoice, I fixed it and since I changed it (last modified date) it was going to be uploaded again. Is that going to replace the "bad" invoice in Domo?
So I had throught the 'Merge' was going to save the day by updating the bad record with the new "fixed" one (with the same unique key field).
Bzzzt ... Wrong Answer.
I changed my connector to use 'Merge' (vs Replace or Append) and if failed. No error message other than 'It failed.. try again' (Of course I did that... a few times).
Hey Domo, do you read these forums, any insite on this.
(btw: New to Domo but not new to Data Whse and ETL / SQL concepts)
Interesting. Assuming the Netsuite API can handle the load of your dataset in one call or unless you have older records on the dataset you'd like to retain (based on the modified date), why not set it to replace, and re-run your entire historical record again? It should replace the bad record.
No idea why the 'Merge' wouldn't work (sometimes new connector options can be buggy), but you can always dataflow and remove duplicates in the ETL tool, using a match on the record key, name, etc. (excluding the modified date) to keep a running list of unique, updated records.
It might help to do a recursive dataflow so it's easier to append and re-run bad records in the future as well. Hope this helps.0
You are correct, the data set is huge (Daily Transactions since dawn of time and new ones every day). Netsuite connector cannot handle even extracting more than 2-3 months of transactions at a time. So, there is no chance of re-building that daily. The merge looked like it was an answer.
Was more concerned about running an ETL that has to "re-process" (recursive data flow) the entire dataset each time the source data is updated. I kinda feel like the recursive dataflows are done to overcome a platform design flaw.
Thanks for the note.0
100% agree re: recursives were meant to overcome a flaw - back when i started using domo, no connectors had the 'since last successful run' option, meaning you were timebound on a GMT daily update if you wanted to append data to the raw set.
What i found is the recursive lets me replace single records when i encounter similar issues. I just re-run for the date range that the record is in (in the absence of single-record specification), and simply insert the remove duplicates ETL tool for that run, ensuring my updated record stays and the old one goes. None of the other rows should be affected, and i wouldn't worry about the re-processing of the entire data set; we re-run millions of rows a day without delay.
Either way I hope that connector gets updated to work properly...drop a ticket!0
I built my Saved Search in NetSuite to import the full dataset in chunks at first (about one quarter's worth at a time). Once I had everything in DOMO, I set the Saved Search to only return transactions that were created or modified in the last day or so.
That seems to work to keep the Merge running, and handles my deltas.0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 82 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive