Data Model
The CData JDBC Driver 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. You can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
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 driver.
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 JDBC Driver 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 JDBC Driver for Microsoft Exchange to automate working with Microsoft Exchange data.