This notice applies to customers who use SuiteAnalytics Connect. 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.
This change is targeted for October 2021.
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.
What is Changing?
The following table lists the changes in the SuiteApp names, bundle IDs, and upgrade types.
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.
- As of October 2021, 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. As of that time, the use of the NetSuite.com will not be 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.
You are encouraged to use the NetSuite2.com when you work with SuiteAnalytics Connect. New tables and columns will now only be exposed to the analytics data source.
When you use SuiteAnalytics Connect with the NetSuite2.com data source, you must consider the following:
- New 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. The DWI role requires token-based authentication (TBA).
- Note: The Data Warehouse Integrator role and token-based authentication are available for 2021.2 only. If you have not been upgraded to 2021.2 yet, you should start using the NetSuite2.com data source, but you will not be able to use the Data Warehouse Integrator role and token-based authentication until your account is upgraded.
- 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.
Required Actions
You should start to 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 this change, see Connect NetSuite.com Data Source No Longer Being Updated (SuiteAnswers ID 101873).
For more information about specific considerations, see the following topics:
If you have more questions, please contact NetSuite Customer Support.