Skip to main content

​
Intro

NetSuite creates products for enterprise resource planning, financial management, e-commerce, and customer relationship management. You can use Domo’s NetSuite JDBC OAuth connector to pull data from tables using custom SQL queries. You can connect to your NetSuite JDBC OAuth account in the Data Center. This topic discusses the fields and menus that are specific to the NetSuite JDBC OAuth connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your NetSuite JDBC OAuth account and create a DataSet, you need the following:
  • Service Host
  • Service Port
  • Service Data Source
  • Role ID
  • Account ID
  • NetSuite username
  • Consume Key/ Client ID
  • Consumer Secret/ Client Secret

​
Establishing SuiteAnalytics Connect for Data Access

To establish a connection using SuiteAnalytics Connect and retrieve the necessary configuration details, follow these steps:
  1. Log in to your NetSuite instance.
  2. Navigate to the Settings menu and click Set Up SuiteAnalytics Connect.
  3. On the SuiteAnalytics Connect setup page:
    • Select JDBC as your preferred connectivity option.
    • Expand the Default configuration section.
    • Copy the following parameters for later use:
      • Service Host
      • Service Port
      • Service Datasource
      • Account ID
      • Role ID

​
Enable the OAuth 2.0 Feature

Before you can begin using OAuth 2.0 in your account, you must enable the feature.

​
To enable the OAuth 2.0 feature:

  1. Go to Setup > Company > Enable Features.
  2. Click the SuiteCloud subtab.
  3. In the SuiteScript section, select the following checkboxes:
  • Client SuiteScript. Select I Agree on the SuiteCloud Terms of Service page.
  • Server SuiteScript. Select I Agree on the SuiteCloud Terms of Service page.
Note: You must enable both the Client SuiteScript and Server SuiteScript features to use the OAuth 2.0 feature for RESTlets.
  1. In the Manage Authentication section, select the OAuth 2.0 checkbox. Click I Agree on the SuiteCloud Terms of Service page.
  2. Click Save. Note: The Manage OAuth 2.0 Authorized Applications link becomes available in the Settings portlet for users with a role that has been assigned Log in Using OAuth 2.0 Access Token permission. Users can only list their own OAuth 2.0 authorized applications through this link. Administrators and users with OAuth 2.0 Authorized Applications Management permission can list all authorized applications in the account on Setup > Users/Roles > OAuth 2.0 Authorized Applications.

​
Create Integration Records for Applications to Use OAuth 2.0

​
To create an integration record for an application:

  1. Go to Setup > Integration > Manage Integrations > New.
  2. Enter a name for your application in the Name field.
  3. Enter a description in the Description field, if required.
  4. Select Enabled in the State field.
  5. Enter a note in the Note field, if required
  6. On the Authentication tab, select the appropriate checkboxes for your application:
  7. Click Save. Once the integration is created successfully Consumer Key/Client ID & Consumer Secret/Client Secret are shown under Client Credentials Tab. Note: For security reasons, the values for Client Credentials are only displayed on the initial setup page. They cannot be retrieved from the system. If you did not retain this information, you will need to reset your credentials to obtain new values. Click Edit to reset the credentials.

​
Connecting to Your NetSuite JDBC OAuth Account

This section enumerates the options in the Credentials and Details panes on the NetSuite JDBC OAuth Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your NetSuite JDBC OAuth account. The following table describes what is needed for each field:

Field

Description

Service Host Enter the name of your NetSuite Service Host. For more information, see the Prerequisites section.
Service Port Enter your NetSuite Service Port number. For more information, see the Prerequisites section.
Service Data Source Enter the name of your NetSuite Service Data Source. For more information, see the Prerequisites section.
Role ID Enter your NetSuite Role ID number. For more information, see the Prerequisites section.
Account ID

Enter your NetSuite Account ID number. For more information, see the Prerequisites section.

Username Enter your NetSuite username.

Consumer Key/ Client ID

Enter the Client ID associated with your NetSuite account.

Consumer Secret/ Client Secret

Enter the Client Secret associated with your NetSuite account.
Once you have entered valid NetSuite JDBC OAuth credentials, you can use the same account at any time to create a new NetSuite JDBC OAuth DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu

Description

Query

To select the data you want to import, enter a Structured Query Language (SQL) query into the Query field.

Using the Query Helper

If you need assistance in creating a simple query, use the Query Helper :

  1. Select the desired database table from the dropdown menu.

  2. Select the columns you wish to ingest into Domo.

  3. The completed SQL query will appear in the Query Helper box .

  4. Copy the generated query from the Query Helper box and paste it into the Query field.

Database Tables

If you already have your query, you can ignore this section and enter it directly into the Query field. The Query Helper assists you in building a basic SQL query.

Steps to Generate a Query

Follow these steps to generate a query using the Query Helper:

  1. Select the database table that contains the data you want to ingest.

    • A list of columns for the selected table will appear.

  2. Select the columns you are interested in.

    • The generated SQL query will automatically appear in the Query Helper box .

  3. Copy the generated query from the Query Helper box and paste it into the required Query field at the top of the screen.

Table Columns

You can browse and select the available columns within the table chosen from the Database Tables menu. Selecting a column will automatically include it in the sample SQL query that appears in the Query Helper field.

Query Helper

The Query Helper field displays a sample SQL query based on the columns you select in the Table Columns field.

  • When you select a column, it is immediately included in the query. Selecting additional columns adds them to the existing query.

  • You can edit the sample query directly in this field as needed.

  • After building or modifying the query here, copy it and paste it into the main Query field to retrieve your data.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.