ODBC can be used to access NetSuite data through a third-party ODBC driver that translates ODBC calls into NetSuite-specific API calls. This allows applications that use ODBC to access NetSuite data in a similar way to accessing data in a traditional DBMS.
ENABLING FEATURE
Setup → Enable Features → Analytics → SuiteAnalytics connect.
After this, you will able to see an option in home settings Setup SuiteAnalytics Connect.
DOWNLOAD AND INSTALL THE NETSUITE ODBC DRIVER
Download the ODBC driver based on your operating system from the SuiteAnalytics Connect Driver Download page.
Once downloaded, run the installer to begin the installation process. The next step is to install the NetSuite ODBC Driver on your computer. Follow the prompts in the installation wizard to complete the installation.
SET UP NEW ROLE
Set up a new role for accessing data from NetSuite via ODBC and provide necessary permission according to your need. Please find the example role below.
CONFIGURE THE ODBC NETSUITE DRIVER
After the installation of the ODBC driver is complete, you need to configure the driver to connect to your NetSuite account. Open the ODBC Data Source Administrator and navigate to the “System DSN” tab. Click on the “Add” button.
Enter Name, Description, your Account ID, Role ID(internal id of your newly created role), Service host, port, and Service Data Source(refer to configuration details from the page SuiteAnalytics Connect Driver Download) and click Test Connect.
Enter Netsuite username and password. and click OK. Click Test Connect. You will get a message saying the connection is successful.
RETRIEVING DATA
Go to your application where you want to get data. Here I connected with Power Bi. Click Get Data -> More -> Other -> ODBC. Select the Data source name. You can write SQL statements in advanced options.
Data will be availble based on the role you have given
Select table load data.
