Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Salesforce Marketing Cloud Views
| Name | Description |
| Automation | Defines an automation that exists within Automation Studio for an account. |
| BounceEvent | Contains SMTP and other information pertaining to the specific event of an email message bounce. |
| ClickEvent | Contains time and date information, as well as a URL ID and a URL, regarding a click on a link contained in a message. |
| DataExtensionField | Represents a field within a data extension. |
| DataExtensionTemplate | Represents a data extension template within an account. |
| DataFolder | Represents a folder in a Marketing Cloud account |
| DoubleOptInMOKeyword | The DoubleOptInMOKeyword object defines an MO keyword, allowing a mobile user to subscribe to SMS messages using a double opt-in workflow. |
| FileTriggerTypeLastPull | Reserved for future use. |
| ForwardedEmailEvent | Indicates a subscriber used the Forward To A Friend feature to send an email to another person. |
| ForwardedEmailOptInEvent | Specifies an opt-in event related to a Forward To A Friend event. |
| HelpMOKeyword | Defines actions associated with the HELP SMS keyword for an account. |
| ImportResultsSummary | A retrieve-only object that contains status and aggregate information on an individual import started from an ImportDefinition. |
| LinkSend | Provides information about a link in a send. |
| ListSend | Specifies retrieve-only properties associated with the list(s) for a completed send. |
| ListSubscriber | Retrieves subscribers for a list or lists for a subscriber. |
| MessagingVendorKind | Contains the vendor details for an SMS (short message service) or voice messaging vendor. Deprecated. |
| NotSentEvent | Contains information on when email message failed to be sent. |
| OpenEvent | Contains information about the opening of a message send by a subscriber. |
| PrivateIP | The PrivateIP object contains information on private IP address to be used as part of messages sends. |
| Publication | Reserved for future use. |
| PublicationSubscriber | Describes subscriber on a publication list. |
| PublicKeyManagement | Reserved for future use. |
| ResultItem | Contains results of asynchronous API call. |
| ResultMessage | Message containing results of async call. |
| Role | Defines roles and permissions assigned to a user in an account. |
| SendEmailMOKeyword | Defines the action that sends a triggered email message to the email addresses defined in an MO message. |
| SendSMSMOKeyword | Defines actions to take when the specified MO keyword is received. |
| SendSummary | A retrieve only object that contains summary information about a specific send event. |
| SentEvent | Contains tracking data related to a send, including information on individual subscribers. |
| SMSMTEvent | Contains information on a specific SMS message sent to a subscriber. |
| SMSSharedKeyword | Contains information used to request a keyword for use with SMS messages in a Marketing Cloud account. |
| SMSTriggeredSendDefinition | Defines the send definition for an SMS message. |
| SubscriberList | Use to retrieve lists for a specific subscriber. |
| SubscriberSendResult | Reserved for future use. |
| SuppressionListContext | Defines a context that a SuppressionListDefinition can be associated with. |
| SurveyEvent | Contains information on when a survey response took place. |
| Template | Represents an email template in a Marketing Cloud account. |
| TimeZone | Represents a specific time zone in the application. |
| TriggeredSendSummary | Summary of results for a specific triggered send. |
| UnsubEvent | Contains information regarding a specific unsubscription action taken by a subscriber. |
| UnsubscribeFromSMSPublicationMOKeyword | Defines keyword used by a subscriber to unsubscribe from an SMS publication list. |