ODBC Driver for NetSuite

NetSuite Token-Based Authentication

Connecting to NetSuite Using Token-Based Authentication

You can connect to NetSuite using Token-Based Authentication (TBA) by providing your account ID, consumer key, consumer secret, and access token. This authentication method ensures secure access without requiring user credentials, enhancing both security and automation in your integration.

Note: For instructions on how to obtain an account ID, see Obtaining a NetSuite Account ID.

Perform the following actions to enable the token-based authentication in NetSuite.

Enabling the Token-Based Authentication

  1. Select Setup > Company > Enable Features.
  2. NetSuite Enable Features

  3. Then click SuiteCloud.
  4. Select SuiteCloud in Enable Features

  5. In Manage Authentication, select the Token-Based Authentication checkbox.

Select Token-Based Authentication and OAUTH 2.0 checkboxes

Creating a Role

Create a role with the necessary permissions for the objects you would like to use.
  1. Select Setup > User/Roles > Manage Roles > New.
  2. Assign the necessary permissions for the integration with the ODBC driver.
Note: You can grant the following permissions in Setup: All available permissions can be found in the Transactions and Lists panes of NetSuite. At a minimum, SOAP Web Services and User Access Tokens permissions are required.
  1. Select Lists > Employees > Edit User > Access Roles > Roles, then assign this role to the required user.

Creating an Integration Record

  1. Select Setup > Integration > Manage Integrations > New.
  2. Select Setup > Integration > Manage Integrations > New

  3. Enter a Name for the application, select Token-Based Authentication, and deselect TBA: Authorization Flow.
  4. Enter an application name and select Token-Based Authentication checkbox in the Integration window

  5. Click Save.
  6. In the Confirmation window, copy the Application ID at the top of the Integration pane.
  7. Copy Application ID in the Integration pane

  8. Next, copy the generated Consumer Key / Client ID and Consumer Secret / Client Secret.
    Save these values somewhere because you will not be able to retrieve them after leaving this page. If you need these values again, you will have to re-generate them, which makes the old ones stop working.

    Copy Client Credentials

Creating an Access Token

  1. Select Setup > Users/Roles > Access Tokens > New.
  2. Select Setup > Users/Roles > Access Tokens > New

  3. Select the Integration record, User, and Role created in the previous steps.
  4. Access Token Primary Information

  5. Click Save.
  6. In the Confirmation window, copy the generated Token ID and Token Secret.
    Save these values somewhere because you will not be able to retrieve them after leaving this page. If you need these values again, you will have to re-generate them, which makes the old ones stop working.
  7. Copy the generated Token ID and Token Secret

On finishing the steps outlined earlier, fill in the necessary fields with the obtained Consumer Key / Client ID, Consumer Secret / Client Secret, Token ID, and Token as you configure your DSN settings.

See Also

Windows DSN Configuration

© 2016-2025 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback