Marketo Connector

Marketo Connector

Additional Documentation

This Connector is based on the Marketo ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DKG/ado/

Connector Setup

You may use this guide, https://developers.marketo.com/blog/quick-start-guide-for-marketo-rest-api/, to setup an API Role, User and Service and then get the Client ID and Client Secret for that Service.

Origin

The CData website has a help page for the Marketo Connector: http://cdn.cdata.com/help/DKE/ado/default.htm. The SQL examples are helpful.

You can use some fields in a WHERE clause quickly and others are extremely slow. 'Id' runs in a few seconds. 

SELECT * FROM Leads WHERE Id = '104'

Sugarcrm_id runs in 283 seconds. 

SELECT * FROM Leads WHERE Sugarcrm_id = 'b7e70c80-20cd-9209-24bf-57ae4b05b711'

The same is true for using some fields in ORDER BY. This is because the Marketo API doesn't actually support some fields in these operations so the CData connector downloads all of the data and does the WHERE or ORDER BY locally, thus taking a very long time. See: http://cdn.cdata.com/help/DKE/ado/RSBMarketo_p_SupportEnhancedSQL.htm

Mapping

Multi-select Dropdown

The format is a semicolon seperated list: "Cloud Storage;Backup / Disaster Recovery;Colocation".

  1. test

    • Related Articles

    • Sage 300 web service setup and configuration

      Setting up Sage 300 web service test Get ready - Prep Sage 300 credentials Sage 300 SQL database Company Username and password System Prereqs .NET Framework 4.7.1+ IIS with ASP.NET enabled. Installed somewhere where the Sage 100 client has also been ...

    • Highrise Connector

      Additional Documentation This Connector is based on the Highrise ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/BHG/ado/

    • MongoDB Connector

      Additional Documentation This Connector is based on the MongoDB ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DGG/ado/

    • OData Connector

      Additional Documentation This Connector is based on the OData ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RDG/ado/

    • Acumatica Connector

      Additional Documentation This Connector is based on the Acumatica ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/OIG/ado/