NetSuite Analytics Connection
  • 2 Minutes to read
  • Dark
    Light
  • PDF

NetSuite Analytics Connection

  • Dark
    Light
  • PDF

Article summary


As of November 8, 2021, new users are only able to use the NetSuite2.com (Netsuite Analytics) data source. Existing users can continue to access the NetSuite.com (Netsuite) data source, but it is no longer being updated.
All users are encouraged to switch to NetSuite2.com.
More information can be found in the "New Accounts and Access to the Connect Data Source" document.

This is a step-by-step tutorial for creating a NetSuite Analytics connection.

Prerequisite

An Admin user is required to create additional user accounts.

Create a Role for Rivery and Grant Netsuite Analytics Permissions

Create a Role

  1. Navigate to Setup -> Users/Roles -> Manage Roles -> New.
  2. Name your role "Rivery".
  3. Under "Subsidiary Restrictions", select "All".
  4. Choose "Primary" under "Accounting Books".
  5. Scroll down and check the "WEB SERVICES ONLY ROLE" under "Authentication."

Role Permission Options:

Below is a list of the minimum permissions that must be granted to the role in order to use Rivery with Netsuite:

PermissionLevelTab
SOAP Web ServicesFullSetup
Log in using Access TokensFullSetup
User Access TokensFullSetup
SuiteAnalytics Connect - Read All    FullSetup
SuiteAnalytics Connect    FullSetup
Access Token Management    FullSetup
Custom Body FieldsViewSetup
Custom FieldsViewSetup
Custom ListsViewSetup
Custom Record TypesViewSetup
Deleted RecordsViewSetup
Perform SearchViewLists

How to add permissions:

  1. Under the permissions tab, locate the sub-tab that corresponds to the entity you want to extract (for example, lists).
  2. Locate the record to which you want to add permission (such as Accounts).
  3. Set the level of permission for that record (for example, view).
  4. Select Add.
  5. Continue until all entities are added.
  6. Click Save.


Sign Out/Sign In

At this stage in the process, it is recommended to sign out and then sign back into the Netsuite account to ensure that the previous steps have been properly saved.

Create a New User 

Create a new user and assign the previously created role to this user:

  1. Navigate to Lists -> Employees -> Employees -> New.
  2. Enter your Name and Email address.
  3. Select the Access sub-tab.
  4. Check the boxes for 'Give Access' and 'Send Notification Email'.
  5. Check the box next to 'Manually Assign or Change Password'.
  6. Set your own password.
  7. Choose the Role that you want to assign. In this case, type "Rivery" and then click the Add button.
  8. Save the record.

Log In with the Rivery User You Just Created

Log in with your newly established Rivery user and create a Rivery integration application.

Follow the steps below to obtain the Consumer Key and Consumer Secret:

  1. Navigate to Setup -> Integration -> Manage Integrations -> New
  2. Name your integration "Rivery".
  3. Ensure the TOKEN-BASED AUTHENTICATION (TBA) is enabled.
  4. Click the Save button.
  5. A Consumer Key and Secret will be displayed once. Copy them to your clipboard because you'll need them later.

image.png


Create an Access Token

  1. Navigate to Setup -> Users/Roles ->Access Tokens -> New
  2. Select the previously created application (an integrated record).
  3. Choose the previously created user.
  4. Choose the role you've assigned to that user.
  5. Enter a name for the access token or use the one that is generated.
  6. A Token Key and Secret will be displayed once. Copy them to your clipboard because you'll need them later.

Sign Out/Sign In

At this stage in the process, it is recommended to sign out and then sign back into the Rivery account to ensure that the previous steps have been properly saved.

Locate Your Service Host, Account, and Role ID

  1. Locate the Settings button on the main screen and select Set Up SuiteAnalytics Connect.
    settings.PNG
  2. Click on Your Configuration.
  3. Your host is listed under SERVICE HOST ('sb2' stands for sandbox).
  4. Account ID and Role ID can be found directly beneath, as shown in the image below.
  5. Copy them to your clipboard because you'll need them later.





Netsuite Analytics Connection Procedure 

  1. Choose your Connection Name.
  2. Enter the Consumer Key and Secret generated by the Integration Application.
  3. Fill in the Token ID and Secret that were generated in the Access Token section.
  4. Input the Role and Account ID.
  5. Enter Host.
  6. Click Save.
  7. Use the Test Connection function to see if your connection is up to the task. If the connection succeeded, you can now use this connection in Rivery.

Was this article helpful?