Create Additional NetSuite Connections

You can create additional connections to the NetSuite source based on your customer tier. These additional connections enable you to bring in data from multiple NetSuite accounts.

You may want to connect to additional NetSuite accounts if you've:
  • One NetSuite primary account with live data and other NetSuite accounts having static data.
  • More than one NetSuite account with live data but no data mash-up required.
  • More than one NetSuite account with live data requiring data mash-up.

As a premium license tier Oracle NetSuite Analytics Warehouse customer, you can connect to two additional NetSuite accounts. If you're an enterprise license tier customer, then you can connect to ten additional NetSuite accounts. Based on your license tier, Oracle displays the additional NetSuite connections on the Create Connection dialog.

  1. In NetSuite, complete these tasks:
    • Enable the Multi-Instance Connector (MIC) feature.
    • Add an integration record.
    • Create a token-based authentication permission and add it to a user.
    • Create a token.

    See Merging Your NetSuite Accounts Data Into Your NetSuite Analytics Warehouse Instance

  2. In Oracle NetSuite Analytics Warehouse, Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, click Manage Connections.
  4. On the Manage Connections page, click Create and then click Connection.
  5. In Create Connection, select Data Extraction in Usage Type and then select NetSuite 2 or an applicable NetSuite option such as NetSuite 3 or NetSuite 4 as the connection type.
  6. In Create Connection, enter these details and then click Save:
    • Notification Email: Enter an email address to receive notifications.
    • User Name: Enter your user name.
    • JDBC URL: Enter the following URL: jdbc:ns://<NS Account ID>.connect.api.NetSuite.com:1708;ServerDataSource=NetSuiteDW;Encrypted=1;CustomProperties=(AccountID=<NS Account ID>;RoleID=57;Uppercase=1). Replace <NS Account ID> with your NetSuite Account ID.
    • Account ID: Enter your NetSuite Account ID.
    • Consumer Key: Paste the Consumer Key / Client ID string you noted down after creating the integration record.
    • Consumer Secret: Paste the Consumer Secret / Client Secret string you noted down after creating the integration record.
    • Token Key: Paste the Token ID string you noted down after creating the token.
    • Token Secret: Paste the Token Secret string you noted down after creating the token.
  7. Verify that the Refresh Metadata toggle is enabled to ensure that the metadata is refreshed when you save the connection.
    You can later refresh the metadata from the Actions menu on the Manage Connections page, if required.

    Note:

    You can’t create augmentations for NetSuite 2 unless you perform a metadata extract.
  8. On the Manage Connections page, select Actions for the NetSuite 2 connection and then select Test Connection.
  9. After the connections are successfully established, navigate to the Data Configuration page, select the connection in Data Source, then click the Data Augmentation tile, and create a data augmentation using the NetSuite 2 data. Select the applicable NetSuite 2 source tables. See Augment Your Data.