Skip to main content

Connect to NetSuite

NetSuite uses Token-Based Authentication (TBA) to authenticate connections made through SuiteAnalytics Connect, NetSuite's service for accessing your account data outside of the NetSuite web interface. Before connecting Data Hub to NetSuite, you need to enable TBA in your NetSuite account, create an integration record, set up a dedicated role with the required permissions, and generate an access token.

Note: Data Hub connects to NetSuite using the NetSuite2.com data source. The original NetSuite.com data source was removed in NetSuite 2026.1 and is no longer supported. If you are currently using a NetSuite.com-based connection, you need to migrate to NetSuite2.com.

Prerequisite Tasks

You need NetSuite administrator access to complete these steps.

Step 1: Enable SuiteAnalytics Connect

  1. In NetSuite, go to Setup > Company > Enable Features > Analytics.
  2. Select the checkbox for SuiteAnalytics Connect.
  3. Select Save.

Note: SuiteAnalytics Connect is an add-on feature and may not be included in your NetSuite subscription. If you do not see it listed, contact NetSuite Customer Support or your account manager.

For more information, see Enabling the SuiteAnalytics Connect Service Feature in the NetSuite Documentation.

Step 2: Enable Token-Based Authentication

  1. In NetSuite, go to Setup > Company > Enable Features > SuiteCloud > Manage Authentication.
  2. Select Token-Based Authentication.
  3. Select Save.

For more information, see Token-Based Authentication in the NetSuite Documentation.

Step 3: Create an integration record

The integration record represents Data Hub in your NetSuite account and generates the Consumer Key and Consumer Secret needed for the connection.

  1. Go to Setup > Integrations > Manage Integrations.
  2. Select New.
  3. Enter a name for the integration. For example, Data Hub.
  4. Under Authentication, select Token-Based Authentication. Clear TBA: Issue Token Endpoint, TBA: Authorization Flow, and OAuth 2.0 fields, and User Credentials.
  5. Select Save.
  6. Copy the Consumer Key and Consumer Secret values and store them securely.

    Important: These values are displayed only once and cannot be retrieved after you leave this page.

For more information, see Create Integration Records for Applications to Use TBA in the NetSuite Documentation.

Step 4: Create a role and assign permissions

You can use an existing role if it already has the required permissions, or create a new one.

  1. Go to Setup > User/Roles > Manage Roles > New.
  2. Enter a name for the role. For example, Data Hub Integration Role.
  3. On the Permissions tab, assign the following permissions:
    Permission Type Level

    SuiteAnalytics Connect

    Setup

    Full

    SuiteAnalytics Workbook

    Reports

    Edit

    Custom Segments

    Setup

    View

    Log in using Access Tokens

    Setup

    Full

    REST Web Services

    Setup

    Full

  4. Select Save.

Note: The permissions above are required to establish the connection. Depending on the tables you want to replicate, you may need to assign additional permissions. For a full reference of available permissions by table, download the NetSuite Permissions Reference. The permissions available in your account depend on which modules are active.

For more information, see Requirements for Using Token-based Authentication in Connect in the NetSuite Documentation.

Step 5: Assign the role to a user

  1. Go to Lists > Employees > Employees and open the user you want to use for the integration.
  2. Select the Access tab, then the Roles subtab.
  3. Add the role you created in Step 4.
  4. Select Save.

For more information, see Assigning Roles to an Employee in the NetSuite Documentation.

Step 6: Generate an access token

The access token generates the Token ID and Token Secret needed for the connection.

  1. Go to Setup > User/Roles > Access Tokens > New.
  2. In the Application Name field, select the integration record you created in Step 3.
  3. In the User field, select the integration user from Step 5.

    Note: If the user does not appear in the list, verify that the role has been assigned to the user and includes the required permissions.

  4. In the Role field, select the role from Step 4.
  5. Select Save.
  6. Copy the Token ID and Token Secret values and store them securely.

    Important: These values are displayed only once and cannot be retrieved after you leave this page.

For more information, see Setting Up Token-Based Authentication (TBA) - Tutorial in the NetSuite Documentation.

Create a Connection

Once you have completed the prerequisites, you are ready to set up the connection in Data Hub.

  1. In Data Hub, go to Connections and select Add Connection.
  2. Search for and select NetSuite.

Basics tab

  1. Replication Environment: A replication environment is a dedicated infrastructure layer that Data Hub uses to extract and stage data from NetSuite. Your organization's default environment is selected. Select Set ERP to assign this environment to the NetSuite data source.

    • If you need to add a new environment, select Provision and complete the following fields:

      Field Description

      Environment Name

      A name for the environment as it will appear across Data Hub, for example, Production.

      ERP

      Defaults to NetSuite.

      Hosting Region

      The AWS region where replicated data will be stored. Defaults to US East (N. Virginia) based on your organization's region (NA). If your organization has data residency or compliance requirements, select the appropriate region before proceeding.

      Select Start Provisioning. Provisioning may take up to 30 minutes. You will receive an email notification when provisioning completes or if it encounters an issue. Once complete, select Continue. The replicated data endpoint is created, and the environment is now available for selection.

      Note: Each connection requires a dedicated replication environment. Once assigned, the environment is dedicated to that ERP and cannot be shared or reassigned. The number of connections you can create depends on your organization's subscription.

  1. Enter a Connection Name and an optional Description.
  2. Select Next.

Connect tab

Fill in the following fields:

Field Description Where to get it?

Account ID

Your NetSuite account identifier.

In NetSuite, go Set Up SuiteAnalytics Connect.

Service Host

The hostname used to connect to NetSuite.

In NetSuite, go Set Up SuiteAnalytics Connect. Use the format <account>.connect.api.netsuite.com, where <account> is your NetSuite account ID.

Consumer Key

The key generated when you created the integration record in NetSuite.

Copy from the integration record in Step 3 of the prerequisites.

Consumer Secret

The secret paired with the Consumer Key.

Copy from the integration record in Step 3 of the prerequisites.

Token ID

The token ID generated when you created the access token in NetSuite.

Copy from the access token in Step 6 of the prerequisites.

Token Secret

The secret paired with the Token ID.

Copy from the access token in Step 6 of the prerequisites.

Role ID

The role ID from your NetSuite configuration.

In NetSuite, go to Set Up Suite Analytics. Can also be found in the web address when logged into NetSuite. For example, roleid=57.

Important: Ensure no extra spaces are copied from NetSuite into any of the fields above, as this will cause the connection to fail.

Select Test Connection to verify the connection, then select Next. A successful connection test is required before you can create the connection.

Advanced tab

The following settings are pre-configured with required values. You only need to change them if your environment has specific requirements.

Field Description Value

Driver Path

The file path to the NetSuite SuiteAnalytics ODBC driver.

/opt/netsuite/odbcclient/lib64/ivoa27.so

Port

The port used to connect to the NetSuite SuiteAnalytics Connect service.

1708

Encrypted

Controls whether the connection to NetSuite is encrypted.

Enabled

Trust Store

The file path to the SSL certificate used to verify the NetSuite connection.

/opt/netsuite/odbcclient/cert/ca4.cer

Select Create Connection.

Your NetSuite data source is ready and appears on the Connections page. Data Hub creates predefined replication tasks once data is pulled in. See the Data Replication section for more information.

Was this article helpful?

We're sorry to hear that.