We currently have the ODBC connect tool. We used ...
# generalc
cferber
09/16/2019, 2:31 PMWe currently have the ODBC connect tool. We used it during our implementation but not really using it now. How is everyone using it? Does anyone know of any add - on ( 3rd party) that utilize it for better reporting tools?
s
Shahar Kaminski
09/16/2019, 3:09 PMAre you talking about the Suiteanalytics connect?
c
cferber
09/16/2019, 3:20 PMYes
s
Shahar Kaminski
09/16/2019, 3:29 PMI’m using it to export NetSuite data to SQL server. Once it’s there I’m using the info for reporting and for other integration processes.
k
KevinJ of Kansas
09/16/2019, 3:49 PMGetting the data out of NS in the ODBC tool can be handy for bringing into visualization tools like PowerBI
KevinJ of Kansas
09/16/2019, 3:50 PMThat said - I rarely recommend hooking them straight up into PowerBi - because the table structure is a bit of a mess. Better to park the data in a SQL database and then create views that you know what they are for hitting with PowerBI
a
AK47
09/16/2019, 5:18 PMwith the ODBC package, can you write to Netsuite as well as read from, or is it read only for reporting?
k
KevinJ of Kansas
09/16/2019, 5:40 PMRead only
👍 1
4 Views