Integrating with NetSuite
Last updated
Was this helpful?
Last updated
Was this helpful?
To connect NetSuite to Drivetrain, you need:
An active Oracle NetSuite account
Admin privileges to your Netsuite instance
Admin privileges in Drivetrain
Web services will usually be enabled as part of the admin access provided to Drivetrain. In case it isn't you can enable the feature at Setup > Company > Setup Tasks > Enable Features, in the SuiteTalk (Web Services) section, on the SuiteCloud sub tab.
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 sub tab.
Check Give Access and Send Notification Email.
Assign a password of your choice.
Select Role = 'Administrator' and click Add.
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
Log into NetSuite with the admin account for Drivetrain.
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 saving, 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 "DrivetrainIntegration") 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!
In the dropdown list for APPLICATION NAME, select the integration you created in .
Download the Script from and unzip it.
