Stored Procedures

ストアドプロシージャはファンクションライクなインターフェースで、Azure Active Directory の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAzure Active Directory から関連するレスポンスデータを返します。

CData SSIS Components for Azure Active Directory Stored Procedures


Name	Description
ActivateDirectoryRole	Activates a directory role.
AddGroupApplicationRoleAssignment	Add group to an Application Role Assignment.
AddGroupMember	Adds a member to a group.
AddMember	Add member to a directory role.
AddUserApplicationRoleAssignment	Add user to an Application Role Assignment.
CheckMemberObjectsForUser	Check for membership in groups, administrative units, or directory roles for a user.
FetchAdditionalUserFields	Fetch all T1, T2, and T3 fields for a specified user.
GetAdminConsentURL	Gets the admin consent URL that an admin of a given domain must open separately to grant access to your application. Only needed when using custom OAuth credentials.
GetOAuthAccessToken	Gets an authentication token from AzureActiveDirectory.
GetOAuthAuthorizationURL	Gets the authorization URL that the user must open to grant access to your application. Only needed when developing Web apps. You request the auth token from this URL.
PromoteDomain	Promotes a domain.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various Office 365 services.
RemoveGroupApplicationRoleAssignment	Removes a group from an Application Role Assignment.
RemoveGroupMember	Remove a member from a Group.
RemoveMember	Removes a member from a directory role.
RemoveUserApplicationRoleAssignment	Remove a user from an Application Role Assignment.
VerifyDomain	Verifies a domain.