The CData SSIS Components for Microsoft Exchange models the Microsoft Exchange 2 and Microsoft Exchange APIs as relational tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

The available entities, as well as any API limitations and requirements for querying these entities, are documented in EWS Data Model and MSGraph Data Model.

Overview

The Data Models illustrate an example of what your Microsoft Exchange environment might look like. The actual data model will be obtained dynamically based on your Microsoft Exchange account.

Key Features

• Tables and Views are dynamically defined to model calendars, documents, and projects on Microsoft Exchange.
• Stored procedures allow you to execute operations to Microsoft Exchange, including downloading and uploading objects.
• Live connectivity to these objects means any changes to your Microsoft Exchange account are immediately reflected when using the component.

EWS Data Model

EWS Data Model describes the schemas available to connect to Microsoft Exchange OnPremise and Microsoft Exchange Online using EWS. You can use tables to work with live Microsoft Exchange data. You can use stored procedures provided by CData SSIS Components for Microsoft Exchange to automate working with Microsoft Exchange data.

MSGraph Data Model

MSGraph Data Model describes the schemas available to connect to Microsoft Exchange Online accounts via the Microsoft Graph. You can use tables to work with live Microsoft Exchange data. You can use stored procedures provided by CData SSIS Components for Microsoft Exchange to automate working with Microsoft Exchange data.