Revision as of 03:27, 1 August 2019

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.

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.

@@ Line 5: / Line 5: @@
 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 query on some fields:
+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.
 <source lang="sql">
 SELECT * FROM Leads WHERE Id = '104'
 </source>
-but not others:
+Sugarcrm_id runs in 283 seconds.
 <source lang="sql">
 SELECT * FROM Leads WHERE Sugarcrm_id = 'b7e70c80-20cd-9209-24bf-57ae4b05b711'
 </source>
 I'm unsure why this is.