Hey yall, currently working on a project to load N...
# generaln
Nabil
01/13/2023, 12:53 AMHey yall, currently working on a project to load NS data in a Data Warehouse - Going back and forth on the pros and cons of using a NetSuite API (I assume it’s webservices?) vs ODBC. Anyone has experience with both and lived to tell the tale?
Nabil
01/13/2023, 12:54 AMFor deeper context, I’m using Stitch into Google BigQuery. It feels like the big takeaways are cost vs having somewhat of a more traditional database schema and structure, is that right? We played around with the API integration and hit some roadblocks with transaction lines.
s
Stuart Anderton
01/13/2023, 10:01 AMI’m using Stitch via the API. Some issues with Stitch not being able to see only updated lines on some Item sub lists causing excessive data volumes, but transactions working fine?
n
Nabil
01/13/2023, 2:33 PMSome data is inconsistent. sometimes the “line” value will be empty. sometimes the “lineuniquekey”, etc… Have you had experience with that?
s
Stuart Anderton
01/13/2023, 5:26 PMNo, not seen that at all.
d
darrenhillconsulting
01/16/2023, 6:44 PMTalk to @Josh_SatoriReporting about Tactical Connect
j
Josh_SatoriReporting
01/16/2023, 10:11 PMTwo other great options:
1. Satori Reporting - a pre-built data-warehouse for NetSuite with Power BI (and data model) sitting on top. Used by 200+ NetSuite customers. www.satorireporting.com
2. Tactical Connect - a saved search and dataset scheduled export tool to easily and quickly get your data over to your DW. www.tacticalconnect.com
2 Views