Advanced Analytica Advanced Analytica: IBOM
← All connectors
Netsuite logo

Source connector

Netsuite

Set up Netsuite as a source and move its data into your chosen destination.

Version 0.1.29 community alpha

Oracle Netsuite

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

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

Prerequisites

  • Oracle NetSuite account
  • Access to all Account permissions options

Airbyte OSS and Airbyte Cloud

  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

Setup guide

Step 1: Create a NetSuite account

  1. Create account on Oracle NetSuite
  2. Confirm your email

Step 2: Set up your NetSuite account

Step 2.1: Get Realm information

  1. Sign in to 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

Step 2.2: Enable features

  1. Go to Setup » Company » Enable Features
  2. Select the SuiteCloud tab
  3. Scroll to the SuiteScript section
  4. Select the checkboxes for CLIENT SUITESCRIPT and SERVER SUITESCRIPT
  5. Scroll to the Manage Authentication section
  6. Select the TOKEN-BASED AUTHENTICATION checkbox
  7. Scroll to SuiteTalk (Web Services)
  8. Select the REST WEB SERVISES checkbox
  9. Save your changes

Step 2.3: Create Integration and get Consumer Key and Consumer Secret

  1. Go to Setup » Integration » Manage Integrations » New
  2. Complete the Name field. airbyte-rest-integration is the recommended name.
  3. Confirm that State is enabled
  4. Select the Token-Based Authentication checkbox in the Authentication section
  5. Save your changes
  6. Consumer Key and Consumer Secret will appear once. Copy them to a safe place.

Step 2.4: Set up the Role

  1. Go to Setup » Users/Roles » Manage Roles » New
  2. Complete the Name field. airbyte-integration-role is the recommended name.
  3. Scroll to the Permissions tab
  4. (REQUIRED) Select Transactions. Manually add every dropdown entity with either full or view access level.
  5. (REQUIRED) Select Reports. Manually add every dropdown entity with either full or view access level.
  6. (REQUIRED) Select Lists. Manually add every dropdown entity with either full or view access level.
  7. (REQUIRED) Select Setup. Manually add every dropdown entity with either full or view access level.
  • Complete all REQUIRED steps correctly to avoid future sync issues.
  • Edit these parameters again whenever you rename or customise any Object in Netsuite. This allows airbyte-integration-role to reflect those changes.

Step 2.5: Set up the User

  1. Go to Setup » Users/Roles » Manage Users
  2. In the Name column, select the user’s name you want to grant access to the airbyte-integration-role
  3. Select the Edit button under the user’s name
  4. Scroll to the Access tab at the bottom
  5. From the dropdown list, select the airbyte-integration-role role you created in step 2.4
  6. Save your changes

Step 2.6: Create an Access Token for the role

  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 step 2.4
  4. Inside Role, select the one you assigned to the user in step 2.5
  5. Under Token Name, give the Token a descriptive name. airbyte-rest-integration-token is the recommended name.
  6. Save your changes
  7. Token ID and Token Secret will appear once. Copy them to a safe place.

Step 2.7: Summary

You’ve copied these parameters:

  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

You’ve also correctly Configured Account with Correct Permissions and Access Token for the User and Role you created earlier.

Step 3: Set up the source connector in Airbyte

Airbyte Cloud

  1. Log into your Airbyte Cloud account.
  2. Select Sources in the left navigation bar. Then select + new source in the top-right corner.
  3. On the source setup page, select NetSuite from the Source type dropdown. 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. Select Set up source.

Airbyte OSS

  1. Go to your local Airbyte page.
  2. Select Sources in the left navigation bar. Then select + new source in the top-right corner.
  3. On the source setup page, select NetSuite from the Source type dropdown. 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. Select Set up source

Supported sync modes

The NetSuite source connector supports these sync modes:

  • Full Refresh
  • Incremental

Supported streams

  • Stream generation depends on ROLE, USER access to streams and Account settings.
  • Use the correct assigned role, such as airbyte-integration-role in this case, or another custom ROLE granted to the Access Token.
  • The role must have access to the NetSuite objects required for data sync.
  • See Setup guide > Step 2.4 and Setup guide > Step 2.5.

Performance considerations

The connector is restricted by Netsuite Concurrency Limit per Integration.

IP allow list

If you use Airbyte Cloud and your organisation restricts access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
0.1.292026-09-1579191Emit warning and fail sync when >50% of records are silently skipped due to NetSuite workflow locks (USER_ERROR)
0.1.282026-08-1779654Fix incremental sync permanently dropping records modified between the sync time and account-local midnight; retry a rejected date format on the same slice instead of skipping it
0.1.272025-10-1467787Update dependencies
0.1.262025-10-0767429Update dependencies
0.1.252025-09-3066934Update dependencies
0.1.242025-09-2466623Update dependencies
0.1.232025-09-0965813Update dependencies
0.1.222025-08-2365215Update dependencies
0.1.212025-08-1661055Update dependencies
0.1.202025-08-1263698Add support for german date format in NetSuite input
0.1.192025-05-2460581Update dependencies
0.1.182025-05-1060086Update dependencies
0.1.172025-05-0359481Update dependencies
0.1.162025-04-2759091Update dependencies
0.1.152025-04-1958531Update dependencies
0.1.142025-04-1257860Update dependencies
0.1.132025-04-0557301Update dependencies
0.1.122025-03-2956692Update dependencies
0.1.112025-03-2256060Update dependencies
0.1.102025-03-0855455Update dependencies
0.1.92025-03-0555207Add support for additional date format in Netsuite input
0.1.82025-03-0154821Update dependencies
0.1.72025-02-2254363Update dependencies
0.1.62025-02-1553853Update dependencies
0.1.52025-02-0853243Update dependencies
0.1.42024-07-2942857Migrate connector to Poetry
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
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.