We mainly use MS Access and MSSQL, but are looking to have a Marketo installation in another part of the company. I can do some of what I need to do using the API (using the Sandbox at the moment), but there are occasions when direct access would be easier so need an ODBC driver (or similar). Any ideas?
Simon, there is no ODBC driver since the database is abstracted away, so we don't give direct access to the database. All access is via the SOAP and REST APIs.
Simon, there is no ODBC driver since the database is abstracted away, so we don't give direct access to the database. All access is via the SOAP and REST APIs.
1. Make a export batch app using REST or SOAP. 2. App get lead and activity data from Marketo and insert into database at night. 3. You can connect to database via ODBC. My company is using similar step and we are analyzing this bigdata.
.png)