Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData JDBC Driver for Salesforce Marketing Cloud Views
| Name | Description |
| AssetTypes | Get all available asset types in Salesforce Marketing Cloud. |
| CampaignAssets | Retrieve all campaign assets in Salesforce Marketing Cloud. |
| Contact | Retrieve contacts in Salesforce Marketing Cloud. |
| Contacts | Retrieve all contacts in Salesforce Marketing Cloud. |
| JourneyAuditLogs | Retrieves an audit log of a journey and its versions. |
| JourneyHistory | Gives the history of a journey. Record access cannot exceed 10,000th item |
| SmsStatusCodes | Query sms status codes. |
| TransactionalMessages | Gets a paginated list of messages that were not sent, ordered from oldest to newest. |