Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Oracle NetSuite Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle NetSuite WSDL URL. For example, https://webservices.netsuite.com/wsdl/<NetSuite _application_version>/netsuite.wsdl, where <NetSuite_application_version> is the version of the Oracle NetSuite application (for example, v2015_1_0). See Configure Oracle NetSuite.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Token Based Authentication.
    Consumer Key Enter the consumer key of the integration record in Oracle NetSuite. See Configure Oracle NetSuite.
    Consumer Secret Enter the consumer secret of the integration record in Oracle NetSuite.
    Token Enter the token ID provided by Oracle NetSuite.
    Token Secret Enter the token secret provided by Oracle NetSuite.
    Account ID Enter your Oracle NetSuite account identifier.

    Note:

    You must enter this information in capital letters.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle ADW Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the service name of your Oracle Autonomous Data Warehouse instance. See Configure Oracle Autonomous Data Warehouse.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select JDBC with OCI Signature.
    Wallet

    Click Upload and upload the credential wallet file.

    See Configure Oracle Autonomous Data Warehouse.

    Wallet Password Enter the password for the credential wallet file.
    Database Service Username Enter the username of your Oracle Autonomous Data Warehouse account.
    Database Service Password Enter the password of your Oracle Autonomous Data Warehouse account.
    Object Storage Region Enter the region in which your object storage is located (for example, us-ashburn-1).
    Object Storage Tenancy OCID Specify the value you copied from the Oracle Cloud Infrastructure Console (for example, ocid1.tenancy.oc1.alphanumeric.value).
    Object Storage Compartment OCID Specify the value you copied from the Oracle Cloud Infrastructure Console (for example, ocid1.compartment.oc1.alphanumeric.value)
    Object Storage User OCID Specify the value you copied from the Oracle Cloud Infrastructure Console (for example, ocid1.user.oc1.alphanumeric.value).
    Private Key Click Upload and upload the key you created in the Oracle Cloud Infrastructure Console.
    Finger Print Enter the finger print that was generated when you created the key in the Oracle Cloud Infrastructure Console.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.