Changing from to


This content is intended to help you change from to If you are not moving from, see Getting Started with SuiteAnalytics Connect.

If you have been working with, you should make some adjustments before you work with

The following table describes what changes when you move from to and the required actions to complete the transition.

What Changed

Change Description

Action Required


The applies role-based access control and is not accessible for some roles and permissions. Also, the supports the Data Warehouse Integrator (DWI) role which is not available for

Prior to 2021.2, there was no role that allowed Connect users to access all NetSuite data through the data source. The Administrator role and the SuiteAnalytics - Read All permission were available for only. As of 2021.2, the Data Warehouse Integrator role allows users to access all NetSuite data through the data source, except for sensitive data.


When you use SuiteAnalytics Connect with OAuth 2.0, the data source is accessible for the Administrator role. However, the Data Warehouse Integrator role and custom roles are the preferred option when transferring data to a data warehouse.

For more information, see Role and Permission Considerations for

Verify that you meet the conditions to access


You can access Connect with the email and password used to log in to NetSuite. However, the data source also supports two mechanisms that increase the overall system security: OAuth 2.0 and token-based authentication (TBA).

OAuth 2.0 is the preferred authentication method. The token for OAuth 2.0 is valid for multiple sessions, while you can use the token for TBA for a single session only. You should consider using OAuth 2.0 instead of TBA whenever possible.

For information about the two authentication methods and additional authentication considerations, see Authentication for SuiteAnalytics Connect.

OAuth 2.0 is the preferred authentication option.

Data source configuration

When you use the Connect Service with, the Service Data Source connection attribute is set to To access, you must change the Service Data Source connection attribute to

To change the connection attribute for your driver and operating system, see Configuring Your Data Source.

For information about the data source, see Connect Data Source.

Change the connection attribute to

Running queries

When you run queries with, you must use SuiteQL. SuiteQL is a query language based on the SQL-92 revision of the SQL database query language which provides advanced query capabilities. You must also consider the use of supported and unsupported functions when using SuiteQL.

To learn about SuiteQL and see a list of supported and unsupported functions, see SuiteQL and Using SuiteQL with the Connect Service.

Change your SQL queries to SuiteQL.

Verifying your existing queries

The data source uses a different schema than Some record types and fields that were available in may not be available in

For information about some record type differences between the two data sources, see Differences Between and

You must also consider that the data source applies role-based access restrictions. You may need to modify existing queries for that you created when there were no role-based restrictions. You can use the Records Catalog to see the feature and permission requirements for each record type.

For information about the Records Catalog and SuiteAnalytics Connect, see Using the Records Catalog.

Verify your queries and modify them as needed.

Record types and fields

There are multiple ways to find the names of the record types and fields available in the data source.

For information about the record types and the differences between the records available in and, see Record Types and Fields.

See Record Types and Fields.

Related Topics

Connect Data Source
Connect Schema Data Source to Map Records Not Directly Mapped to Records
SuiteAnalytics Connect System Tables
Querying Data with Connect

General Notices