ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Microsoft Dynamics 365 の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずconnector の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMicrosoft Dynamics 365 から関連するレスポンスデータを返します。
CData Tableau Connector 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. |