Our company signed up for the ODBC database connec...
# generalc
Cory Weiner
02/14/2024, 9:25 PMOur company signed up for the ODBC database connector. I’d like copy a selection of tables from Netsuite into an external data warehouse. Curious if anyone has any suggestions on building out that process. Ideally I’d want to tables to refresh on a schedule. Can you recommend any tools to help with that workflow?
e
eblackey
02/14/2024, 10:14 PMDo you have a preference on which data source you want to sync? NETSUITE.COM or NETSUITE2.COM?
c
Cory Weiner
02/14/2024, 10:15 PMI’m not sure what the differences are. We are still waiting on them to enable the connector. Just signed the contract today
e
eblackey
02/14/2024, 10:17 PMNETSUITE.COM is the legacy data model - most similar to what Saved Search uses. NETSUITE2.COM is the newer data model - that SuiteAnalytics and SuiteQL is based on.
eblackey
02/14/2024, 10:18 PMThe reason I ask is that we use a platform called Stitch which works well for doing what you're talking about, but it only supports NETSUITE.COM
c
Cory Weiner
02/14/2024, 10:19 PMAh, I see. We would be using Netsuite2 most likely then.
e
eblackey
02/14/2024, 10:21 PMDo you already know what the external data warehouse would be?
n
Nick Callas
02/15/2024, 12:16 AMWe use fivetran to copy to Redshift and its excellent
r
RJMNS
02/15/2024, 1:10 AMI don't think they're letting any new ODBC customers connect to anything other than Netsuite2.
👍 2
m
MGBC
02/15/2024, 3:31 AMYea Fivetran is a nice tool
c
Cory Weiner
02/19/2024, 11:03 PMThanks I’ll look into fivetran
Cory Weiner
02/23/2024, 2:53 PM@MGBC @Nick Callas
Hey guys, I’ve been setting up fivetran, but I’m curious if you guys are using the “Netsuite SuiteAnalytics” connector? When setting that up it is saying the transactionLineLink tables are not incremental (even though that have a modified date column). Curious if you guys are syncing those tables or if you’ve found some workaround
n
Nick Callas
02/23/2024, 5:44 PMWe are still in the stone age with the NetSuite.com connector and not netsuite2, so thats a bit different schema. Generally Fivetran support has been very helpful with these kind of questions for me.