1. SuiteAnalytics
  2. Connect
  3. Connect Service Notifications
  4. Connect NetSuite.com Data Source No Longer Being Updated

Connect NetSuite.com Data Source No Longer Being Updated

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:

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.

Required Actions

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:

Related Topics

General Notices