- Import Sales Orders from Oracle NetSuite to Oracle Autonomous Data Warehouse
- Install and Configure the Recipe
3 Install and Configure the Recipe
On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.
- On the Oracle Integration Home page, in the Use a recipe/accelerator section, click View all.
- 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.
- Click Configure
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
- In the Connections section, click the connection name.
- 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. - 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. - Click Save. If prompted, click Save again.
- 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.
- To return to the project workspace,
click Go back
.
Configure the Oracle ADW Connection
- In the Connections section, click the connection name.
- In the Properties section, enter the service name of your Oracle ADW instance. See step 3 in Configure Oracle ADW.
- 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.
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. - Click Save. If prompted, click Save again.
- 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.
- To return to the project workspace,
click Go back
.