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
Account	A Marketing Cloud account.
AccountUser	An individual user within an account. This table does not support deletes.
BusinessUnit	A unit within a larger Enterprise or Enterprise 2.0 account. This table supports queries and updates only.
ContentArea	A ContentArea represents a defined section of reusable content.
DataExtension	Represents a data extension within an account.
Email	Represents an email in a Marketing Cloud account.
EmailSendDefinition	Record that contains the message information, sender profile, delivery profile, and audience information.
FileTrigger	Reserved for future use. This table does not suport deletes.
FilterDefinition	Defines an audience based on specified rules in a filter. This table does not support inserts.
ImportDefinition	Defines a reusable pattern of import options. This table does not support inserts.
List	A marketing list of subscribers.
Portfolio	Indicates a file within the Portfolio of a Marketing Cloud account.
ProgramManifestTemplate	Reserved for future use. This table does not support deletes or inserts.
QueryDefinition	Represents a SQL query activity accessed and performed by the SOAP API. This table does not support updates or inserts.
ReplyMailManagementConfiguration	Details configuration settings for the reply mail management in an account. This table does not support deletes.
Send	Used to send email and retrieve aggregate data. This table does not support deletes or updates.
SendClassification	Represents a send classification in a Marketing Cloud account.
SenderProfile	The send profile used in conjunction with an email send definition.
SMSTriggeredSend	Indicates a single instance of an SMS triggered send. This table does not support deletes or updates.
Subscriber	A person subscribed to receive email or SMS communication.
SuppressionListDefinition	A suppression list that can be associated with different contexts.
TriggeredSendDefinition	To create or update a TriggeredSendDefinition where the list ID is the All Subs List ID, you need the Email \| Subscribers \| All Subscribers \| View and SendEmailToList permissions.