About This Recipe

This recipe bulk imports campaign leads created in Marketo and writes them into Oracle Autonomous Data Warehouse database. The recipe uses the standard Marketo Adapter and the standard Oracle Autonomous Data Warehouse Adapter.

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. Subsequently, you can activate and run the integration flow manually or specify an execution schedule for it. When triggered, the integration flow uses a schedule parameter to query campaign leads created in Marketo on or after the date specified in the parameter. It extracts the leads in a file that should be formatted as a comma-separated values file, and writes them into database tables in Oracle Autonomous Data Warehouse.

System and Access Requirements

  • Oracle Integration, Version 21.2.1 or higher

  • Marketo

  • Oracle Autonomous Data Warehouse, Oracle Database 19c Enterprise Edition

  • An Autonomous Database instance created in Oracle Cloud Infrastructure (OCI)

  • An account in Marketo with the Administrator role

  • An account in Oracle Autonomous Data Warehouse with the Administrator role

  • An Oracle Autonomous Data Warehouse table with write access