1. Getting Started with Oracle Integration Generation 2
  2. Recipes Reference
  3. Customer Relationship Management (CRM) Recipes
  4. Import Marketo Leads to Oracle Autonomous Data Warehouse
  5. Activate and Run the Recipe

Activate and Run the Recipe

After you've configured the connections and the integration, you can activate and run the recipe.

Note:

Before activating and running the recipe, ensure that there are some campaign leads in the Marketo instance.
  1. Activate the recipe.
    1. On the Configuration Editor page, click Activate.
    2. On the Activate Package dialog, click Activate.
      You get a confirmation message that the integration is activated.
  2. Run the recipe.
    1. On the Configuration Editor page, select the integration flow.
    2. Click Run Run icon, then click Submit Now.
      The Schedule Parameters window appears.
    3. In the Schedule Parameters window, specify a value for the leadStartAt parameter. Enter the date from which you want to import campaign leads from Marketo in the New Value field, in the format YYYY-MM-DDThh:mm:ssZ. For example, 2021-09-27T00:00:00Z.
      By specifying the date in the schedule parameter, you filter out all leads that were created in the Marketo instance before the specified date, and fetch the leads created on or after the specified date.
    4. Click Submit.
    You've successfully submitted the integration for a test run.
  3. Monitor the execution of the integration flow in Oracle Integration.
    1. On the Oracle Integration navigation pane, click Home, then Monitoring, then Integrations, and then Tracking.
    2. On the Track Instances page, you can see the integration being triggered and executed successfully. The recipe now fetches the campaign leads from the Marketo instance and imports them into Oracle ADW.
  4. Log in to your Oracle ADW instance and check if the campaign leads from Marketo have been imported into the Oracle ADW database table.
Related Documentation