Marketo Targets in Data Synchronization Tasks
When you run a Data Synchronization task, specify the operation and the source that you want the Secure Agent to write to the target. The Secure Agent inserts, updates, upserts, or deletes source rows that you specify into the target based on the configured operation for the target object.
The task operations depend on the target object that you select. You can configure the target properties when you schedule the Data Synchronization task. You configure Marketo target properties on the Target page of the Data Synchronization Task wizard. Provide the name of the target connection and specify the target object to write data to Marketo.
When you configure a Data Synchronization task, you can configure the advanced target properties. The advanced target properties appear on the Schedule page of the Data Synchronization Task wizard.
The following table describes the Marketo advanced target properties:
Advanced Target Property | Description |
|---|
Type of API to be used | The type of Marketo API used to insert leads in the Marketo database. You can select from the following options: - - Standard API. Uses the Standard API when you want to create few leads in Marketo.
- - Bulk API. Uses the Bulk API when you want to create many leads in Marketo.
Default is Standard API. |
Staging Folder for Bulk Load API | Required if you select Bulk API to insert leads in the Marketo database. The staging directory for the .csv file where you want to write lead data in bulk. For example, you can enter the following directory: c:\bulkWriteLeads |
Partition Name | The partition name where you want to insert, update, or upsert leads in Marketo. If specified, the Secure Agent verifies if the user has access to the partition. If you do not specify a partition, the API operation uses the primary partition of the list workspace. |
Create Duplicate | Creates a duplicate of the lead when that lead already exists in the Marketo database. The REST API either inserts or upserts data based on the operation you specify. You can choose one of the following values: - - Yes. Duplicates an existing lead.
- - No. Does not duplicate an existing lead.
Default is No. |
Lookup Field | Performs a lookup of the field you specify to determine whether the lead you want to add to the Marketo database is a duplicate lead. |
List ID for Leads | The ID of a list for leads where you want to create the lead. |
Custom Object Dedupe Fields | Required if you want to write a custom object record to Marketo. Comma-separated dedupe fields or ID fields of the custom object in Marketo to which you want to write the record. When you do not specify a value, the Secure Agent considers the dedupe field of the Marketo custom object as the default. |
Success File Directory | Directory for the success rows files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the success rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/success |
Error File Directory | Directory for the error rows files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the error rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error |
Marketo Target Data Synchronization Example
You work in the marketing industry, and business analysts in your enterprise want to add leads from a recent marketing conference into Marketo. You want to track the activity of these leads in Marketo.
Configure a Data Synchronization task to insert data to Marketo. Configure the following objects:
- Source
- The Data Synchronization task includes a flat file source that contains the new lead details. The source includes fields, such as firstName, salutation, middleName, lastName, email, and phone.
- Target
- The Data Synchronization task includes a lead target object. The target includes fields, such as firstName, salutation, middleName, lastName, email, and phone.
- Mapping
- Map the fields of the flat file source to the Marketo target.
- The following image shows the mapping of the flat file source with the lead target object in Marketo:
- The following image shows the data that the Secure Agent reads from the flat file source and writes to Marketo based on the fields you mapped in the Data Synchronization task:
- The new leads are added to Marketo. Marketing managers can interact with the leads and create sales opportunities.
