Integrating with NetSuite (Role Based Access)
Last updated
Was this helpful?
Last updated
Was this helpful?
To connect NetSuite to Drivetrain, you need:
An active Oracle NetSuite account
Allowed access to all Account permissions options on the Netsuite account
Admin privileges in Drivetrain
Sign in to your NetSuite instance. Make sure you are logged in as an Administrator.
From the menu bar, navigate to Setup > User/Roles > Manage Roles > New.
In the Role page, fill in a name for the Role, ensure that Accounting Center is selected as 'CENTER TYPE' and click Save.
In case you have subsidiaries enabled, please select 'ALL' subsidiaries and 'ALLOW CROSS SUBSIDIARY RECORD VIEWING'.
Please select ALL Accounting Books.
Now you'll add permissions for the Role as per the List of Permissions with Levels given below. The exact list may vary depending on the fields required for metric calculations specific to your use cases.
Transactions and Lists fields require 'View' permission.
Reports fields require 'View' permission. However, Report Customization requires 'Full' access.
Setup fields requires 'Full' access.
Note: Permission Rest Web Services is mandatory. In case you do not find it under Setup, please follow the steps below to enable them first.
Enable the feature at Setup > Company > Setup Tasks > Enable Features, in the SuiteTalk (Web Services) section, on the SuiteCloud subtab.
From the menu bar, navigate to Lists > Employees > Employees > New.
Enter your name and the email address provided to you by your customer success manager.
Click the Access subtab.
Check Give Access and Send Notification Email.
Assign a password of your choice.
Click on Save.
From the menu bar, navigate to Setup → Integration → Manage Integrations → New.
On the Integration page,
Fill in the Name field. We recommend using "DrivetrainIntegration".
In the Token-based Authentication section, check TOKEN-BASED AUTHENTICATION and uncheck TBA: AUTHORIZATION FLOW.
In the OAuth 2.0 section, uncheck AUTHORIZATION CODE GRANT.
Click on Save.
After you've saved the settings above, scroll down to the bottom of the page to get:
Consumer Secret
Consumer Key
Click the Home icon.
Scroll to the bottom.
Click Manage Access Tokens.
Click New My Access Token.
Click Save and scroll down to the bottom of the page to get the:
Token Key
Token Secret
From the menu bar, navigate to Setup → Company → Company Information.
You will find the Account ID here. Please note it down.
To install the script, navigate to Customization > Scripting > Scripts > New. You'll see the Upload Script File form.
Hover over the Script File field, and you'll see a "+" button appear to the right of the field. Click the button and the File upload form will appear.
By default, the script will be uploaded to SuiteScripts folder in your File Cabinet (or to the last folder that you uploaded a script to). If you'd like to install the script in an alternative folder, select it from the Folder field.
Next, click the Choose File button in the Select File field. Then navigate to the folder that you unzipped the file to, and select the file.
Then click the Save button. The file will be uploaded, and then the Upload Script File form will reappear, with the Script File field loaded.
Upon save, the script file will be populated in the Upload Script File form and then click on Create Script Record button. The Script form will appear.
In the script form, enter Name and ID as follows. Click on the Deployments tab, and enter the Title as "DrivetrainSavedSearch".
Mark the status as Released.
Click Save to finish the installation process.
After saving, click on the Deployment title to view the Script Deployment Form.
Make a note of External URL.
Edit the Script Deployment and update the role for the script (which you created for Drivetrain Integration) and click on Save.
Go to File Cabinet and select New Folder.
Add a folder “DrivetrainExports” in the root of File Cabinet and click Save.
Sign in to your Drivetrain instance. Make sure you are logged in as an administrator.
Click on + New Data Source.
Select the NetSuite Data Connector from the list of integrations by clicking +Connect.
Enter the keys, secrets and account ID you generated when setting up your NetSuite account, and click Submit.
Consumer Secret
Consumer Key
Account ID
Token Key
Token Secret
You will be redirected to the Connected Integrations page where you will be able to see your new NetSuite connection. Once the sync is complete, you will be able to see your NetSuite data on Drivetrain!
Select the Role you created in and click Add.
Log into NetSuite with the user account you set up in .
In the dropdown list for APPLICATION NAME, select the integration you created in .
Download the Script from and unzip it.
