NetSuite Query Authentication Guide
This is a step-by-step guide to acquiring credentials for authorizing the NetSuite Query component for use in Matillion ETL.
The NetSuite Query connector uses an OAuth for third-party authentication.
While connector properties may differ between cloud data warehouses, the authentication process remains the same.
The NetSuite Query connector uses either a username and password or an OAuth for third-party authentication. This guide will only explain the OAuth method. Please read the Deprecation Warning in NetSuite Query for more information.
Begin by creating an OAuth entry in Matillion ETL, as described in Manage OAuth. You should then configure this OAuth entry using the NetSuite credentials, obtained as described below.
Ensure the NetSuite account used to configure authentication is either an administrator account or an account with full permission to set up integrated apps.
Acquiring third-party credentials
- Navigate to the NetSuite portal and click Log In in the upper-right of the page. Enter valid login credentials to continue.
- The browser will redirect to the NetSuite Home dashboard. On the header menu, click Setup → Company → Company Information.
- On the Company Information page, copy the ACCOUNT ID string, as it will be required to configure the OAuth in Matillion ETL.
- On the header menu, click Setup → Integration → Manage Integrations → New.
- On the Integration page, provide details for the following fields then click Save:
- NAME: Provide a name for the app.
- CALLBACK URL: Paste the Callback URL copied from the Manage OAuth window in Matillion ETL.
- USER CREDENTIALS: Select the checkbox if you are using User Credentials to authenticate your NetSuite Query component in Matillion ETL. Do not select the checkbox if you are using OAuth 2.0 to authenticate your component.
- The browser will then redirect to a page with a green banner that says Confirmation. This page will list the details of the newly created app. At the bottom of the page, copy the strings for CONSUMER KEY and CONSUMER SECRET as they will be required to configure the OAuth in Matillion ETL.
- Make sure to copy the CONSUMER KEY and CONSUMER SECRET immediately as they will only appear once.
- When copying these values, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.
On the header menu, click Setup → Company → Enable Features.
On the Enable Features page, click SuiteCloud. Then, scroll down to the SuiteScript section and select the checkboxes next to CLIENT SUITESCRIPT and SERVER SUITESCRIPT.
Scroll down further to the Manage Authentication section and select the checkbox next to TOKEN-BASED AUTHENTICATION. Then, click Save.
Click the Home icon to return to the Home dashboard. Then, in the Settings block on the left, click Manage Access Tokens.
The Home dashboard can be personalized, so you will need to add the Settings block to the dashboard if you can't currently see it. To add it to the dashboard, click Personalize in the top right of page and select Settings from the available options.
Now, on the My Access Tokens page, click New My Access Token.
On the next page, for APPLICATION NAME, select the integration app you created earlier. The TOKEN NAME field will be automatically populated based on your selection and must not be edited. Click Save.
The browser will then redirect to a page with a green banner that says Confirmation. Details of the newly created access token will be listed. At the bottom of this page, copy the values for TOKEN ID and TOKEN SECRET, as they will be required to configure the OAuth in Matillion ETL.
- Make sure to copy the TOKEN ID and TOKEN SECRET immediately, as they will only appear once.
- When copying these values, some browsers may add a space to the end of the string. Watch out for this, as it will cause the credentials to fail.
- Return to the Manage OAuth dialog in Matillion ETL to complete the OAuth configuration.