EWS Data Model
The CData Excel Add-In for Microsoft Exchange models Microsoft Exchange data as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. The add-in uses the Microsoft Exchange API to process supported filters. The add-in processes other filters client-side within the add-in.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Microsoft Exchange account.
The following tables and views are shipped with the add-in:
| Table | Description |
| Calendar | Stores and manages calendar items such as appointments and meetings. It supports operations to create, retrieve, update, and delete (CRUD) calendar entries, including time, location, subject, and associated metadata. |
| Calendar_OptionalAttendees | Captures information about optional attendees for scheduled calendar events. It requires an associated item Id to retrieve attendees linked to a specific meeting or appointment. |
| Calendar_RequiredAttendees | Stores data on required attendees for calendar events. The queries must specify an item Id to identify the associated meeting and its required participants. |
| Contacts | Maintains contact information including names, email addresses, phone numbers, and job titles. It supports full CRUD operations for managing a user's personal or shared address book. |
| DeletedItems | Represents items moved to the Deleted Items folder, including messages, calendar events, and tasks. It allows recovery, permanent deletion, or inspection of deleted content. |
| Drafts | Holds unsent email drafts. This enables operations to create new drafts, update draft content, delete drafts, or retrieve draft messages for review or sending. |
| Folders | Manages user-defined and system folders such as Inbox, Sent Items, and custom folders. It supports folder hierarchy operations like creation, deletion, and renaming. |
| Inbox | Contains received email messages directed to the user's inbox. It allows access to individual messages with full CRUD capabilities for inbox content management. |
| Outbox | Temporarily stores outgoing email messages pending delivery. The items in this table can be created, reviewed, or deleted before transmission is completed. |
| SentItems | Archives sent email messages for auditing and retrieval. It allows querying and management of previously sent emails. |
| Tasks | Maintains a list of tasks, including due dates, completion status, priorities, and reminders. It supports full task lifecycle management through CRUD operations. |
| Calendar_ModifiedOccurrences | Provides a filtered view of calendar items that have had their occurrences modified, such as rescheduled or updated recurring meetings. This is useful for tracking changes in recurring events over time. |
Stored Procedures
Stored Procedures are SQL scripts that extend beyond standard CRUD operations. They enable advanced operations such as sending emails, managing attachments, and handling OAuth authentication flows.