The SuiteAnalytics Connect module enables you to access and query your NetSuite data using SQL through the following mainstream database standards: ODBC, JDBC and ADO.NET.
When enabled, the SuiteAnalytics Connect Service enables your business to archive, analyse, and report on its data using a third-party tool or any custom-built application, all while connecting from any type of device using a Windows or Linux operating system.
If your company elects to enable the Connect Service, NetSuite offers ODBC, JDBC, and ADO.NET drivers that you can download, install, and use to connect to the Connect Service. You can use a variety of compatible applications, including Microsoft® Excel, BIRST, Adaptive, or any other compatible application, to work with the Connect Service.
The SuiteAnalytics Connect Service provides a read-only method for obtaining NetSuite data. You cannot use the Connect Service to update NetSuite data.
Whether you wish to use an ODBC, JDBC, or ADO.NET driver to access the Connect Service, you must first enable the SuiteAnalytics Connect feature.
- Navigate to Setup -> Company -> Enable Features
- Click the Analytics
- Check the SuiteAnalytics Connect box
If you do not see this feature, it has not been provisioned for your account. Contact NetSuite Customer Support or your Account Manager for assistance.
Ok, if the above is enabled. Let’s give this a go. Let’s do this from the Administrator Role:
- Go to the settings portlet on your dashboard and click the “Set up SuiteAnalytics Connect” link:
- Upon clicking, you reach a page with some couple of options
- Choose the operating system
- Take note of the configuration details
- Choose the Driver of your requirement
- Once you download the driver, go ahead and install it. You will come across a page where you will be asked to enter the content shown in the configuration page, shown above.
- In my case, I am using the ODBC driver. You will notice that the NetSuite drivers gets installed and configured for you.
- Well, I am not going much into it, but with the options above, I have connected to NetSuite, in view mode, from my excel and my SQL query analyser. See screenshots below.
Here are some tips before we end:
- You can only use SELECT queries on NetSuite database.
- The tables you can see there are just Views in NetSuite’s end, that is why the statement #1 is the only possible command you can do.
Imagine what you can do with this, you can now create your own reports, desktop applications, and other stuff that is feeding on your NetSuite data.
Well, talking about Data management, you can also extract NetSuite data using Attunity Replicate, one of IBT’s product offering, into a database flavour of your choice such as SQL Server, Oracle, etc. If you are interested in to what Attunity has to offer, do let us know and one of our team members will get in touch with you.
Alternatively, you could contact Mike Hollobon, Director of Business Development & Solutions Sales, via [email protected] or 0477 247 100.