データモデル
CData Tableau Connector for Microsoft Teams は、テーブル、ビュー、ストアドプロシージャを使用してMicrosoft Teams オブジェクトを使いやすいSQL データベースとしてモデル化します。これらは、スキーマファイルで定義されます。スキーマファイルは、データの構造と構成を定義する、シンプルで読みやすいテキストファイルです。
Microsoft Teams オブジェクトは、テーブル内の他のオブジェクトとリレーションを持ちます。これらのリレーションは外部キーを使用して表されます。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Microsoft Teams アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Teams | Maintains records of Microsoft Teams instances, including team names, visibility settings, and associated group metadata. |
| Channels | Tracks Microsoft Teams channel instances, capturing names, privacy settings, types (standard, private), and team associations. |
| Users | Contains detailed profile, organizational, and directory synchronization information for users in Microsoft Teams, including contact details, licensing, job roles, and Active Directory mappings. |
| Groups | Holds core metadata about Microsoft 365 Groups, including properties required for provisioning and maintaining Teams. |
| GroupMembers | Represents the relationship between Microsoft 365 Groups and their members, including user identifiers and membership roles. |
| GroupOwners | Identifies users assigned as owners of Microsoft 365 Groups that support Teams functionality, enabling management actions. |
| TeamMembers | Retrieves the list of users who are members of a specific Microsoft Teams team. |
| ChannelMembers | Retrieves a list of members belonging to a specific Microsoft Teams channel. |
| Chats | Provides a list of chat threads within Microsoft Teams, including group and one-on-one chats. |
| ChatMessages | Returns messages sent and received in Microsoft Teams chat threads. |
| ChannelMessages | Returns messages and replies exchanged within a Microsoft Teams channel. |
| ChatMembers | Retrieves details of participants in Microsoft Teams chat conversations. |
| TeamsInstalledApps | Maintains records of Microsoft Teams instances, including team names, visibility settings, and associated group metadata. |
| Apps | Contains metadata for third-party and internal apps integrated into Microsoft Teams, including installation details, permissions, and usage metrics. |
| TeamTabs | Documents tabs added to Teams channels, including tab type (Planner, Website, custom app) and configuration data. |
| Schedules | Defines the overarching containers used in Teams Shifts for organizing shifts, time-off requests, and schedule groups. |
| Shifts | Captures detailed shift assignments, including assigned user, start and end times, and optional shift notes. |
| OpenShifts | Stores reusable shift templates created by managers in the Teams Shifts app, used to build individual shift schedules. |
| TimesOff | Logs time-off entries requested by users through the Microsoft Teams Shifts interface, with reason codes and date ranges. |
| TimeOffReasons | Contains predefined labels for time-off requests in Teams Shifts, such as vacation, sick leave, or training. |
ストアドプロシージャ
ストアドプロシージャ は、標準的なCRUD 操作を超える機能を持つSQL スクリプトです。パラメータを受け取り、関数を実行し、OAuth 認証トークンを管理し、サービスからデータを返すことで、処理の成功または失敗を示します。