ODBC Driver for NetSuite

NetSuite OAuth Authentication

Connecting to NetSuite Using OAuth 2.0 Authentication

You can connect to NetSuite using OAuth 2.0 authentication by providing your account ID, client ID, and client secret. This method eliminates the need for user credentials, ensuring secure and seamless integration with NetSuite services.

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

Perform the following actions to enable Oauth 2.0 authentication in NetSuite.

Enabling Oauth 2.0 Authentication

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

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

  5. In the Manage Authentication pane, select the Oauth 2.0 checkbox.
  6. Select the OAUTH 2.0 checkbox

Creating a Role

Create a role with the necessary permissions for the objects you would like to use. Then, assign this role to the user, who will be used for authentication.
  1. Select Setup > User/Roles > Manage Roles > New.
  2. Assign the SuiteAnalytics Workbook permission in the Reports section.
Note: You can grant the following permissions in Setup to allow API calls: All available permissions can be found in the Transactions and Lists sections.

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.
  4. Enter an application name in the Integration pane

  5. Configure the following property fields for the OAuth 2.0 authentication:
    • Select the Authorization Code Grant checkbox in the OAuth 2.0 pane.
    • In the Redirect URI field, enter https://localhost:60500
    • Select the REST Web Services checkbox.
    • Select the Public Client checkbox.
  6. Configure settings for the OAuth 2.0 authentication in the Integration pane

  7. Click Save.
  8. In the Client Credentials pane, 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.
  9. Copy the credentials for the OAuth 2.0 authentication

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

See Also

Windows DSN Configuration

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