The Analytics Data Source and SuiteAnalytics Connect
Since 2019.2, the new data source for SuiteAnalytics Connect is no longer considered a beta feature and is generally available. The new data source supports NetSuite phased release cycle. Therefore, when your production account is upgraded to the new NetSuite release, the same version of the data source is immediately available. The access to the new data source requires account-specific domains.
The new data source is designed to display consistent data across SuiteAnalytics Workbook, which solves some previous inconsistencies in data exposure between saved searches and reports.
To access the new data source, you must modify the following connection attributes of the driver to enable the connection.
-
Service Host – Change the Connect Service host name to your account-specific domain. The host name you should use for your connection is displayed in the Service Host field on the SuiteAnalytics Connect Driver Download page, under Your Configuration.
-
Data Source – Change the attribute to NetSuite2.com.
When you access the new data source, you need to consider the following:
-
Role-based access restrictions – Users can only query data that they can access in the SuiteAnalytics Workbook user interface, which contributes to improved security. The new data source is not accessible for the following roles and permissions:
-
Administrator
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.
-
Full Access (Deprecated)
-
Roles requiring Two-Factor Authentication (2FA)
-
Roles accessing the Connect Service with IP restrictions
-
SuiteAnalytics Connect - Read All Permission
-
-
SuiteQL – SuiteAnalytics Connect supports SuiteQL. When you run queries, syntax for both SQL-92 and Oracle are supported, but you cannot use them in the same query. You can retrieve information from the schema of the new data source using the OA_COLUMNS, OA_TABLES, and OA_FKEYS tables. Additionally, you must consider some syntax requirements when creating a query such as supported operators, functions, expressions and number of arguments.
To access the new data source, the role used must be granted the SuiteAnalytics Connect permission.
For more information about account-specific domains, see URLs for Account-Specific Domains.
For more information about the new data source, see the following topics:
For more information about SuiteQL and best practices for querying the Connect Service, see the following topics: