The SuiteAnalytics Connect Service lets you archive, analyze, and report on NetSuite data. You can use a third-party tool or a custom-built application on any device that uses Windows, Linux, or OS X operating system. If your company enables the Connect Service, NetSuite offers ODBC, JDBC, and ADO.NET drivers that you can download, install, and use for 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.
Before using the Connect Service, be aware of the following:
Third-Party Applications
You can use a variety of compatible applications, including Microsoft® Excel, BIRST, Adaptive, or any other compatible application, to work with the Connect Service.
NetSuite2.com Data Source
With SuiteAnalytics Connect you can access NetSuite data through the NetSuite2.com data source, also known as the analytics data source. The NetSuite2.com data source is designed to display consistent data across SuiteAnalytics Workbook, which solves some previous inconsistencies in data exposure between saved searches, reports, and the NetSuite user interface. It also applies role-based access control, which contributes to improved security. To work with the NetSuite2.com data source, you must be aware of some considerations.
Authentication
There are several ways to access SuiteAnalytics Connect. You can use your NetSuite account email address with a valid password, or you can use two industry standard-based mechanisms that increase overall system security: OAuth 2.0 and token-based authentication (TBA).