ストアドプロシージャ

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

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

CData SSIS Components for Microsoft Dynamics 365 ストアドプロシージャ


Name	Description
CreateAssociation	Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
CreateSchema	Creates a schema file for the specified table or view.
GetAdminConsentURL	Gets the admin consent URL that must be opened separately by an admin of a given domain to grant access to your application. Only needed when using custom OAuth credentials.
GetOAuthAccessToken	Gets the auth token used to authenticate to the service.
GetOAuthAuthorizationUrl	Gets an authorization URL from the data source. The authorization URL can be used to generate a verifier required to obtain the OAuth token.
ListAssociations	Lists associations for a given table and navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
ListNavigationProperties	Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
RefreshOAuthAccessToken	Obtains an updated OAuthAccessToken if passed a token to refresh.
RemoveAssociation	Removes an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.