Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is an enterprise resource planning (ERP) system from Microsoft, part of the Microsoft Dynamics 365 product family. The product is designed to assist with finance, manufacturing, customer relationship management, supply chains, analytics and electronic commerce operations of small to medium businesses (SMB).

How to Connect

There are two ways to connect to Microsoft Dynamics 365 Business Central: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Microsoft Dynamics 365 Business Central button in the list of connectors or type ‘dynamics’ in the search field and select it:

3. Enter the data source name, Client ID, Client Secret, Database, and Tenant ID, and click Connect:

Usage 

The Microsoft Dynamics 365 Business Central API connector introduces a new virtual schema dynamics_bc. Initially, the schema contains only procedures for reading metadata in OData format and generates dynamically set of procedures based on entities described in metadata. A typical set of generated procedures is shown on the screenshot:

In addition to these public API procedures, there is the dynamics_bc_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping dynamics_bc_examples.