How to get the data from NetSuite using ODBC? or How to retrieve data from NetSuite using ODBC?
The first thing is first…
Download DB tool — SqlDbx
Have NetSuite account with right access privileges
Download ODBC Driver for NetSuite (Login Net Suite and select “Set Up SuiteAnalytics Connect”)
Download ODBC driver (32 Bit) – 64 Bit driver will not work in many cases (it is due to old school NetSuite)
Install the exe(Enter the correct information)
Open (SqlDbx application)
Create a New connection
DBMS Type ODBC
DNS (NetSuite or what ever you named) (click on three … dots for the discovered services) — Select the NetSuite 32 bit Schema
Enter UserName and Passworod
That’s it.
Make sure to have the right access previliage.