EWS データモデル

CData SSIS Components for Microsoft Exchange は、テーブル、ビュー、ストアドプロシージャを使用してMicrosoft Exchange データを使いやすいSQL データベースとしてモデル化します。これらは、スキーマファイルで定義されます。スキーマファイルは、データの構造と構成を定義する、シンプルで読みやすいテキストファイルです。本製品はMicrosoft Exchange API を使用してサポート対象のフィルタを処理します。本製品はクライアント側で本製品内で他のフィルタを処理します。

テーブル

テーブルセクションには標準SQL テーブルの詳細が、ビューセクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Microsoft Exchange アカウントでのアクセスを想定したサンプルが含まれています。

以下のテーブルおよびビューは本製品に同梱されています。


テーブル	説明
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.

ストアドプロシージャ

ストアドプロシージャは、標準的なCRUD 操作を超える機能を持つSQL スクリプトです。 E メールの送信、添付ファイルの管理、OAuth 認証フローの処理などの高度な操作を可能にします。