Import Marketo Leads to Oracle Autonomous Data Warehouse
Use this recipe to import campaign leads from Marketo into Oracle Autonomous Data Warehouse (ADW).
Note:
This recipe is available as Marketo — Oracle ADW | Import Leads in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.
Overview
This recipe bulk imports campaign leads created in Marketo and writes them into Oracle ADW 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 package and configure the connections and other resources within the recipe package. 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 ADW.
System and Access Requirements
- Oracle Integration, Version 21.2.1 or higher
- Marketo
- Oracle Autonomous Data Warehouse (ADW), 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 ADW with the Administrator role
- An Oracle ADW table with write access