Marketo
Marketo is a marketing automation platform. You can use Marketo as a data source when landing or replicating data.
Marketo integration replicates data using the Marketo REST API and Marketo Bulk API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
You need the Admin permissions in Marketo. Marketo Admin permissions are required to complete portions of the setup process.
Prior to set up, we recommend that you monitor your Marketo API call usage if other applications are also connected to your Marketo account. While this integration is designed to use only a portion of your allotted API calls, replication may be impacted if numerous applications are using the API.
Creating the connection
有关更多信息，请参阅连接到 SaaS 应用程序。
- 填写所需的连接属性。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
单击创建。
| Setting | Description |
|---|---|
| Data gateway | 如果您的用例需要，请选择一个 数据移动网关。 信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Start Date | 按格式 |
| Endpoint Base URL | Endpoint base URL, for example: https://457-RFG-234.mktorest.com/rest. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
| Max Daily API Calls | Most Marketo subscriptions are allocated 50000 API calls per day. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
activities
In version 1 of Marketo integration, the activities table contained all data pertaining to lead activities.
In this version, you can choose to replicate lead activity data for specific activity types. For every activity type defined in your Marketo account, you’ll see an activities table in the Tables to Replicate tab. For example: activities_click_email contains lead activity data for the click_email activity type.
These tables will contain the fields listed below, along with any fields specific to that activity type.
Replication Method | CDC |
Primary Key | marketoGuid |
Replication Key | activityDate |
| Useful links |
activity_types
The activity_types table contains metadata about the activity types - form fill, web page visit, lead creation, and so on - available in Marketo.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
campaigns
The campaigns table contains info about your Marketo campaigns
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
leads
The leads table contains info about your Marketo leads.
The Replication Key for this table varies depending on your Marketo account setup:
- If updatedAt filtering is enabled, this table will use
updatedAtas the Replication Key - If updatedAt filtering isn’t enabled, this table will use
createdAtas the Replication Key. Additionally, data will be loaded using Append-Only loading.
Read more about replicating this table.
Replication Method | CDC |
Primary Key | id |
| Useful links |
lists
The lists table contains info about the static lists in your Marketo account.
Note: Due to some of the limitations in Marketo API, only static lists will be replicated.
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
programs
The programs table contains info about your Marketo programs. Programs can be parents to most types of assets in Marketo and allow you to track membership and success of leads.
Replication Method | CDC |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |