Changing from NetSuite.com to NetSuite2.com

This content is intended to help you change from NetSuite.com to NetSuite2.com.

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.

If you have been working with NetSuite.com, you need to make some adjustments before you work with NetSuite2.com. The following table describes what changes when you move from NetSuite.com to NetSuite2.com and the required actions to complete the transition.

What Changed	Change Description	Action Required
Accessing NetSuite2.com	The NetSuite2.com applies role-based access control and is not accessible for some roles and permissions. Also, the NetSuite2.com supports the Data Warehouse Integrator (DWI) role which is not available for NetSuite.com. Prior to 2021.2, there was no role that allowed Connect users to access all NetSuite data through the NetSuite2.com data source. The Administrator role and the SuiteAnalytics - Read All permission were available for NetSuite.com only. As of 2021.2, the Data Warehouse Integrator role allows users to access all NetSuite data through the NetSuite2.com data source, except for sensitive data. Note: When you use SuiteAnalytics Connect with OAuth 2.0, the NetSuite2.com 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 NetSuite2.com.	Verify that you meet the conditions to access NetSuite2.com.
Authentication	You can access Connect with the email and password used to log in to NetSuite. However, the NetSuite2.com 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 NetSuite.com, the Service Data Source connection attribute is set to NetSuite.com. To access NetSuite2.com, you must change the Service Data Source connection attribute to NetSuite2.com. 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 NetSuite2.com.
Running queries	When you run queries with NetSuite2.com, 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 NetSuite2.com data source uses a different schema than NetSuite.com. Some record types and fields that were available in NetSuite.com may not be available in NetSuite2.com. A spreadsheet is available for download with a list of records and fields in NetSuite.com and their corresponding NetSuite2.com records and fields. For information about the spreadsheet, see NetSuite.com to NetSuite2.com Map. You must also consider that the NetSuite2.com data source applies role-based access restrictions. You may need to modify existing queries for NetSuite.com 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 NetSuite2.com data source. For information about the record types and the differences between the records available in NetSuite.com and NetSuite2.com, see Record Types and Fields.	See Record Types and Fields.

What Changed

Change Description

Action Required

Accessing NetSuite2.com

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

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

Note:

When you use SuiteAnalytics Connect with OAuth 2.0, the NetSuite2.com 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 NetSuite2.com.

Verify that you meet the conditions to access NetSuite2.com.

Authentication

You can access Connect with the email and password used to log in to NetSuite. However, the NetSuite2.com 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 NetSuite.com, the Service Data Source connection attribute is set to NetSuite.com. To access NetSuite2.com, you must change the Service Data Source connection attribute to NetSuite2.com.

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 NetSuite2.com.

Running queries

When you run queries with NetSuite2.com, 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 NetSuite2.com data source uses a different schema than NetSuite.com. Some record types and fields that were available in NetSuite.com may not be available in NetSuite2.com.

A spreadsheet is available for download with a list of records and fields in NetSuite.com and their corresponding NetSuite2.com records and fields. For information about the spreadsheet, see NetSuite.com to NetSuite2.com Map.

You must also consider that the NetSuite2.com data source applies role-based access restrictions. You may need to modify existing queries for NetSuite.com 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 NetSuite2.com data source.

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

See Record Types and Fields.

Related Topics