JDBC Driver for Marketo

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462