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.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

You need administrator permissions in your Marketo account.

To create an API-only user role:

1. Log into your Marketo account.
2. Navigate to Admin > Users & Roles.
3. Click the Roles tab and then New Role.
4. In the Create New Role window, complete the following fields:
   • Role name: Enter a name for the role. If the role is specific to Qlik Talend Cloud, make that clear in the name, for example QTC API role.
   • Description: Enter a description of the role.
   • Permissions: Select the Access API checkbox.
5. Click Create.

To create an API-only user:

1. Log into your Marketo account.
2. Navigate to Admin > Users & Roles.
3. Click the Users tab and then Invite New User.
4. In the Invite New User window, complete the following fields:
   • Email
   • First Name
   • Last Name
5. Click Next.
6. In the Permissions section, select the checkboxes for the API user role you created and API Only.
7. Click Next.
8. In the Message section, click Send to create the user.

To create an API Custom Service:

1. Log into your Marketo account.
2. Navigate to Admin > LaunchPoint.
3. Click the New tab and then New Service.
4. In the New Service window, complete the following fields:
   • Display Name: Enter QTC .
   • Service: Select Custom from the drop-down list.
   • Description: Enter a description.
   • API Only User: Select the user you previously created.
5. Click Create.
6. In the Installed Services section, click View Details.
7. Copy and paste your client ID and client secret into a secured file.

IP restrictions may be enabled in Marketo. To verify, go to Admin > Web Services > IP Restrictions. If IP restrictions are not enabled, skip this step.

The IP addresses you must allowlist depend on your Qlik Talend Cloud region and country. For the current list, see Qlik Cloud domains and IP addresses.

To add the Qlik Talend Cloud IP addresses to Marketo’s web services allowlist:

1. Log into your Marketo account.
2. In the Integration menu, click Web Services.
3. In the IP Restrictions section, click Edit.
4. In Allowed Addresses, paste one IP address for your region.
5. Repeat the previous step until you have added all required IP addresses for your data pipeline region.
6. Click Save.

To retrieve the base URLs:

1. Log into your Marketo account.
2. Navigate to Web Services > REST API.
3. Locate the Endpoint and Identity fields.
4. Copy the URLs.

Creating the connection

如需詳細資訊，請參閱連線到 SaaS 應用程式。

1. 填寫所需的連線屬性。

2. 在連線名稱中提供連線名稱。

3. 選取開啟連線中繼資料以在建立後定義連線的中繼資料。

4. 按一下建立。

Schema

Depending on your destination, table and column names may not appear as they are outlined below.

activities.activityTypeId = activity_types.id

activities.leadId = leads.id

activity_types.id = activities.activityTypeId

campaigns.programId = programs.id

leads.id = activities.leadId

programs.id = campaigns.programId