Skip to main content

Oracle Netsuite

Availability:
Available Airbyte CloudAvailable Airbyte OSSAvailable PyAirbyte
Support Level:
Marketplace
Connector Version:
0.1.3(Last updated 3 months ago)
CDK Version:
0.21.0
Sync Success Rate:
Usage Rate:

One unified business management suite, encompassing ERP/Financials, CRM and ecommerce for more than 31,000 customers.

This connector implements the SuiteTalk REST Web Services and uses REST API to fetch the customers data.

  • Oracle NetSuite account
  • Allowed access to all Account permissions options
  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret
  1. Create account on Oracle NetSuite
  2. Confirm your Email
  1. Login into your NetSuite account
  2. Go to Setup » Company » Company Information
  3. Copy your Account ID (Realm). It should look like 1234567 for the Production env. or 1234567_SB2 - for a Sandbox
  1. Go to Setup » Company » Enable Features
  2. Click on SuiteCloud tab
  3. Scroll down to SuiteScript section
  4. Enable checkbox for CLIENT SUITESCRIPT and SERVER SUITESCRIPT
  5. Scroll down to Manage Authentication section
  6. Enable checkbox TOKEN-BASED AUTHENTICATION
  7. Scroll down to SuiteTalk (Web Services)
  8. Enable checkbox REST WEB SERVISES
  9. Save the changes
  1. Go to Setup » Integration » Manage Integrations » New
  2. Fill the Name field (we recommend to put airbyte-rest-integration for a name)
  3. Make sure the State is enabled
  4. Enable checkbox Token-Based Authentication in Authentication section
  5. Save changes
  6. After that, Consumer Key and Consumer Secret will be showed once (copy them to the safe place)
  1. Go to Setup » Users/Roles » Manage Roles » New
  2. Fill the Name field (we recommend to put airbyte-integration-role for a name)
  3. Scroll down to Permissions tab
  4. (REQUIRED) Click on Transactions and manually add all the dropdown entities with either full or view access level.
  5. (REQUIRED) Click on Reports and manually add all the dropdown entities with either full or view access level.
  6. (REQUIRED) Click on Lists and manually add all the dropdown entities with either full or view access level.
  7. (REQUIRED) Click on Setup and manually add all the dropdown entities with either full or view access level.
  • Make sure you've done all REQUIRED steps correctly, to avoid sync issues in the future.
  • Please edit these params again when you rename or customise any Object in Netsuite for airbyte-integration-role to reflect such changes.
  1. Go to Setup » Users/Roles » Manage Users
  2. In column Name click on the user’s name you want to give access to the airbyte-integration-role
  3. Then click on Edit button under the user’s name
  4. Scroll down to Access tab at the bottom
  5. Select from dropdown list the airbyte-integration-role role which you created in step 2.4
  6. Save changes
  1. Go to Setup » Users/Roles » Access Tokens » New
  2. Select an Application Name
  3. Under User select the user you assigned the airbyte-integration-role in the step 2.4
  4. Inside Role select the one you gave to the user in the step 2.5
  5. Under Token Name you can give a descriptive name to the Token you are creating (we recommend to put airbyte-rest-integration-token for a name)
  6. Save changes
  7. After that, Token ID and Token Secret will be showed once (copy them to the safe place)

You have copied next parameters

  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret Also you have properly Configured Account with Correct Permissions and Access Token for User and Role you've created early.
  1. Log into your Airbyte Cloud 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 type dropdown and enter a name for this connector.
  4. Add Realm
  5. Add Consumer Key
  6. Add Consumer Secret
  7. Add Token ID
  8. Add Token Secret
  9. Click Set up source.
  1. Go to local Airbyte page.
  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 type dropdown and enter a name for this connector.
  4. Add Realm
  5. Add Consumer Key
  6. Add Consumer Secret
  7. Add Token ID
  8. Add Token Secret
  9. Click Set up source

The NetSuite source connector supports the following sync modes:

  • Full Refresh
  • Incremental
  • Streams are generated based on ROLE and USER access to them as well as Account settings, make sure you're using the correct role assigned in our case airbyte-integration-role or any other custom ROLE granted to the Access Token, having the access to the NetSuite objects for data sync, please refer to the Setup guide > Step 2.4 and Setup guide > Step 2.5

The connector is restricted by Netsuite Concurrency Limit per Integration.

Config fields reference

Field
Type
Property name
string
realm
string
consumer_key
string
consumer_secret
string
token_key
string
token_secret
string
start_datetime
array<string>
object_types
integer
window_in_days
Expand to review
VersionDatePull RequestSubject
0.1.32023-01-2021645Minor issues fix, Setup Guide corrections for public docs
0.1.12022-09-2817304Migrate to per-stream state
0.1.02022-09-1516093Initial Alpha release
Was this page helpful?