Demystifying ODBC and NetSuite’s SuiteAnalytics Connect for data access

This section defines ODBC and SuiteAnalytics Connect, explains their purpose, and outlines how to determine if the feature is enabled and how to use it.

1. What does ODBC stand for?ODBC means Open Database Connectivity. It is an industry-standard term used in the context of databases and accessing the information contained within them, and is not specific to NetSuite.

2. What is SuiteAnalytics Connect?In the NetSuite environment, SuiteAnalytics Connect is a service that provides direct access to NetSuite data using various industry-standard drivers, including ODBC (Open Database Connectivity), JDBC, and ADO.NET. While ODBC is a general standard for database connectivity, SuiteAnalytics Connect is NetSuite's overarching feature that supports and leverages ODBC connectivity, among other driver types, to facilitate direct database access.

3. Is SuiteAnalytics Connect a free feature?SuiteAnalytics Connect is an add-on module that must be purchased.

4. How to determine if SuiteAnalytics Connect is enabled:

   To check if SuiteAnalytics Connect has been purchased and enabled for your NetSuite account, navigate to:Setup > Company > Enabled Features > subtab Analytics.If "SuiteAnalytics Connect" is visible and checked, the feature is enabled.

5. Why use SuiteAnalytics Connect?SuiteAnalytics Connect is utilized to connect directly to the NetSuite database (the backend) for purposes such as producing complex reports, performing data transformations, or preparing data for integration with other systems.

6. How to use SuiteAnalytics Connect:

   The Connect Browser is the essential tool for understanding the schema of NetSuite database tables and their relationships. Similar to how the Record Browser is used for programming with SuiteScript, the Connect Browser is used to understand the data structure when pulling information with SuiteAnalytics Connect.