SuiteAnalytics Connect
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.
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.
Note:The Connect Service is intended for use with static data or data that does not change often. Using real-time data access applications with the Connect Service can slow the retrieval of results and cause connection interruptions. For more information, see Third-Party Application Access.
-
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. For more information, see NetSuite2.com Data Source.
Important:Support ends for the NetSuite.com data source in 2025.1, and it will be removed in 2026.1. Start transitioning to the NetSuite2.com as soon as possible to avoid disruption when this change occurs.
-
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). For more information, see Authentication for SuiteAnalytics Connect.
Ensure that you have the latest driver version installed and the required connection attributes. You must also update your NetSuite connections to use certificate-based server authentication and provide the NetSuite Account ID and Role ID on every connection. For information about the latest driver versions available, see Required Update of SuiteAnalytics Connect Drivers.
To start working with Connect, see Getting Started with SuiteAnalytics Connect.