テーブル
本製品 はSalesforce Marketing Cloud のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData JDBC Driver for Salesforce Marketing Cloud テーブル
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. |
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. |