Improvado
Esc

Start typing to search.

Improvado
Sign In

Oracle NetSuite

Updated on Jun 26, 2026

Description

‍Oracle NetSuite is the leading integrated cloud business software suite, including business accounting, ERP, CRM and ecommerce software.

Setup guide

Follow our setup guide to connect Oracle NetSuite to Improvado.

‍Step 1. Click the Make a new Connection on the Connections page.
Categories on the Data sources page group all available platforms. Use a search to find the required one.

‍Step 2. Click on the Oracle NetSuite tile.

Choose authorization option:

OAuth 2.0 (recommended)

Improvado does not host a central NetSuite application, so you create your own Integration record in your NetSuite account and provide its Client ID and Client Secret along with your Account ID and Account Name.

‍Step 3.1. Log in to your Oracle NetSuite account.

‍Step 3.2. Enable the required features. Go to Setup > Company > Enable Features > SuiteCloud tab.

  1. In the SuiteTalk (Web Services) section, enable REST Web Services.
  2. In the Manage Authentication section, enable OAuth 2.0.
  3. Save the changes.

‍Step 3.3. Create an Integration record to obtain your Client ID and Client Secret.

  1. Go to Setup > Integration > Manage Integrations > New.
  2. Fill in the Name field (we recommend using improvado-oauth2-integration).
  3. Make sure the State is enabled.
  4. In the Authentication section, enable OAuth 2.0 and check Authorization Code Grant. Make sure Token-Based Authentication is not selected.
  5. In the Redirect URI field, enter the Improvado redirect URI for your region:
  • https://connections.improvado.io/stat_provider_client/oauth_redirect/netsuite/
  • https://connections.eu.improvado.io/stat_provider_client/oauth_redirect/netsuite/ (EU region)
  • https://connections.us.improvado.io/stat_provider_client/oauth_redirect/netsuite/ (US region)

Note: If you are not sure which region your Improvado account uses, enter the default (first) redirect URI.

  1. Save the changes.
  2. Copy the Client ID (Consumer Key) and Client Secret (Consumer Secret) that will be shown only once.

‍Step 3.4. Set up a Role and assign it to the user who will authorize the connection.

  1. Go to Setup > Users/Roles > Manage Roles > New (we recommend using improvado-integration-role).
  2. In the Permissions tab, add Log in using OAuth 2.0 Access Tokens and REST Web Services, plus full or view access to the following required permissions:
Access level Permission
full/view access Transactions
Reports
Lists
Setup
  1. Assign the role to the user under Setup > Users/Roles > Manage Users > (select user) > Access tab.

‍Step 3.5. Copy your Account ID. Go to Setup > Company > Company Information and copy your Account ID (Realm).

‍Step 3.6. In the Improvado authorization form, select OAuth 2.0, enter your Account ID, Account Name, Client ID and Client Secret, then click Authorize, sign in to NetSuite, and select the role you created.

Token-Based Authentication (legacy)

To authorize your account, you need to fill in the required fields below following steps 3.1 - 3.9:

  • Account Name
  • Account ID
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

Login into your Oracle NetSuite account.

‍Step 3.2. Go to Setup > Company > Company Information.

‍Step 3.3. Copy your Account ID (Realm) and Account Name.

‍Step 3.4. Enable features.

  1. Go to Setup > Company > Enable Features.
  2. Select SuiteCloud tab.
  3. In SuiteScript section, enable checkboxes for CLIENT SUITESCRIPT and SERVER SUITESCRIPT.
  4. In Manage Authentication section, enable the checkbox TOKEN-BASED AUTHENTICATION.
  5. In SuiteTalk (Web Services) section, enable the checkbox REST WEB SERVICES.
  6. Save the changes.

Create Integration (obtain Consumer Key and Consumer Secret).

  1. Go to Setup > Integration > Manage Integrations > New.
  2. Fill in the Name field (we recommend using improvado-rest-integration).
  3. Make sure the State is enabled.
  4. Enable Token-Based Authentication checkbox in the Authentication section.
  5. Make sure that no other authentication method is selected.
  6. Save changes.
  7. Copy Consumer Key and Consumer Secret that will be shown only once.

Setup Role.

  1. Go to Setup > Users/Roles > Manage Roles > New.
  2. Fill in the Name field (we recommend using improvado-integration-role).
  3. In the Permissions tab, manually add all the dropdown entities with either full or view access level for the following required permissions to avoid sync issues in the future:
Access level Permission
full/view access Transactions
Reports
Lists
Setup

Important: Please edit these params again when you rename or customize any Object in Oracle NetSuite for improvado-integration-role to reflect such changes.

‍Step 3.7. Setup User.

  1. Go to Setup > Users/Roles > Manage Users.
  2. In Name column, click on the user’s name you want to give access to the improvado-integration-role.
  3. Click on Edit button under the user’s name.
  4. Click on Access tab at the bottom of the page.
  5. Select the improvado-integration-role role, which you created in step 3.6 from the drop-down list.
  6. Save changes.

Create Access Token for the role.

  1. Go to Setup > Users/Roles > Access Tokens > New.
  2. Select an Application Name.
  3. In User section, select the user you assigned the improvado-integration-role in step 3.7.
  4. In Role section, select the role you gave to the user in step 3.6.
  5. Fill in Token Name with a descriptive name to the new Token (we recommend using improvado-rest-integration-token).
  6. Save changes.
  7. Copy Token ID and Token Secret that will be shown only once.

Enter copied values into the Improvado authorization form.

Also, you can find the additional information here: Oracle NetSuite Applications Suite - SuiteTalk REST Web Services API Guide.

‍

‍Step 4. After completing the connection process, the Oracle NetSuite connection will appear in your Connected sources list.

‍Step 5. When the connection status is Active, and the account status column shows a number of accounts, you can move on to data extraction.

To extract data from the connected sources, check the instruction on how to set up data extraction.

Schema information

The schema information shows all report types you can use to extract data from Oracle NetSuite.

Release notes

You can find information about the latest API changes in the official Release notes.

Was this article helpful?