Does anyone know if you have to have SuiteAnalytic...
# suiteanalyticsc
Chris
04/09/2021, 2:11 PMDoes anyone know if you have to have SuiteAnalytics Connect enabled on your NetSuite account in order to use third party ODBC drivers such as those provided by CData?
k
KevinJ of Kansas
04/09/2021, 2:16 PMNot familiar with cdata, but I'm guessing they use web services to retrieve data
KevinJ of Kansas
04/09/2021, 2:16 PMMake sure you are familiar with the limitations of doing that
👍 1
c
Chris
04/09/2021, 2:17 PMi've reached out to them for a more in depth conversation with them on the requirements and limitations but it could be a couple days before someone gets back to me about it. Figured I would just shoot a message out here to see if anyone knew right off hand.
t
tdietrich
04/09/2021, 2:45 PMIt looks like they use SuiteTalk: http://cdn.cdata.com/help/DNF/odbc/pg_startedintroo.htm
tdietrich
04/09/2021, 2:46 PM"We support all editions of NetSuite including Standard, CRM, and OneWorld. The driver leverages NetSuite Web services to enable you to access any entity in your NetSuite account in real time. The driver supports all versions of the SuiteTalk API. The driver models NetSuite entities, transactions, custom records, and lists in these APIs as bidirectional tables. Saved searches are modeled as read-only views. The driver also supports bulk inserts, updates, and deletes."
d
Dominic B
04/09/2021, 3:20 PMWe used CData for a while to extract data for Tableau BI. It needs a user account with concurrent web services, which will cause an issue if you have more than 1 other account using it at the moment. It's slow as hell if your account's large like ours. We eventually scrapped it and I'm now really of the opinion that you can achieve most things using native technologies these days. Anything that you can't probably ought to raise the question of whether you're on the right platform.
c
Chris
04/09/2021, 3:24 PMThanks for the feedback on this!