Marketo

Connect your data from Marketo to the Ascend platform.

The Marketo connection utilizes a JDBC driver from CData. For more information, see CData's documentation.

Prerequisites

  • Marketo account access

Connection Properties

The following table describes the fields available when creating a new Marketo connection. Create a connection using the information below and these step-by-step instructions.

FieldRequiredDescription
Access TypeRequiredThe type of connection is Read-Only for Marketo.
Connection NameRequiredInput your desired name.
Rest API EntrypointRequiredThis is a description of the field.
Use Bulk APIOptionalAllows Ascend to utilizes Marketo Bulk Extract to read data.
Requires CredentialsOptionalCheck this box to create a new credential or select an existing credential.

Credential Properties

The following table describes the fields available when creating a new Marketo credential.

Field NameRequiredDescription
Credential NameRequiredThe name to identify this credential with. This credential will be available as a selection for future use.
Credential TypeRequiredThis field will automatically populate with Marketo by CData JDBC.
Rest OAuth Client IDRequiredThe Marketo Client ID. See the Marketo Rest API Authentication documentation for more information.
Rest OAuth Client SecretRequiredThe Marketo Client Secret. See the Marketo Rest API Authentication documentation for more information.
CData Runtime Key (RTK)RequiredContact the Ascend team to receive a key.

Read Connector Properties

The following table describes the fields available when creating a new Marketo read connector.

Field NameRequiredDescription
NameRequiredProvide a name for your connector. We recommend using lowercase with underscores in place of spaces.
DescriptionOptionalDescribes the connector. We recommend providing a description if you are ingesting information from the same source multiple times for different reasons.
Table NameRequiredName of the table being ingested. Enter in the table name or select Browse and Select Data to locate the table.
Replication StrategyOptionalFull Resync, Filter by column range, or Incremental column name. See Database Reading Strategies for more information.