Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft Dynamics 365.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Dynamics 365, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Microsoft Dynamics 365 Stored Procedures
| Name | Description |
| CreateAssociation | Creates an association between two entities using the specified navigation property. This procedure is essential for linking related entities dynamically and requires the IncludeNavigationProperties connection property to be enabled. |
| CreateSchema | Generates a schema file for a specified table or view, providing a structural blueprint for data organization. |
| EnableChangeTracking | Enables change tracking on an entity, allowing incremental updates and efficient data synchronization. Note: This feature is irreversible once activated. |
| GetAdminConsentURL | Retrieves the admin consent URL required for granting domain-wide access to the application by an administrator. Necessary when using custom OAuth credentials. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Dynamics 365. |
| GetOAuthAuthorizationUrl | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| ListAssociations | Lists all associations for a specified table and its related navigation properties. Requires the IncludeNavigationProperties connection property to be enabled. |
| ListNavigationProperties | Displays the navigation properties for a specified table, showing their relationships with associated tables. Useful for defining entity associations and dependencies. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Dynamics 365 resources without requiring reauthorization from the user. |
| RemoveAssociation | Deletes an association between two entities based on a specified navigation property. This requires the IncludeNavigationProperties connection property to be enabled. |