Changing from NetSuite.com to NetSuite2.com

Note:

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

If you have been working with NetSuite.com, you should 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.

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

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

Connect Data Source
Connect Schema
NetSuite2.com Data Source
NetSuite.com to NetSuite2.com Map
NetSuite.com Records Not Directly Mapped to NetSuite2.com Records
SuiteAnalytics Connect System Tables
Querying Data with Connect

General Notices