データモデル
CData ODBC Driver for Azure Active Directory はAzure Active Directory をテーブル、ビュー、ストアドプロシージャを備えた使いやすいSQL データベースとしてモデル化します。これらのオブジェクトへのライブ接続により、Azure Active Directory アカウントへのあらゆる変更は本製品 に即座に反映されます。
テーブル
Tables セクションには標準SQL テーブルの詳細が、Views セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Azure Active Directory アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Users | Lists all Azure AD users, including their profile and directory information, within the authenticated permissions. |
| Groups | Lists all Azure AD groups, including Office 365 and security groups, accessible to the authenticated user. |
| Applications | Contains details of all registered applications within the organization for the authenticated user, including app-specific configurations. |
| Devices | Lists all devices registered within the organization that the authenticated user has access to, including device details. |
| DirectoryRoles | Contains a list of directory roles, detailing roles assigned to users and groups within the organization. |
| DirectoryRoleMembers | Identifies the members assigned to specific directory roles within the Azure AD environment. |
| GroupMembers | Provides a detailed view of group memberships, listing all members of each group within the organization. |
| SignIns | Tracks and lists all user sign-in activities for audit and monitoring purposes. |
| DirectoryAudits | Tracks and lists all directory audit events accessible to the authenticated user for compliance and monitoring. |
| Organization | Contains metadata and details about the organization accessible to the authenticated user. |
| RoleAssignments | Displays all role assignments configured within the Azure AD environment. |
| RoleDefinitions | Provides definitions for roles available in Azure AD, detailing their permissions and scope. |
| DeviceRegisteredOwners | Maps device objects to their registered owners for tracking and management purposes. |
| DeviceRegisteredUsers | Associates device objects with their registered users, facilitating detailed user-device relationship analysis. |
| AdministrativeUnits | Displays a comprehensive list of administrative units accessible to the authenticated user, enabling management of organizational structure. |
| AdministrativeUnitMembers | Lists all members of administrative units available to the authenticated user, providing details on their membership relationships. |
| Domains | Displays all domains registered and verified within the organization, along with their configurations. |
| PhoneAuthenticationMethods | Lists phone-based authentication methods configured for users within the organization. |
| UserManagers | Maps users to their assigned managers within the organization for reporting and hierarchy management. |
| SubscribedSKUs | Lists service subscriptions (SKUs) the organization is subscribed to, including details of usage and availability. |
ストアドプロシージャ
Stored Procedures は、SQLクエリを介して呼び出されるアクションです。標準的なCRUD 操作だけでなく、OAuth アクセストークンの取得や更新、グループの管理などのより高度なタスクも実行します。