Source Netsuite
Airbyte Enterprise Connectors are a selection of premium connectors available exclusively for Airbyte Self-Managed Enterprise and Airbyte Teams customers. These connectors, built and maintained by the Airbyte team, provide enhanced capabilities and support for critical enterprise systems. To learn more about enterprise connectors, please talk to our sales team.
Airbyte’s incubating Netsuite enterprise source connector currently offers Full Refresh and cursosr-based Incremental syncs for streams.
Features
| Feature | Supported?(Yes/No) | Notes |
|---|---|---|
| Full Refresh Sync | Yes | |
| Incremental Sync | Yes |
Prequisities
- Dedicated read-only Airbyte user with read-only access to tables needed for replication
- A Netsuite environment using SuiteAnalytics Connect and the Netsuite2.com data source for integrations
- Airbyte does not support connecting over SSL using custom Certificate Authority (CA)
Setup Guide
Requirements
- Host: Service hostname
- Port: Service port (Typically 1708)
- Account ID: Identifies the Netsuite account (not the individual user account)
- Authentication method: Select between username and password or token based authentication to connect with a Netsuite user account to connect with Airbyte. See details below.
- Role: A user role with sufficient access on Netsuite for all tables to be replicated and is assigned to the user account
To find details such as host, port, Account ID and role go on Netsuite home page, scroll down to Settings at the bottom left and click "Set Up SuiteAnalytics Connect".
Note: the role controls what is visible and not to the connector. At a minimum the "SuiteAnalytics Connect" permission is required to connect to SuiteAnalytics over JDBC, as described in Netsuite SuiteAnalytics documentations
Authentication Methods
Source Netsuite supports two authentication methods: username and password and Token Based Authentication (TBA).
Username and Password
Fill in the username and password of the Netsuite user account. Ensure that the Role ID is assigned to this user (this can be done in the Netsuite UI by navigating to Setup > Users/Roles > Manage Users and selecting the user). The role must have sufficient permissions to access all the tables you want to replicate.
Token Based Authentication (TBA)
Airbyte requires the following details in order to set up TBA:
- Client ID (Consumer Key)
- Client Secret (Consumer Secret)
- Token ID
- Token Secret
The values are generated on netsuite as follows:
- Confirm the following features are enabled in Netsuite (Setup > Company > Enable Features > SuiteCloud)
- Client SuiteScript
- Server SuiteScript
- Token Based Authentication
- Create an Integration Record (Setup > Integration > Manage Integrations > New)
- Check the "Token Based Authentication" box only. (No need for TBA Authorization Flow)
- Upon creation copy and save the Consumer Key and Consumer Secret.
- Create an access token (Setup > Users/Roles > Access Tokens > New)
- Select the application you just created - this is the integration record name created in step 2.
- Select the user you want to use for the token. This user must have a role with the "Log in using Access Tokens" permission, in addition to "SuiteAnalytics Connect".
- Select the role you want to use for the token. This would typically be the "Data Warehouse Integrator" role.
- Upon creation copy and save the Token ID and Token Secret values.
- On the Airbyte source-netsuite's config page fill-in the Client ID, Client Secret, Token ID and Token Secret values and the role ID for the role the token was created for in step 3.
- Confirm Netsuite is accessible by clicking the "Test and save" button.