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 SSIS Components for Salesforce Marketing Cloud Views
| Name | Description |
| AssetTypes | Get all available asset types 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 | Retrieves the history of a journey. Record access cannot exceed 1 GB of file size data. |
| MobileApplications | Returns the list of mobile applications set up in the account, which are used to send push notifications and in-app messages to users. |
| SmsStatusCodes | Query sms status codes. |
| TransactionalMessages | Gets a paginated list of messages that were not sent, ordered from oldest to newest. |