Does anyone have experience using the Netsuite ODBC connector?

Lots of folks do - if you are looking for a channel to ask questions about it in #C2A1ZEMF0 is the best location

Thanks @KevinJ of Kansas

Unfortunately - our search feature is back down to just the 10k most recent messages so you can't find them with the search right now.

Yep, we are pretty heavy ODBC users. Have built quite a few critical high-volume data processes around it that have been running since 2014, so it does work well.

@scottvonduhn evaluating whether we need it. Our business is amazon based and some of our data is in netsuite and some in amazon. We'd like to combine the data into one location or database, real time so we can create specific reporting to make it easier for our user to do their jobs.

That does sound like a pretty good use case for ODBC then. Just so you know a few things about it. It is read-only (no way to write changes back into NetSuite using it), however it is possibly one of the fastest ways to retrieve large sets of data out of NetSuite. We tested various integration methods, including SuiteTalk and Restlets, and nothing beat the throughput of ODBC. Also, there are two schemas: NetSuite.com and NetSuite2.com The former (NetSuite.com) was designed to more closely match the UI and table names/columns names reflect what you see in Netsuite. NetSuite2.com mostly uses the scriptids for table and column names, and very closely matches the schema of SuiteQL. You have to decide which schema makes more sense, but beware that the Netsuite.com schema can be changed if the name of a record type or field label is changed, whereas Netsuite2.com only changes if someone modifies a script id, which is much less likely.

Thanks! We really need to validate if it will directly connect with an Amazon RDS server

It won't

Ok thanks

@scottvonduhn thanks for this ,that great explanation for choice of integration design for SuiteQL . We are planning to build a tool to connect to NS via SuiteQL, and was wondering if you also considered SuiteQL over NS REST WS (launched in 2020.1), as its free (you dont have to buy SuiteAnalytics connect) vs using ODBC/JDBC only via SuiteAnalytics add-on.

That is an option as well, however it's a feature that has to be enabled for you by NetSuite, and you need to request it (it's not automatically available to everyone)

@scottvonduhn What software do you use to pull data using ODBC

SQL Server for ODBC