Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting NetSuite

To connect NetSuite to Stitch, you'll need to do the following:

  1. Create a NetSuite Admin user for Stitch
  2. Retrieve the NetSuite user's Role ID
  3. Enter your NetSuite credentials into Stitch
  4. Define the Replication Frequency
  5. Select tables to sync

Creating a NetSuite Admin User for Stitch

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.

Retrieving the NetSuite User's Role ID

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.

How do I find the Role ID?

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:

The Role ID in NetSuite.
Click for a closer look!

Once you have the Role ID for the user, you can move onto entering the credentials in Stitch.

What if I don't see the Internal ID column?

If you don't see this column in the list, you may need to add it.

  1. Click the Edit View button.
  2. Click the dropdown and select Internal ID.
  3. Click Add.
  4. Click Save.

After you add the column to the Roles list, locate the ID for the user and move onto the next step.

Entering Your NetSuite Credentials into Stitch

After the Stitch user has been created, enter the user credentials in Stitch:

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the NetSuite icon.
  3. Enter a name for the integration. This is the name that will display on the Stitch dashboard for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch NetSuite” would create a schema called stitch_netsuite in the data warehouse.
  4. Enter the email address and password associated with the NetSuite user you want to use to connect the account to Stitch.
  5. Enter the Role ID - the numerical ID, not the name of the Role - associated with the user entered above.

    Note that if this field is left blank, Stitch will use NetSuite's default role ID for Admin roles, which is 3. If you receive an error when trying to save the integration, enter a 3 in this field and try saving again.
  6. Select the Account Type - Production or Sandbox.

Defining the Replication Frequency

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.

Selecting Tables to Sync

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.

RELATED:

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!