JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

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.

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