What is SuiteAnalytics Connector ? how can we establish a connection between Netsuite and MS PowerBI using the suite analytics connector?

Suppose if you want to connect NS with any 3^rd paty Data analytics applications, we can do with “Suite Analytics connector”.

 Connect Service, lets you archive, analyze, and report on NetSuite data using a third-party tool or any custom-built application on any type of device using a Windows, Linux, or OS X operating system.

Once the Connect Service is enabled, then NetSuite offers ODBC, JDBC, and ADO.NET drivers that you can download, install, and use to connect to the Connect Service.

Note: The SuiteAnalytics Connect Service provides a read-only method for obtaining NetSuite data. You cannot use the Connect Service to update NetSuite data.

(There are many different ways that we can connect, but what I followed is using ODBC drivers, if you need more details I prefer you to go through Netsuite help docs)

To connect the Suite Analytics connector please follow below process:  (as administrator)

1. Login to NetSuite , Go to Setup -> Enable Features -> Analytics -> enable the “Suite Analytics Connector” checkbox and save it.

2. Go to Home page -> Settings portlet -> click on “Set Up SuiteAnalytics Connect”.

3.    Once clicked on Set Up Suite Analytics connect, then you will be navigated to “SuiteAnalytics Connect Driver Download “ page.

You can select the required bundle for the OS (windows/Linux).

In the example I have downloaded 64bit “ODBC INSTALLATION BUNDLE 64-BIT (7.20.55)” bundle.

4. Once the download is complete then you can see the "NetSuiteODBCDrivers_Windows64bit" zip file in the download folder.

5. Extract the "NetSuiteODBCDrivers_Windows64bit", and double click on the highlighted application.

6. the below window will be opened and click on the Next button.

7. Once Next button is clicked, then accept the license.

8. Once license is accepted, then you will be displayed with Datasource configuration details. Now, enter the configuration details like which are displayed in step 3.

9. Finish the installation process.

This way ensures that the ODBC setup is completed in the windows system.

Once installation completes we can see the connection details in Program Files.

Now, connecting with MS Power BI (I'm going through the steps after installing the MS Power BI)

1. Go to MS Power BI application, go to File -> Get Data -> Click on "More"

2. Go to Other and click on "ODBC" in the pop up window

3. Double click on the ODBC, and you will be navigated to "From ODBC" pop up window, select "NetSuite" in the drop down.

4. Once clicked on "OK" button, Navigator window will be open, select the data what ever you load in the Power BI.

5. Click on the Load button once you select what data you want to visualize.


This ensures the connection establishes between netsuite and power bi.

Like this we can connect any other analytics application.

Again, i'm repeating if you want more details about suite analytics connector please go though the suiteAnswers.

Thanks,
Ramu