Configuring an Oracle NetSuite Connection

You can configure a secure connection in Data Integration to facilitate data exchange with NetSuite.

Data Integration supports OAuth 2.0 authentication for NetSuite using the authorization-code grant flow.

Before configuring a connection that uses OAuth 2.0 authentication, ensure that you have configured OAuth 2.0 in NetSuite.

To configure a NetSuite connection:

  1. From the Data Integration page, go to Actions > Setup > Applications.
  2. On the Applications page, click Actions > Configure Connections.
  3. On the Connections page, click Image shows the three dots icon., and then click NetSuite.
  4. In the Create connection: NetSuite window, enter a Name and a Description. For Consumer Key Type, select one of the following:
    • Default: Specify Token Key, Token Secret, and Account.
    • Custom: For Connector Type, select NSPB Sync or EPM Connector, and specify the applicable fields below.
      Connector Type Fields
      NSPB Sync Authentication Type:
      • Token Based: Consumer Key, Consumer Secret, Token Key, Token Secret, and Account
      • OAuth2.0: Consumer Key, Consumer Secret, and Account
      EPM Connector Authentication Type:
      • Token Based: Consumer Key, Consumer Secret, Token Key, Token Secret, and Account
      • OAuth2.0: Consumer Key, Consumer Secret, and Account

    To use OAuth 2.0 authentication, select Custom for Consumer Key Type, and then select NSPB Sync or EPM Connector for Connector Type. Select OAuth2.0 for Authentication, and enter the Consumer Key, Consumer Secret, and Account.

  5. If you selected OAuth2.0, click Generate Token. In the NetSuite login window, sign in if prompted, verify the account and role, and click Allow.
  6. After authorization succeeds, return to the NetSuite connection configuration in Data Integration.
  7. Click Test Connection to verify that Data Integration can connect to NetSuite.
  8. Click OK to save the connection.

For further information about configuring an Oracle NetSuite connection, see the following:

Table 6-1 Netsuite SuiteApp Installation and Setup References

SuiteApp Reference
Oracle EPM Connector Oracle EPM Connector Installation and Setup
NSPB Sync NSPB Sync Setup Guide
NetSuite Planning and Budgeting Integration Guidelines
Account Reconciliation Sync Account Reconciliation Sync SuiteApp Installation and Setup