- 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 package to deploy and configure the integration and associated resources.
- On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
- Click Search
All.The list of available recipes is displayed.
- Find and select the recipe
package that you want to install, then click Install
.
A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED. - After the package is installed,
click Configure
on the recipe card.
The Configuration Editor opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.
Configure the Oracle NetSuite Connection
- In the Configuration Editor, select the connection,
then click Edit
.
- In the Connection 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 Configuration Editor,
click Back
. Click Save again if prompted.
Configure the Oracle ADW Connection
- In the Configuration Editor, select the connection,
then click Edit
.
- In the Connection 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 Configuration Editor,
click Back
. Click Save again if prompted.