SOAP Data Model
The CData ADO.NET Provider for Salesforce Marketing Cloud models Salesforce Marketing Cloud data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, describe the schema exposed through the Salesforce Marketing Cloud.com API. The available data depends on your account credentials and access level.
Commonly used tables include:
| Table | Description |
| Automation | Defines automations created within Automation Studio in Salesforce Marketing Cloud. Each automation specifies a sequence of scheduled or triggered activities such as imports, sends, or data updates. |
| BounceEvent | Provides details about email bounce events in Salesforce Marketing Cloud. |
| 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. |
| ClickEvent | Contains tracking data for link click events in Salesforce Marketing Cloud. |
| 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. |
| DataExtensionField | Represents individual fields within a data extension in Salesforce Marketing Cloud. Each field defines the data type, length, and attributes of a column in a data extension. |
| Represents an email object in Salesforce Marketing Cloud. Each record contains metadata about an email message, including subject, content area references, and send configurations. | |
| EmailSendDefinition | Stores email send definitions in Salesforce Marketing Cloud. Each record includes message details, sender and delivery profiles, and audience configurations. |
| 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. |
| 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. |
| ListSubscriber | Retrieves subscriber relationships for lists in Salesforce Marketing Cloud. Each record shows which lists a subscriber belongs to or which subscribers are assigned to a list. |
| OpenEvent | Records open events for email sends in Salesforce Marketing Cloud. Each record includes the timestamp, subscriber key, and send context for an opened message. |
| QueryDefinition | Represents an SQL query activity that can be executed through the SOAP API in Salesforce Marketing Cloud. |
| 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. |
| SendSummary | Provides summary information for a completed send event in Salesforce Marketing Cloud. Each record includes key metrics such as total sent, delivered, opened, and bounced messages. |
| SentEvent | Contains tracking data for email send events in Salesforce Marketing Cloud. |
| 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). |
| 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. |
| TriggeredSendSummary | Provides summary metrics for specific triggered send operations in Salesforce Marketing Cloud. Each record includes counts for messages sent, delivered, and failed, supporting operational and performance analysis. |
| UnsubEvent | Contains data about unsubscription events in Salesforce Marketing Cloud. Each record captures the subscriber, timestamp, and context of the unsubscribe action. |