Connector Setup

I used 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.

I've found that I 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'

I'm unsure why this is.