To connect NetSuite to Stitch, you'll need to do the following:
If you aren't a NetSuite administrator, we recommend you contact one of your NetSuite admins before adding NetSuite as an integration. Because of the sensitive nature of the data in NetSuite and the limitations of NetSuite's API, we recommend that a Stitch-specific Admin user be created in your NetSuite account. This will ensure that Stitch is easily distinguishable in any logs or audits.
Additionally, a single NetSuite user is only allowed to have a single API session open at a time - if there's another connection elsewhere, you'll encounter issues in Stitch.
All Roles in NetSuite have a Name - for example, Accountant - and Role ID, or Internal ID number. Stitch requires this ID to successfully create a NetSuite integration.
Role IDs can be found on the Manage Roles page in NetSuite. From your dashboard, click Setup > Users/Roles > Manage Roles.
Locate the Role of the user in the Roles list. The ID is located in a column called Internal ID:
Once you have the Role ID for the user, you can move onto entering the credentials in Stitch.
If you don't see this column in the list, you may need to add it.
After you add the column to the Roles list, locate the ID for the user and move onto the next step.
After the Stitch user has been created, enter the user credentials in Stitch:
stitch_netsuitein the data warehouse.
The Replication Frequency setting determines how often Stitch will attempt to replicate data from NetSuite. By default the Replication Frequency is set to 30 minutes, but you can change the interval to better suit your needs.
You can update this setting at any time in the Integration Details page by clicking the Integration Settings button.
When finished, click the Save Integration button.
To finish setting up the integration, you'll need to select the tables you want to sync to your data warehouse.
At this time, Stitch supports syncing NetSuite data at the table level. You can sync and unsync tables at any time. For more info about the tables that will be available for syncing, check out the Expected NetSuite Data article.
Now you can sit back and relax while Stitch replicates your NetSuite data to your data warehouse.