The CData MCP Server for Microsoft Dynamics 365 Business Central models Microsoft Dynamics 365 Business Central data in relational tables, views, and stored procedures. The table definitions are dynamically obtained from the Microsoft Dynamics 365 Business Central OData service when you connect. Any changes to the metadata, such as new or removed columns, or changes in data type, are automatically loaded when you reconnect.

Tables

The server models the writable entities described in the service metadata document as bidirectional Tables.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, such as retrieving or refreshing OAuth access tokens.