Integrating with Common Data Service
Business apps often use data from more than one source. Common Data Service combines data into a single set of logic that makes it easier to connect other Dynamics 365 applications, such as Dynamics 365 Sales or your own application built on top of Common Data Service, to Business Central. For more information about Common Data Service, see What is Common Data Service?
The following steps provide an overview of the steps to integrate Common Data Service with Business Central.
Note
These tasks require the System Administrator security role in Common Data Service and Business Central.
Assign licenses for Common Data Service to the Business Central users who will use the integrated apps.
Set up a connection to Common Data Service. For more information, see Connect to Common Data Service.
Synchronize data between the apps. For more information, see Synchronizing Business Central and Common Data Service.
Getting Started with Common Data Service
To get started with Common Data Service you will need a Microsoft Power Apps account. If you do not already have a Power Apps account, you can get one for free by visiting powerapps.com and choosing the Get started free link. To learn more about how to get started with Common Data Service, see the Get started with Common Data Service module from Microsft Learn.
Bi-Directional or Uni-directional Data Synchronization
Depending on your business needs, you can set up the integration to synchronize data either to or from one Dynamics 365 business app to another, or in both directions in near-real time through Common Data Service. For example, if you integrate Business Central with Dynamics 365 Sales through Common Data Service, a salesperson can create a sales order in Dynamics 365 Sales and the order will be synchronized to Business Central. Conversely, from Dynamics 365 Sales, the salesperson can view information from Business Central about the availability of the item on the order.
Standard and Custom Entities
Common Data Service securely stores data in a set of entities, which are sets of records similar to how a table stores data within a database. Common Data Service includes a base set of standard entities that cover typical scenarios, but you can also create custom entities specific to your organization. In Business Central, you can view standard and custom entities being synchronized on the Integration Table Mappings page.
About the Base CDS Integration Solution
The Base CDS Integration Solution is a key component of the integration. The solution adds the required roles and access levels to the user accounts for the integration, and it creates entities needed to map Business Central company to business unit in Common Data Service.
By default, the Set up Common Data Service connection assisted setup guide will import the solution. To do that, the setup guide uses an administrator user account that you specify. This account must be a valid user in Common Data Service with the following security role:
- System Administrator
For more information, see Setting Up User Accounts for Integrating with Common Data Service and Create users in Microsoft Dynamics 365 (online) and assign security roles.
The administrator account is used only one time during the setup due to configuration changes Base CDS Solution is making in Common Data Service. After the solution is imported the account is no longer needed. Integration will continue to use the user account that is automatically created specifically for the integration.
In addition to customizing Common Data Service, the solution also creates the following roles in Common Data Service for the integration:
- Integration Administrator - Allows users to manage the connection between Business Central and Common Data Service. Typically, this is assigned only to the automatically created user account for synchronization.
- Integration User - Allows users to access synchronized data. Typically, this is assigned to the automatically created user account for synchronization and other users who need to view or access the synchronized data.
For details about each role, such as the permissions and access levels, see Setting Up User Accounts for Integrating with Common Data Service.
During connection setup, integration table mappings that are needed to synchronize data, are created. Entities in Common Data Service are mapped to tables and table fields in Business Central through integration tables. For more information, see Standard Entity Mapping for Synchronization.