About This Recipe

This recipe bulk imports campaign leads created in Marketo and writes them into Oracle Autonomous AI Lakehouse database. The recipe uses the standard Marketo Adapter and the standard Oracle Autonomous AI Lakehouse 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 AI Lakehouse.

System and Access Requirements

  • Oracle Integration, Version 21.2.1 or higher

  • Marketo

  • Oracle Autonomous AI Lakehouse, 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 AI Lakehouse with the Administrator role

  • An Oracle Autonomous AI Lakehouse table with write access