3 Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, in the Use a recipe/accelerator section, click View all.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle NetSuite Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the NetSuite WSDL URL. For example, https://webservices.netsuite.com/wsdl/<NetSuite _application_version>/netsuite.wsdl, where <NetSuite_application_version> is the version of the NetSuite application (for example, v2015_1_0). See Step 1 in Configure 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 Step 2 in Configure 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 ADW instance. See step 3 in Configure Oracle ADW.
  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 ADW.

    See Prerequisites for Creating a Connection.

    Wallet Password Enter the password for the credential wallet file.
    Database Service Username Enter the username of your Oracle ADW account.
    Database Service Password Enter the password of your Oracle ADW 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.