Data synchronization

Path: Integration > Integrating with Microsoft Dataverse > Data synchronization · tier official · system integration · narrative reviewed (checked by Opus)

Overview

This section covers how Business Central exchanges data with Microsoft Dataverse and other Dynamics 365 applications such as Customer Engagement. The entry page explains bidirectional sync, entity mapping, the Base Integration Solution, currency synchronization, and company copying with integration.

The other pages cover customization. One page describes creating integration tables, pages, and mappings, and coupling and uncoupling records. A second page covers option mappings, which couple Business Central records with Dataverse option sets without bidirectional support. A third page describes the AL Table Proxy Generator, which creates proxy tables that represent Dataverse tables in Business Central.

Start with the “Integrate with Microsoft Dataverse via data sync” page for the basics. Then use the proxy table generator and the customization pages when you need to sync additional tables or fields. The Dataverse API subtopic (11 pages) holds further material on the API.

Key points

• Business Central can synchronize data bidirectionally with Dataverse and other Dynamics 365 apps such as Customer Engagement.
• The basic integration uses entity mapping and the Base Integration Solution, and includes currency synchronization and company copying with integration.
• Customizing an integration means creating integration tables, pages, and table and field mappings.
• Records can be coupled and uncoupled, and the customization page also mentions deep linking.
• Option mappings couple Business Central records with Dataverse option sets, but without bidirectional support.
• Option mapping customization uses integration tables, pages, AL extensions, and temporary tables.
• The AL Table Proxy Generator creates integration or proxy tables for Dataverse tables, with field mapping, lookup relationships, and table type selection.
• A Dataverse API subtopic with 11 pages sits under this section.

Subtopics

• Dataverse API (11 pages)

More Learn pages

• Customizing an integration with Microsoft Dataverse: Learn how to integrate your extension with Microsoft Dataverse. This walkthrough takes you through each step.
• Customizing option mappings with Microsoft Dataverse: Learn how to customize option mappings in an integration with Microsoft Dataverse.
• Generate AL Proxy Tables for Dataverse: Use the AL Table Proxy Generator to create Business Central integration tables from Microsoft Dataverse tables and their relationships.
• Integrate with Microsoft Dataverse via data sync: Introduction to how to integrate and use Microsoft Dataverse and its components to connect to other Dynamics 365 applications.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #12261 Stop repeated rescheduling of Dataverse synch jobs on bulk changes (code change): “The Dataverse synchronization job reschedule logic now checks both the scheduled task’s next run time”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 7214 “CDS Companies” · captioned “Dataverse Companies” · on Table 5393 “CDS Company”

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.