Marketo Connector for Data Prep¶

User Persona: Data Prep User or Marketo Admin

Configure Data Prep¶

This connector allows you to connect to Marketo as an import source. The following fields are used to define the connection parameters.

General¶

• Name: Name of the data source as it will appear to users in the UI.
• Description: Description of the data source as it will appear to users in the UI.

Marketo Configuration¶

• Marketo REST Endpoint: Your Marketo REST API Endpoint.
• OAuth Client ID: The Client ID of your service in Marketo.
• OAuth Client Secret: The Client Secret of your service in Marketo.
• Timeout: The number of seconds to wait until a timeout error cancels a running operation. The default is 60 seconds, for most situations this is adequate.

Web Proxy¶

If you connect to Marketo through a proxy server, these fields define the proxy details.

• Web Proxy: 'None' if no proxy is required or 'Proxied' if the connection to the Marketo REST Endpoint should be made via a proxy server. If a web proxy server is required, the following fields are required to enable a proxied connection.

• Proxy host: The host name or IP address of the web proxy server.

• Proxy port: The port on the proxy server for Data Source.

• Proxy username: The username for the proxy server.

• Proxy password: The password for the proxy server.

Configure Marketo¶

Marketo Connector leverages the Marketo REST API and OAuth. This step must be completed by a Marketo Admin.

In order to establish connectivity, the Marketo Administrator must:

• Create a "Custom Service” in Marketo.
• Obtain OAuth credentials for the "Custom Service" to identify the client (Data Prep Connector) that is accessing Marketo.

Create a "Custom Service" in Marketo¶

A custom service is required to connect to Marketo using the REST API. The below steps will guide you in creating a custom service.

1. Navigate to the admin area of your Marketo application.
2. Click Users & Roles in the Security section.
3. Select the Roles tab and click New Role to create a new Role.
4. Enter a Role Name and select the permissions for the Role. The Access API permissions are specific to the REST API.
5. Now that an API Role is created, select the Users tab and click Invite New User.
6. Enter the new user information and select the role that was just created with API access. The API Only option can be selected to denote the user as an API Only user.
7. Now that a new user has been created, a new service will need to be created. Click the LaunchPoint option (Admin > Integration > LaunchPoint).
8. Click New Service.
9. Select the Custom service type and enter a display name and description.
10. Select the user you created.

Obtain the OAuthClientId and OAuthClientSecret Values¶

To obtain the OAuthClientId and OAuthClientSecret, navigate to the LaunchPoint option on the Admin area. Click the View Details link for the desired service. A window containing the authentication credentials is displayed.

Obtain the REST Endpoint URL¶

The REST Endpoint can be found on your Marketo Admin area on the Integration -> Web Services option in the REST API section. Note the Identity Endpoint will not be needed.

Data Import Information¶

Via Browsing & Via SQL Query¶

See the following table for the list of visible Objects and example SQL queries.

Marketo Connector Data Objects:¶

Some objects in Marketo may or may not be present based on your configuration and some may run into the 500 column import maximum (this is a default setting, please reach out to your Data Prep Customer Success contact if this is inadequate). There are also several SQL Query examples in the table below.