JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

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.

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