Synchronizing Data in Business Central with Common Data Service
When you integrate Common Data Service with Business Central, you can decide whether to synchronize data in selected fields of Business Central records (such as customers, contacts, and sales people) with equivalent records in Common Data Service (such as accounts, contacts, and users). Depending on the type of record, you can synchronize data from Common Data Service to Business Central, or vice versa. For more information, see Integrating with Dynamics 365 Sales.
Synchronization uses the following elements:
- Integration table mappings
- Integration field mappings
- Synchronization rules
- Coupled records
When synchronization is set up you can couple Business Central records to Common Data Service records to synchronize their data. You can start a synchronization manually, or based on a schedule. The following table provides on overview of the ways you can synchronize records.
Type | Method | See |
---|---|---|
Manual synchronization | Synchronize on a record-by-record basis. You can synchronize individual records in Business Central, such as a customer, with a corresponding Common Data Service record, such as an account. This is typically how users will work with Common Data Service data in Business Central. |
Couple and Synchronize Records Manually |
Synchronize on a table mapping basis. You can synchronize all records in a Business Central table with an entity Common Data Service entity. |
Synchronize Individual Table Mappings | |
Synchronize all modified records for all table mappings. You can synchronize all of the records that have been modified in Business Central tables since the last synchronization. |
Synchronizing All Modified Records | |
Full synchronization of all data for all table mappings. You can synchronize all of the data in Business Central tables and Common Data Service entities that are mapped, and create new records in the destination solution for uncoupled records in the source solution. Full synchronization synchronizes all data and ignores coupling. Typically, you do a full synchronization when you set up the integration and only one of solutions contains data. A full synchronization can also be useful in a demonstration environment. |
Run a Full Synchronization | |
Scheduled synchronization | Synchronize all changes to data for all table mappings. You can synchronize Business Central with Common Data Service on scheduled intervals by setting up jobs in the job queue. |
Schedule a Synchronization |
Standard Entity Mapping for Synchronization
Entities in Common Data Service, such as accounts, are integrated with equivalent types of entities in Business Central, such as customers. To work with Common Data Service data you set up links, called couplings, between entities in Business Central and Common Data Service.
The following table lists the standard mapping between entities in Business Central and Common Data Service that Business Central provides.
Business Central | Common Data Service | Synchronization Direction | Default Filter |
---|---|---|---|
Salesperson/Purchaser | User | Common Data Service -> Business Central | Common Data Service contact filter: Status is No, User Licensed is Yes, Integration user mode is No |
Customer | Account | Business Central -> Common Data Service and Common Data Service -> Business Central | Common Data Service account filter: Relationship Type is Customer and Status is Active. Business Central filter: Blocked is blank (Customer is not blocked). |
Vendor | Account | Business Central -> Common Data Service and Common Data Service -> Business Central | Common Data Service account filter: Relationship Type is Vendor and Status is Active. Business Central filter: Blocked is blank (Vendor is not blocked). |
Contact | Contact | Business Central -> Common Data Service and Common Data Service -> Business Central | Business Central contact filter: Type is Person and the contact is assigned to a company. Common Data Service contact filter: The contact is assigned to a company and the parent customer type is Account |
Currency | Transaction Currency | Business Central -> Common Data Service |
Tip for Admins: Viewing Entity Mappings
You can view the mapping between the entities in Common Data Service and the tables in Business Central on the Integration Table Mappings page, where you can also apply filters. You define the mapping between the fields in Business Central tables and the fields in Common Data Service entities on the Integration Field Mapping page, where you can add additional mapping logic. For example, this can be useful if you need to troubleshoot synchronization.
See Also
Couple and Synchronize Records Manually
Schedule a Synchronization
Integrating with Dynamics 365 Sales