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
- Create account on Oracle NetSuite
- Confirm your email
Step 2: Set up your NetSuite account
Step 2.1: Get Realm information
- Sign in to your NetSuite account
- Go to Setup » Company » Company Information
- Copy your Account ID (Realm). It should look like 1234567 for the
Productionenv. or 1234567_SB2 for aSandbox
Step 2.2: Enable features
- Go to Setup » Company » Enable Features
- Select the SuiteCloud tab
- Scroll to the SuiteScript section
- Select the checkboxes for
CLIENT SUITESCRIPTandSERVER SUITESCRIPT - Scroll to the Manage Authentication section
- Select the
TOKEN-BASED AUTHENTICATIONcheckbox - Scroll to SuiteTalk (Web Services)
- Select the
REST WEB SERVISEScheckbox - Save your changes
Step 2.3: Create Integration and get Consumer Key and Consumer Secret
- Go to Setup » Integration » Manage Integrations » New
- Complete the Name field.
airbyte-rest-integrationis the recommended name. - Confirm that State is
enabled - Select the
Token-Based Authenticationcheckbox in the Authentication section - Save your changes
- Consumer Key and Consumer Secret will appear once. Copy them to a safe place.
Step 2.4: Set up the Role
- Go to Setup » Users/Roles » Manage Roles » New
- Complete the Name field.
airbyte-integration-roleis the recommended name. - Scroll to the Permissions tab
- (REQUIRED) Select
Transactions. Manuallyaddevery dropdown entity with eitherfullorviewaccess level. - (REQUIRED) Select
Reports. Manuallyaddevery dropdown entity with eitherfullorviewaccess level. - (REQUIRED) Select
Lists. Manuallyaddevery dropdown entity with eitherfullorviewaccess level. - (REQUIRED) Select
Setup. Manuallyaddevery dropdown entity with eitherfullorviewaccess level.
- Complete all
REQUIREDsteps correctly to avoid future sync issues. - Edit these parameters again whenever you
renameorcustomiseanyObjectin Netsuite. This allowsairbyte-integration-roleto reflect those changes.
Step 2.5: Set up the User
- Go to Setup » Users/Roles » Manage Users
- In the
Namecolumn, select the user’s name you want to grant access to theairbyte-integration-role - Select the Edit button under the user’s name
- Scroll to the Access tab at the bottom
- From the dropdown list, select the
airbyte-integration-rolerole you created in step 2.4 - Save your changes
Step 2.6: Create an Access Token for the role
- Go to Setup » Users/Roles » Access Tokens » New
- Select an Application Name
- Under User, select the user you assigned the
airbyte-integration-rolein step 2.4 - Inside Role, select the one you assigned to the user in step 2.5
- Under Token Name, give the Token a descriptive name.
airbyte-rest-integration-tokenis the recommended name. - Save your changes
- 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
- Log into your Airbyte Cloud account.
- Select Sources in the left navigation bar. Then select + new source in the top-right corner.
- On the source setup page, select NetSuite from the Source type dropdown. Enter a name for this connector.
- Add Realm
- Add Consumer Key
- Add Consumer Secret
- Add Token ID
- Add Token Secret
- Select
Set up source.
Airbyte OSS
- Go to your local Airbyte page.
- Select Sources in the left navigation bar. Then select + new source in the top-right corner.
- On the source setup page, select NetSuite from the Source type dropdown. Enter a name for this connector.
- Add Realm
- Add Consumer Key
- Add Consumer Secret
- Add Token ID
- Add Token Secret
- 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,USERaccess to streams andAccountsettings. - Use the correct assigned role, such as
airbyte-integration-rolein this case, or another customROLEgranted 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
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.1.29 | 2026-09-15 | 79191 | Emit warning and fail sync when >50% of records are silently skipped due to NetSuite workflow locks (USER_ERROR) |
| 0.1.28 | 2026-08-17 | 79654 | Fix 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.27 | 2025-10-14 | 67787 | Update dependencies |
| 0.1.26 | 2025-10-07 | 67429 | Update dependencies |
| 0.1.25 | 2025-09-30 | 66934 | Update dependencies |
| 0.1.24 | 2025-09-24 | 66623 | Update dependencies |
| 0.1.23 | 2025-09-09 | 65813 | Update dependencies |
| 0.1.22 | 2025-08-23 | 65215 | Update dependencies |
| 0.1.21 | 2025-08-16 | 61055 | Update dependencies |
| 0.1.20 | 2025-08-12 | 63698 | Add support for german date format in NetSuite input |
| 0.1.19 | 2025-05-24 | 60581 | Update dependencies |
| 0.1.18 | 2025-05-10 | 60086 | Update dependencies |
| 0.1.17 | 2025-05-03 | 59481 | Update dependencies |
| 0.1.16 | 2025-04-27 | 59091 | Update dependencies |
| 0.1.15 | 2025-04-19 | 58531 | Update dependencies |
| 0.1.14 | 2025-04-12 | 57860 | Update dependencies |
| 0.1.13 | 2025-04-05 | 57301 | Update dependencies |
| 0.1.12 | 2025-03-29 | 56692 | Update dependencies |
| 0.1.11 | 2025-03-22 | 56060 | Update dependencies |
| 0.1.10 | 2025-03-08 | 55455 | Update dependencies |
| 0.1.9 | 2025-03-05 | 55207 | Add support for additional date format in Netsuite input |
| 0.1.8 | 2025-03-01 | 54821 | Update dependencies |
| 0.1.7 | 2025-02-22 | 54363 | Update dependencies |
| 0.1.6 | 2025-02-15 | 53853 | Update dependencies |
| 0.1.5 | 2025-02-08 | 53243 | Update dependencies |
| 0.1.4 | 2024-07-29 | 42857 | Migrate connector to Poetry |
| 0.1.3 | 2023-01-20 | 21645 | Minor issues fix, Setup Guide corrections for public docs |
| 0.1.1 | 2022-09-28 | 17304 | Migrate to per-stream state |
| 0.1.0 | 2022-09-15 | 16093 | Initial Alpha release |