Working with the Connect Browser
The Connect Browser is no longer being updated and shows tables and columns that were made available up to 2021.2 only.
Support ends for the NetSuite.com data source in 2025.1, and it will be removed in 2026.1. Start transitioning to the NetSuite2.com as soon as possible to avoid disruption when this change occurs.
Go to the SuiteAnalytics Connect Browser.
The Connect Browser includes a summary of NetSuite data available through the NetSuite.com data source. The browser provides a page for each of the standard tables in the Connect schema and is updated bi-annually to include any newly exposed tables and columns. Each page in the browser lists the table’s columns, a subset of its primary and foreign keys, the related tables, and length, precision, and scale attributes for each table column.
The data types listed in the Connect Browser follow Oracle naming conventions. Consequently, depending on the SuiteAnalytics Connect driver you use, the data types of certain columns may vary.
For some tables, the Connect Browser also provides domain diagrams that illustrate the relationships among tables in a specific business domain. Currently, only the most widely used domains are included.
The Connect Browser is integrated with the SuiteScript Records Browser and the SOAP Schema Browser, which enables you to compare record type support across SuiteScript, SOAP web services, and SuiteAnalytics Connect.
To learn how to use the Connect Browser, see the following:
The system table OA_COLUMNS contains identical column information as the pages for each table in the Connect Browser, however OA_COLUMNS is updated immediately when there are new exposures in the Connect Schema. Consequently, the OA_COLUMNS table may contain more column information than the Browser.
Additionally, the scale attribute in both the OA_COLUMNS table and the Browser may display 0 when the value is unknown or undefined. For more information about the OA_COLUMNS table, see oa_columns.
Working Offline
If you want to use the SuiteAnalytics Connect Browser when you are working offline, you can download the .zip file that contains the SOAP Schema Browser, SuiteScript Records Browser, and SuiteAnalytics Connect Browser.
After downloading the .zip file, extract it and go to the \odbc directory. To view the content, open the index.htm file in the browser of your choice.
Alternatively, you can download the SuiteAnalytics Connect Browser .chm file that contains only the SuiteAnalytics Connect Browser. To download the file, on your NetSuite home page, find the Settings portlet and click Set Up SuiteAnalytics Connect, then click the Connect Browser link.
After you have downloaded the Connect Browser .chm file, you may need to unblock the file to be able to use it.
To unblock the file:
-
Right-click the .chm file and choose Properties.
-
In the file properties window, click the Unblock button, and then click Apply.
When the file is unblocked, you can open it to work with the Connect Browser.