What third-party tools are people using to extra d...
# suitetalkapip
PlanetJupiter
09/16/2021, 9:44 AMWhat third-party tools are people using to extra data from NetSuite to external storage (CSV/SQL/Sharepoint). With Netsuite offline for 2 hours yesterday we are looking for a read-only solution for us staff to search data.
c
CD
09/16/2021, 10:33 AMDo you have ODBC access?
p
PlanetJupiter
09/16/2021, 12:25 PMNo, used it before but painfully slow.
d
dynamicl
09/16/2021, 3:45 PMI built a tool out for my clients using ODBC, which replicates every table, every schema change, all the data, but the primary purpose of this was a full backup (this is not a commercial product btw)
dynamicl
09/16/2021, 3:45 PMmessage has been deleted
dynamicl
09/16/2021, 3:46 PMJust adding saved search replication aswell which is better for reporting in some instances. I'd recommend you look at a saved search option if its specific data you want staff to search on.
dynamicl
09/16/2021, 3:47 PMA quick and dirty method would be to spit out the saved search csv's on a schedule.
p
PlanetJupiter
09/16/2021, 8:32 PM@dynamicl looks impressive. Good work!
d
dynamicl
09/17/2021, 9:15 AMThanks, building in saved search and report replication as we speak, so can use things like multi-currency trial balance data in PowerBI etc. NS don't make any of it easy, but its all possible one way or another 🙂 . I was using SSIS originally but the NS schema constantly changes so had constant issues, everything is done dynamically in C# now.
a
Aqueel Ahmed
09/28/2021, 2:50 AMWe are trying to use cdata to replicate the data very similar use case as yours but it is painfully slow
Aqueel Ahmed
09/28/2021, 2:50 AMIf you find a way that is faster please post here 🙂
d
dynamicl
09/28/2021, 3:13 PMDo you have SuiteAnalytics Connect? If so, you can pull around 10 tables in parallel and I see a speed around 1m records every 5 mins (approx).
3 Views