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
Use the following steps to configure the Oracle NetSuite connection.
- In the Connections section, click the connection name.
- In the Properties section,
enter the following details:
Field Information to Enter WSDL URL 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 NetSuite application. For example, v2015_1_0. See Assemble the Oracle NetSuite WSDL URL in Using the Oracle NetSuite Adapter with Oracle Integration 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 Create an Integration Record for Oracle Integration in Using the Oracle NetSuite Adapter with Oracle Integration 3. Consumer Secret Enter the consumer secret of the integration record in Oracle NetSuite. Token Enter the token ID provided by Oracle NetSuite. See Create an Access Token for the User Account in Using the Oracle NetSuite Adapter with Oracle Integration 3. Token Secret Enter the token secret provided by Oracle NetSuite. Account ID Enter your Oracle NetSuite account identifier. See Make a Note of the NetSuite Account ID in Using the Oracle NetSuite Adapter with Oracle Integration 3. 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 QuickBooks Connection
Use the following steps to configure the Oracle QuickBooks connection.
- In the Connections section, click the connection name.
- In the Properties section,
enter the following details:
Field Information to Enter QuickBooks Environment Select Production. - In the Security section, enter the
following details:
Field Information to Enter Client id Enter the Client ID obtained when you configured QuickBooks. See Configure QuickBooks. Client secret Enter the Client Secret obtained when you configured QuickBooks. - Click Save. If prompted, click Save again.
- Click Provide Consent.
- In the resulting Sign in dialog, enter your Oracle Integration user name and password, and click Sign in.You'll now be redirected to the QuickBooks sign in page.
- Enter your QuickBooks account credentials.A page is displayed asking for permission to interact with the account.
- Click Yes.You're informed that access is allowed. You can now switch back to the Oracle QuickBooks Connection window of Oracle Integration to test your connection.
- 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 Lookup Table
Edit the Account_lookup lookup table to map the account names in Oracle NetSuite with QuickBooks account IDs.
- In the Lookups section, click the lookup name.
- Enter the values for the following keys.
netsuite_account_name quickbooks_account_id 1150 Employee Advances 57 Inventory Asset 81 Accounts Receivable 84 1090 Undeposited Funds 4 Uncategorized Income 30 1300 Prepaid Expenses 3 6010 Advertising 7 6020 Automobile Expense 55 4000 Sales 79 Cost of Goods Sold 80 6080 Equipment Rental 29 6100 Insurance Expense 11 6150 Office Expense 15 - Click Save. If prompted, click Save again.
- To return to the project workspace,
click Go back
.