Install and Configure the Recipe

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

1. On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
2. Click Search All.
   The list of available recipes appears.
3. Find the recipe package that you want to install.
4. Select the recipe, and click the Install icon.
   A confirmation that the recipe was successfully installed appears, and the recipe now bears the Installed tag.
5. Click Configure on the recipe card to configure the following resources using the Configuration Editor.
   • Configure the Oracle Marketo Connection
   • Configure the Oracle ADW Connection
   • Configure the Integration

Configure the Oracle Marketo Connection

You have to configure the connection details for the Marketo connection.

1. On the Configuration Editor page, select Oracle Marketo Connection.
2. Click Edit .
   The Marketo Connection window appears.
3. Under the Connection Properties section, enter the munchkin ID that you obtained earlier in the Munchkin ID field.
   See Configure Marketo.
4. Under the Security section, enter the client ID and secret that you obtained earlier in the Client Id and Client Secret field.
   See Configure Marketo.
5. Click Save.
6. Click Test to ensure that your connection is successfully configured.
   You get a confirmation message if your test is successful.
7. Click Back to return to the Configuration Editor page. Click Save again if prompted.

Configure the Oracle ADW Connection

You have to configure the connection details for the Oracle ADW connection.

1. On the Configuration Editor page, select Oracle ADW Connection.
2. Click Edit .
   The Oracle ADW Connection window appears.
3. Under Connection Properties, in the Service Name field, enter the service name of your Oracle ADW instance.
   See Configure Oracle Autonomous Data Warehouse.
4. Under the Security section, enter the following details:
   • In the Security Policy field, select JDBC Over SSL from the drop-down list.
   • In the Wallet field, click Upload to upload the credential wallet file that you obtained earlier.
   • Enter the password for your credential wallet file in the Wallet Password field.
   • Enter your Oracle ADW account username in the Database Service Username field.
   • Enter your Oracle ADW account password in the Database Service Password field.

   See Configure Oracle Autonomous Data Warehouse.

5. Click Save on the connection window.
6. Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again. You get a confirmation message if your test is successful.
7. Click Back to return to the Configuration Editor page.

Configure the Integration

You can choose to update the default mappings and the property value configured for the integration in order to adapt it to your use case.

Configure Data Mapping

By default the recipe has a number of configured mappings between Marketo campaign leads and database columns in the Oracle ADW database table. If you want some specific fields to be mapped and stored into Oracle ADW, you can configure them in the mapper.

1. In the Configuration Editor page, select the integration's row, and then click Edit from the Actions menu.
2. On the integration canvas, select the Map to LoadCampaignLeads icon, and then click Edit.
3. Use the mapper to drag the required element nodes from Sources to element nodes in Target.

   See Using the Oracle Mapper with Oracle Integration.

4. Save the mapping and integration.

Update Integration Properties

You can update the integration's default property value so that notification emails about any errors can be sent to the right person.

1. In the Configuration Editor page, select the integration's row, and then click Update Property Values from the Actions menu.
2. In the Update Property Values dialog, click the ErrorNotificationEmail property.
3. Enter the email of the person whom you want the error notifications to be sent.
4. Click Submit.

You get a confirmation message that the property has been updated successfully.