Step 1: Enable SuiteAnalytics

To access your NetSuite data via SuiteAnalytics, you must first enable the SuiteAnalytics Connect feature in your NetSuite account. Follow these steps:

  1. Navigate to Setup > Company > Enable Features.
  2. In the Features list, check the “SuiteAnalytics Connect” box, and save your changes.
  3. Ensure that SuiteAnalytics Connect is enabled for the roles that need access.

Step 2: Create a Specific Role to Use SuiteAnalytics

This role should receive all the same permissions as an admin, but not be an admin. This is important because admin roles are prevented from connecting to data tools / warehouses directly (this took me a pretty long time to figure out!). Make sure this role has access to all subsidiaries. You can use this script to create a role with access to all permissions. Warning — you’ll want to change the permissions from ‘full’ to ‘view only’ because critical mistakes can happen if the wrong users have ‘full’ access to all permissions.

Step 3: Establish the Connection

To access your NetSuite data via your data warehouse or Domo, you’ll need to establish a connection between the two systems. This should be a relatively smooth process in Domo, assuming you have closely followed the steps outlined above.

  • In the bottom left hand corner of your screen, select ‘Set Up SuiteAnalytics Connect’
Options for drivers to download for direct read-only database connection.
  • Populate the Domo credentials as shown in the screen below, referencing the ‘Your configuration’ screen seen in NetSuite.
Domo <> NetSuite setup screen
This is an example of selecting all data from a SuiteAnalytics table for use in Domo dataflows after the fact. There are pros and cons to writing pre-built queries vs. importing one table at a time which we are happy to discuss with anybody making those decisions.
  • Using DataGrip as an example, first navigate to the ‘Database Explorer’ and click on the + icon.
DataGrip Database Explorer
  • Name the data source something relevant like ‘NetSuite JDBC Connection’
  • Set Authentication to ‘User & Password’ and enter in the user email and password associated with your NetSuite role that you’ve created for the purposes of using SuiteAnalytics.
  • In the URL field, enter your JDBC connection string which should look something like this:
jdbc:ns://[yourServiceHostString]:[yourServicePort];ServerDataSource=NetSuite2.com;Encrypted=1;NegotiateSSLClose=false;CustomProperties=(AccountId=[yourAccountId];RoleID=[yourRoleID]);
Sample settings configuration for connecting to SuiteAnalytics via database IDE using JDBC driver.

Step 4: Schedule Data Refresh

To ensure your data is up-to-date, schedule regular data refreshes from NetSuite to your data warehouse or Domo. Depending on your specific tools, you can set up automated refresh jobs or triggers.

Conclusion

Accessing your NetSuite data via a data IDE, a data warehouse or Domo using SuiteAnalytics is a powerful way to unlock deeper insights and drive data-driven decisions within your organization. By following the technical steps outlined in this guide, you can seamlessly integrate and analyze your NetSuite data alongside other critical business data, facilitating more comprehensive reporting and analytics capabilities. Stay ahead of the competition by harnessing the full potential of your NetSuite data through SuiteAnalytics.