Reactor

NetSuite SuiteTalk REST(Oracle)

Connectors · Updated May 23, 2025

Overview

The Oracle NetSuite connector for Reactor Data facilitates data extraction from your NetSuite account, a unified business management suite encompassing ERP/Financials, CRM, and e-commerce. This connector leverages the SuiteTalk REST Web Services and REST API to fetch customer data and other supported data entities.

Prerequisites

Before setting up the NetSuite connector, ensure you have the following:

  • An Oracle NetSuite account.
  • Allowed access to all Account permissions options within your NetSuite account.

Setup Guide


Step 1: Obtain NetSuite Account Information

  1. Log in to your NetSuite account.
  2. Navigate to Setup » Company » Company Information.
  3. Copy your Account ID (Realm). This will look like 1234567 for a production environment or 1234567_SB2 for a Sandbox environment.

Step 2: Enable Features in NetSuite

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

Step 3: Create Integration (Obtain Consumer Key and Consumer Secret)

  1. Go to Setup » Integration » Manage Integrations » New.
  2. Fill in the Name field (e.g., reactor-rest-integration).
  3. Ensure the State is enabled.
  4. Enable the Token-Based Authentication checkbox in the Authentication section.
  5. Save changes.
  6. After saving, the Consumer Key and Consumer Secret will be displayed once. Copy them to a safe place.

Step 4: Set Up Role

  1. Go to Setup » Users/Roles » Manage Roles » New.
  2. Fill in the Name field (e.g., reactor-integration-role).
  3. Scroll down to the Permissions tab.
  4. REQUIRED: Click on Transactions and manually add all dropdown entities with either full or view access level.
  5. REQUIRED: Click on Reports and manually add all dropdown entities with either full or view access level.
  6. REQUIRED: Click on Lists and manually add all dropdown entities with either full or view access level.
  7. REQUIRED: Click on Setup and manually add all dropdown entities with either full or view access level. 
  • Note: Ensure all REQUIRED steps are completed correctly to prevent future sync issues. If you rename or customize any object in NetSuite, edit these parameters for the reactor-integration-role to reflect the changes.

Step 5: Set Up User

  1. Go to Setup » Users/Roles » Manage Users.
  2. In the Name column, click on the user's name you want to grant access to the reactor-integration-role.
  3. Click the Edit button under the user's name.
  4. Scroll down to the Access tab at the bottom.
  5. Select the reactor-integration-role role (created in Step 4) from the dropdown list.
  6. Save changes.

Step 6: Create Access Token for Role

  1. Go to Setup » Users/Roles » Access Tokens » New.
  2. Select an Application Name.
  3. Under User, select the user you assigned the reactor-integration-role in Step 5.
  4. Inside Role, select the one you gave to the user in Step 5.
  5. Under Token Name, provide a descriptive name for the token (e.g., reactor-rest-integration-token).
  6. Save changes.
  7. After saving, the Token ID and Token Secret will be displayed once. Copy them to a safe place.

Step 7: Set Up the Source Connector in Reactor Data

  1. Log in to your Reactor Data account.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select NetSuite from the Source Catalog list.

Then fill-in the following entries you collected in the Netsuite API setup for each of the steps in the Reactor Source configuration wizard. 

  • SELECT the NETSUITE ENDPOINT in STEP 1 CONNECTOR CONFIGURATION

Complete the remaining entries for STEP 2 PARAMETER CONFIGURATION and STEP 3 AUTH CONFIGURATION from the values you created in Netsuite. 

  • Add the Realm (Account ID) obtained in Step 1.
  • Add the Consumer Key obtained in Step 3.
  • Add the Consumer Secret obtained in Step 3.
  • Add the Token ID obtained in Step 6.
  • Add the Token Secret obtained in Step 6.
  • Click Set up source.

Supported Data Entities

Data entities are generated based on the ROLE and USER access granted to them, as well as Account settings. Ensure the role assigned to the Access Token (e.g., reactor-integration-role) has the necessary access to NetSuite objects for data synchronization.

Refer to Setup Guide > Step 4 and Setup Guide > Step 5 for details on role and user setup.

Performance Considerations

The connector's performance is subject to NetSuite's Concurrency Limit per Integration.

Configuration Fields Reference

Field Type Property Name
Realm (Account ID) Required String
Consumer Key Required String
Consumer Secret Required String
Token Key (Token ID) Required String
Token Secret Required String
Start Date Required String
Object Types Optional Array<string>
Window in Days Optional Integer