Zoomdata Version

Connecting to Marketo


Before you can connect Zoomdata to your Marketo source, ensure the following items are addressed:

  1. Create and configure your Marketo account in order to access the Zoomdata REST API.
    While configuring the API, note the Endpoint (specified in the Web services section), Client ID, and Client Secret (specified in the Launch Point section) values. You will need to specify these values while configuring the connector.
  2. In order to access a Marketo source, Zoomdata leverages its embedded Spark Proxy. By default, this local Spark instance is configured with a small configuration size (that is, with a minimum amount of memory and core usage). For details about Zoomdata's Spark setup and how to edit the configuration, access the article Configuring an Embedded Spark Server .


  • Zoomdata's Marketo connector is based on REST API Version 1.
  • Only REST API is supported (SOAP API is not supported).

Configuring the Marketo Connector

To configure the connector, perform the following steps:

  1. Log into Zoomdata.
    Administrators and users with appropriate access privileges can connect data sources in Zoomdata.
  2. Click the Sources menu item.

Figure 1

  1. Click the Marketo connector icon.
  2. Specify the name of your source and add a description (if desired).

Figure 2

  1. Click Next .

Figure 3

  1. On the Connection page, define the connection source. You can use an existing connection, if available, or create a new one. To create a new connection, select the Input New Credentials option button and specify a connection name, endpoint, client ID, and client secret key. Click Validate . Valid data will be saved. Click Next .
  2. On the Collections page, select a data source for your charts from the Marketo Objects list. If you want to include or exclude specific fields, select or clear the corresponding checkboxes. By default caching is enabled. You can disable it if needed.

Figure 4

  1. On the Fields page, create unique label names for the available fields in your data source. These labels will be displayed in the charts. Specify the required name in the Label field. If necessary, change the Type and Default options. Select the checkboxes in the Distinct Count column to enable this option. Configure Filter Display settings for the required fields. Click Next to continue.

Figure 5

  1. On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
  2. On the Charts page, you can:
    • Edit Global Default Settings
    • Select the Standard and, if available, Custom chart styles to be used with the data source
    • Set default parameters  (group-bys, colors, sorting, etc.) for each chart style
    Learn more about how to customize a chart .

Figure 6

  1. ​Click Finish to save your changes.