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