By Louis Balla, Chief Revenue Officer, Nuage. Updated October 2026.
SuiteAnalytics Connect is a NetSuite add-on that gives read-only access to NetSuite data through ODBC, JDBC and ADO.NET drivers, so outside tools can query it with SQL. It reads the NetSuite2.com data source, and every connection needs your account ID and a role ID. You must purchase it and enable it before the drivers work.
This guide covers what Connect is, how to check whether you have it, how to set it up and what to verify when something stops. For SuiteAnalytics workbooks and saved searches, see our SuiteAnalytics guide. For choosing between all of NetSuite’s analytics tools, see our guide to NetSuite analytics strategy.
What is SuiteAnalytics Connect?
Oracle describes the Connect Service as a way to archive, analyze and report on NetSuite data from a third-party tool or a custom-built application on any device that runs Windows, Linux or macOS. NetSuite offers three drivers:
- ODBC
- JDBC
- ADO.NET
Connect gives read-only access to NetSuite data. You cannot use it to update NetSuite records. It applies role-based access control through the NetSuite2.com data source, so a connection sees only what its role can see. Oracle also warns that applications built for real-time data access can slow retrieval and interrupt connections.
Do you need to buy SuiteAnalytics Connect?
Yes. Oracle’s Connect FAQ describes it as an add-on module that you buy through your account manager, and says it is not available for NetSuite Small Business accounts. Oracle’s page on Connect access to project tasks data puts it in one sentence: you must have purchased SuiteAnalytics Connect, have the feature enabled and download one of the drivers.
To check whether your account has it, go to Setup, Company, Enable Features and open the Analytics subtab. Oracle’s feature page says that if the SuiteAnalytics Connect option is missing, the feature has not been provisioned and you should contact NetSuite Customer Support or your account manager.
A finance lead at a coffee roaster asked us about loading NetSuite data into a warehouse “to ease our analysis, and take advantage of AI,” noting Connect was a product “which we don’t own and are reluctant to buy at this time.” Our consultant replied with eight questions: read-only or not, warehouse or dashboards, which tools, whether scheduled data is acceptable, alignment with workbook data, comfort with ODBC or JDBC, role-based access, and whether data will be centralized. Mostly yes points to Connect; mostly no points to saved searches, SuiteScript or an API. The client answered yes to most.
Those eight questions work as a buyer’s checklist for any team deciding whether Connect fits.
How do you set up SuiteAnalytics Connect?
Follow these steps in order. Oracle’s driver download page has the current instructions for each operating system.
- Confirm the feature is enabled. Check the Analytics subtab of Enable Features, as described above.
- Give the role the Connect permission. An administrator adds the SuiteAnalytics Connect permission to the role the connection will use. Oracle’s permissions page covers the options. Note the role’s ID, because every connection needs it.
- Download the driver. On the NetSuite home page, find the Settings portlet and click Set Up SuiteAnalytics Connect. Download the ODBC, JDBC or ADO.NET driver, verify the file and install the latest version.
- Configure the data source. Provide your NetSuite account ID and the role ID, and set up certificate-based server authentication as Oracle describes it.
- Choose the authentication method. Oracle lists three: a NetSuite account email address with a valid password, OAuth 2.0, or token-based authentication.
- Test with a small query. Connect from the tool, run a query against one table and check the row count against a saved search in NetSuite.
Which data source does Connect use?
Connect reads the NetSuite2.com data source, which Oracle also calls the analytics data source. It is the only data source for Connect. NetSuite.com is no longer available as of NetSuite 2026.1, so a BI tool still pointed at the older one stops returning data.
Check every reporting connection after that change. In a September 2026 assessment of an equipment manufacturer running Connect with Tableau, our team made confirming every reporting connection the first item on the roadmap, paired with a driver update. For a consumer products company that wanted to know whether its Connect access was used at all, our developer queried the Connect login audit for active users and drivers, and the client traced the connection to an application it no longer used.
NetSuite2.com uses a different schema from NetSuite.com, and Oracle notes that some records and fields differ. Oracle’s analytics data source overview explains how it is structured, and the Records Catalog in NetSuite lists the record types and fields it exposes. SuiteQL, which Oracle describes as based on the SQL-92 revision of the SQL language, is available through Connect.
Does Connect move data into a data warehouse?
Connect provides access, and a separate tool moves the data. A data center operator asked us how to get NetSuite data into its Azure data lake in time for its 2027 budget cycle. In the scoping call our developer explained that SuiteAnalytics Connect provides SQL access to NetSuite data but does not synchronize anything, so an extraction tool still has to move the data. Our written comparison set Connect plus an extraction tool, which lets queries change without code changes, against a custom SuiteScript integration, which is more development to build and maintain, and named the next step as a feasibility test before recommending one.
Our guide to combining NetSuite and Salesforce data for reporting shows how a warehouse fits when a second system is involved.
What should you check when a Connect connection fails?
Oracle’s Connect FAQ lists these common issues and what to check:
| Symptom | What Oracle says to check |
|---|---|
| Table does not exist | Look for typos, unsupported characters such as underscores or spaces, or a missing permission |
| Connection liveness limit reached | A token-based authentication session has expired, and the session lasts 60 minutes, so start a new Connect session |
| TCP/IP connection reset by peer | A network problem, a server restart or a firewall; use the KeepAliveTime parameter for idle connections |
| Text values cut short | Adjust Width and Height for the field under Customization, Lists, Records and Fields, Record Types, on the Display subtab |
Check the role first when a query returns fewer rows than expected. A role sees only the records it has permission to view.
How Nuage approaches SuiteAnalytics Connect
In recent assessments and scoping calls, our team has taken these steps. The order changes with each account.
- Find out whether Connect is used at all. Our developers query the Connect login audit for active users and drivers.
- Confirm every reporting connection. We list each BI tool and check that it uses the NetSuite2.com data source and a current driver.
- Ask the buyer’s questions. The eight questions above separate a team that needs Connect from a team that needs a saved search or an API.
- Compare the routes for a data load. Where the goal is a warehouse, we write down Connect plus an extraction tool against custom SuiteScript and propose a feasibility test as the next step.
- Test the role and the connection in a sandbox. The role ID, the permission and the authentication method are checked before any user relies on them.
Nuage’s NetSuite experts do this work as part of ongoing NetSuite optimization and managed services.
SuiteAnalytics Connect FAQ
Is SuiteAnalytics Connect included with NetSuite?
Oracle’s documentation says you must purchase SuiteAnalytics Connect and enable it before you can use it, and its FAQ calls it an add-on module bought through your account manager. If the feature does not appear under Enable Features, it has not been provisioned for your account.
Which drivers does SuiteAnalytics Connect support?
ODBC, JDBC and ADO.NET. Oracle publishes the current versions and the version history for each on its Connect drivers page. Download them from the Set Up SuiteAnalytics Connect link in the Settings portlet on the NetSuite home page, and install the latest version.
Can I update NetSuite data through Connect?
Connect is read-only. Oracle describes it as a method for obtaining NetSuite data and says you cannot use it to update NetSuite data. When you need to write records back, use a RESTlet, REST web services or an integration platform, each of which has its own authentication and permissions to set up.
What is the NetSuite2.com data source?
It is the analytics data source, and Oracle lists it as the only data source for Connect. It applies role-based access control and uses a different schema from the older NetSuite.com source, which has not been available since NetSuite 2026.1. Check that every reporting connection points at NetSuite2.com.
What is the difference between SuiteAnalytics Connect and SuiteAnalytics?
SuiteAnalytics is the name for NetSuite’s analytics tools, which include saved searches, reports, dashboards, SuiteAnalytics Workbook, Connect and NetSuite Analytics Warehouse. Connect is the one that lets outside tools query NetSuite data, and it has to be purchased and enabled as an add-on. Our SuiteAnalytics guide covers the others.
About the author
Louis Balla is Chief Revenue Officer at Nuage, a NetSuite optimization partner that has served 250+ clients since 2011 and holds a 4.9 out of 5 rating on Clutch. The client work in this article is our team’s.
