Before You Install the Recipe

You must perform the following configuration tasks on your Marketo and Oracle Autonomous Data Warehouse (ADW) instances in order to connect to these external systems using Oracle Integration and successfully import leads from Marketo into Oracle ADW.

Configure Marketo

Complete certain configuration tasks in your Marketo instance to successfully connect to it from Oracle Integration.

The following steps give an overview of the tasks that you need to perform to obtain information and details for configuring the Marketo connection from Oracle Integration. For detail information on the steps, see Prerequisites for Creating a Connection in Using the Marketo Adapter with Oracle Integration.

Create an API only user role.
Create a customer service.
Obtain the Client ID and Client Secret.
Obtain the Munchkin ID.

Configure Oracle Autonomous Data Warehouse

Complete configuration tasks in your Oracle Autonomous Data Warehouse (ADW) instance to successfully connect to it using Oracle Integration.

The following steps give an overview of the tasks you need to perform to obtain information and details for configuring the ADW connection property and security from Oracle Integration. For detail information on the steps, see Prerequisites for Creating a Connection in Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration.

Download the client credentials wallet.
This is a zip file containing the client security credentials. By default the file name is Wallet_<databasename>.zip. You can save this file as any file name you want.
Get the ADW database service name.

Note that the service name must be same as the one in the tnsnames.ora file in the client credential wallet.
Get the ADW wallet password.
You'll be prompted to enter a wallet password while downloading the client credentials wallet. Note the password as you'll need it while configuring the ADW connection security from Oracle Integration.