Tables

The connector models the data in Salesforce Marketing Cloud as a list of tables in a relational database that can be queried using standard SQL statements.

CData Python Connector for Salesforce Marketing Cloud Tables


Name	Description
Account	Represents an account within Salesforce Marketing Cloud. Each record defines the configuration, credentials, and organizational context of a Marketing Cloud account. This table supports management of account-level metadata for system integration and user provisioning.
AccountUser	Represents an individual user who belongs to a specific Salesforce Marketing Cloud account. Each user record includes details such as roles, permissions, and access settings. This table supports queries and updates but does not allow deletions to protect account integrity.
BusinessUnit	Represents a business unit within an Enterprise or Enterprise 2.0 Salesforce Marketing Cloud account. Each business unit defines a logical partition for users, data, and permissions. This table supports query and update operations but does not allow deletions to maintain enterprise hierarchy integrity.
ContentArea	Represents a content area (ContentArea) in Salesforce Marketing Cloud. A ContentArea defines a reusable section of content, such as text, images, or dynamic blocks, that can be inserted into multiple messages or templates. This table allows you to manage reusable content elements to ensure brand consistency and efficiency.
DataExtension	Represents a data extension within a Salesforce Marketing Cloud account. A data extension is a custom table that stores subscriber or relational data used for segmentation, personalization, or automation. This table allows you to query, create, and manage data structures that support targeted communications.
Email	Represents an email object in Salesforce Marketing Cloud. Each record contains metadata about an email message, including subject, content area references, and send configurations. This table is used to query or manage email assets that are stored and deployed from the account.
EmailSendDefinition	Stores email send definitions in Salesforce Marketing Cloud. Each record includes message details, sender and delivery profiles, and audience configurations. This table allows you to define and manage parameters that control how and when emails are sent to subscribers.
FileTrigger	Represents configuration data that defines file-based automation triggers within Salesforce Marketing Cloud. A file trigger initiates an automation when a file is placed in a designated Enhanced FTP location, enabling automated imports or other workflow actions that begin upon file detection. This table does not support delete operations.
FilterDefinition	Defines audience segmentation filters in Salesforce Marketing Cloud. Each filter specifies logical rules that identify which contacts or subscribers meet specific criteria. This table supports update and query operations but does not allow inserts, as filters are managed within the platform interface.
ImportDefinition	Defines reusable import definitions in Salesforce Marketing Cloud. Each import definition specifies the file location, mapping, and data extension target for recurring import operations. This table supports query and update operations, but it does not allow inserts because imports are configured through the application interface.
List	Represents subscriber lists in Salesforce Marketing Cloud. A list defines a group of subscribers that share common attributes or purposes, such as newsletter recipients or event registrants. This table supports list management operations including queries, inserts, and updates.
Portfolio	Represents a file that is stored in the portfolio of a Salesforce Marketing Cloud account. Each record includes file metadata such as name, type, and storage location. This table supports query and management of digital assets that are uploaded or referenced across campaigns.
ProgramManifestTemplate	Represents standardized templates that define the structure and configuration of program manifests that are used within Salesforce Marketing Cloud workflows. These templates provide a consistent model for describing program components and their relationships. This table does not support insert or delete operations.
QueryDefinition	Represents an SQL query activity that can be executed through the SOAP API in Salesforce Marketing Cloud. Each query definition specifies the SQL text, data extension target, and scheduling information for automated query execution. This table supports query and retrieval operations but does not allow inserts or updates.
ReplyMailManagementConfiguration	Defines configuration settings for Reply Mail Management (RMM) in Salesforce Marketing Cloud. RMM determines how reply emails are processed, routed, and categorized for an account. This table does not support deletions to preserve email routing integrity.
Send	Represents email send operations in Salesforce Marketing Cloud. Each record includes aggregate tracking data for sent emails, such as audience size, delivery results, and performance metrics. This table supports query and reporting but does not allow deletes or updates.
SendClassification	Represents send classifications in Salesforce Marketing Cloud. A send classification defines the delivery parameters for a message, including CAN-SPAM classification (commercial and transactional or relationship messages), sender profile, and delivery profile. This table helps enforce consistent email compliance and brand policies.
SenderProfile	Stores sender profile configurations in Salesforce Marketing Cloud. A sender profile defines the 'From' name, 'From' email address, and reply handling for outbound messages. This table supports integration with send definitions to maintain consistent sender identity across campaigns.
SMSTriggeredSend	Represents individual instances of Short Message Service (SMS) triggered sends in Salesforce Marketing Cloud. Each record corresponds to a message sent as part of a triggered send definition. This table does not support deletes or updates to preserve historical send data.
Subscriber	Represents a subscriber in Salesforce Marketing Cloud. Each record identifies an individual who has opted to receive marketing communications via email or Short Message Service (SMS). This table is central to subscriber management, preference handling, and audience segmentation.
SuppressionListDefinition	Represents suppression lists in Salesforce Marketing Cloud. A suppression list defines subscribers who should be excluded from specific sends or publications. Each record can be associated with one or more suppression contexts to enforce message exclusions.
TriggeredSendDefinition	Defines triggered send definitions in Salesforce Marketing Cloud. A triggered send definition establishes parameters for automatically sending emails to contacts who meet specified conditions or trigger events. The 'All Subscribers' list permission is required when using the default list for triggered sends.