Tables
The driver models the data in Marketo into a list of tables that can be queried using standard SQL statements.
Generally, querying Marketo tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Marketo Tables
| Name | Description |
| CustomActivities | Query Custom Activities for a Marketo organization. |
| CustomObjects | Create, update, delete, and query custom objects for a Marketo organization. |
| Emails | Query Emails for a Marketo organization. |
| EmailTemplates | Query, update and delete EmailTemplates for a Marketo organization. |
| Folders | Create, update, delete, and query Folders for a Marketo organization. |
| Forms | Create, update, delete and query Forms for a Marketo organization. |
| LandingPages | Create, update, delete and query Landing Pages for a Marketo organization. |
| LandingPageTemplates | Create, update, delete and query LandingPageTemplates for a Marketo organization. |
| Leads | Create, update, delete, and query Leads for a Marketo organization. |
| ListStaticMemberShip | Create, delete and query query static list members for a Marketo organization. |
| NamedAccounts | Query Named Accounts for a Marketo organization. |
| Opportunities | Query Opportunities for a Marketo organization. |
| OpportunityRoles | Query Opportunity Roles for a Marketo organization. |
| ProgramMembers | Query Program members for a program. |
| Programs | Query Programs for a Marketo organization. |
| SalesPersons | Query Sales Persons for a Marketo organization. |
| SmartCampaigns | Create, update, delete, and query SmartCampaigns for a Marketo organization. |
| SmartLists | Query and delete SmartLists for a Marketo organization. |
| Snippets | Create, update, delete and query Snippets for a Marketo organization. |
| StaticLists | Create, update, delete and query Static Lists for a Marketo organization. |
| Tokens | Create, update, delete, and query Tokens for a Marketo organization. |