From October 2021 onwards, the NetSuite.com data source is still supported, but it will no longer be updated with newly exposed tables or columns, and it may be removed in the future. New tables and columns will now only be exposed to the NetSuite2.com data source.
You are encouraged to start a transition process from NetSuite.com to NetSuite2.com. NetSuite2.com provides advanced query capabilities and has been available since 2019.2.
Currently, SuiteAnalytics Connect provides access to the following data sources:
NetSuite.com - Uses the only schema available up to 2018.2 to retrieve data. The details about the tables and columns in this schema are available through the Connect Browser.
NetSuite2.com - Uses the schema that has been used in SuiteAnalytics Workbook since 2019.1. The details about the record types in NetSuite2.com, also known as the analytics data source, are available through the Records Catalog.
From October 2021 onwards, the NetSuite.com data source will no longer be updated with newly exposed tables and columns, and no enhancements will be made. Users will still be able to access the NetSuite.com data source. However, the NetSuite.com data source will only include records exposed up to 2021.2, and support for NetSuite.com will end in a future release. The use of the NetSuite.com is no longer considered a best practice.
Benefits of Using the NetSuite2.com Data Source
The analytics data source is designed to display consistent data across SuiteAnalytics Workbook, which solves some previous inconsistencies in data exposure between saved searches, reports, and the NetSuite UI. It applies role-based access control, which contributes to improved security.
When you use SuiteAnalytics Connect with the NetSuite2.com data source, you must consider the following:
Data Warehouse Integrator (DWI) role - Previous to 2021.2, there was no role that allowed Connect users to have access to 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 new Data Warehouse Integrator role allows users to have access to all NetSuite data through the NetSuite2.com data source, except for sensitive data, such as credit card information. Note that the DWI role requires token-based authentication (TBA).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.
SuiteQL - Change your SQL queries to SuiteQL queries. You must run SuiteQL queries when you use the Connect Service with NetSuite2.com data source. If you do not change your queries, they will not work with the NetSuite2.com data source.
Records Catalog - To see information about the record types and fields, joined record types and join properties, you can use the Records Catalog, which shows only data relevant to your account and role.
For a list of other changes to the Connect Service, see Connect Service Notifications.
You should use the NetSuite2.com data source when you work with SuiteAnalytics Connect. To access the NetSuite2.com data source, you must set the Service Data Source connection attribute to NetSuite2.com. When you access the NetSuite2.com with the Connect Service, ensure that you change your SQL queries to SuiteQL queries.
For more information about specific considerations, see the following topics:
To learn about the required roles and permissions, see Role and Permission Considerations for NetSuite2.com.
To learn about SuiteAnalytics Connect and token-based authentication, see Token-based Authentication for Connect.
To change the connection attribute to access the analytics data source, see Configuring Your Data Source.
To learn about the analytics data source and Connect, see The Analytics Data Source and SuiteAnalytics Connect.