Tables

The driver models the data in Salesforce Marketing Cloud into a list of tables that can be queried using standard SQL statements.

Generally, querying Salesforce Marketing Cloud 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 Salesforce Marketing Cloud Tables


Name	Description
Assets	Create, update, delete and query assets from your SalesForce Marketing Cloud account.
Callbacks	Create, update, delete and query event notification callbacks
Campaigns	Create, update, delete and query Campaigns.
Categories	Create, update, delete and query categories(folders) in Content Builder.
EventDefinitions	Create, delete and query event definitions.
FacebookMessengerProperties	Query and create Facebook messenger properties.
JourneyActivities	Create, update and query journey activities.
Journeys	Create, update, delete and query journeys.
LineMessengerProperties	Query and create Line messenger properties.
SendDefinitions	Create, update, delete and query send definitions.
Subscriptions	Create, update, delete and query event notification subscriptions.