Manually Synchronize Table Mappings
An integration table mapping associates a --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse table that are coupled. Additionally, depending on the configuration of the table mapping, synchronization can create and couple new records in the destination solution for uncoupled records in the source.
Manually synchronizing integration table mappings can be useful during the initial set up of an integration, and when diagnosing synchronization errors.
This article describes three methods for manually synchronizing integration table mappings. Each method provides a different level of synchronization.
Run a Full Synchronization
A full synchronization runs all the default integration synchronization jobs for synchronizing --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse tables, as defined on the Integration Table Mappings page.
A full synchronization performs the following operations For --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse records that are:
- Not coupled, a new matching row will be created and coupled in the opposing solution. Whether and where a row gets created depends on the synchronization direction. For example, when synchronizing data from --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse.
> [!NOTE]
> To achieve this, the full synchronization operation temporarily clears the **Synch. Only Coupled Records** option on the integration table mapping that is used by the synchronization job. At the end of the full synchronization process, you will be prompted whether you want to keep this option cleared for all jobs.
- Coupled, the synchronization direction (for example, from Business Central) is predetermined by the integration table mappings. For more information, see Standard Table Mapping for Synchronization.
[!IMPORTANT]
You typically only use the full synchronization when you initially set up integration between --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse.
To run a full synchronization
Choose the
icon, enter Dataverse Connection Setup, and then choose the related link.[!NOTE] If you want to run a full synchronization for tables through Dynamics 365 Sales, use the Microsoft Dynamics 365 Sales Connection Setup page instead.
Choose the Run Full Synchronization action, and then choose the Yes button.
When the full synchronization is completed, you can specify whether to allow scheduled synchronization jobs to create new records.
If you want all synchronization jobs to create new records in the destination for uncoupled records in the source, choose Yes. This sets the Synch. Only Coupled Records field on the table mappings that are used by the synchronization jobs.
If you want synchronization jobs to run as they did before the full synchronization with regard to creating new records, choose No. This sets the Synch. Only Coupled Records field to the setting it had before the full synchronization.
You can view the results of the full synchronization on the Integration Synchronization Jobs page. For more information, see View the Status of a Synchronization.
Synchronizing All Modified Records
You can use the Common Data Service Connection Setup page to synchronize changes to data in all integration table mappings. This is similar to a full synchronization. It will synchronize data in all coupled records in the --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse tables that are defined in the table mappings. By default, only data that has been modified since the last synchronization will be synchronized. Synchronization jobs synchronize table mappings in the following order to avoid coupling dependencies between the tables:
- CURRENCY
- SALESPEOPLE
- VENDOR
- CUSTOMER
- CONTACTS
You can view the results of the synchronization on the Integration Synchronization Jobs page. For more information, see View the Status of a Synchronization.
[!TIP]
By modifying the integration table mapping in advance, you can create filters to control the data to synchronize, or configure mappings to create new data in the destination solution for uncoupled records or rows in the source. For more information, see Modify Table Mappings for Synchronization.
To synchronize data for all tables
- Choose the icon, enter Microsoft Dynamics 365 Sales Connection Setup, and then choose the related link.
- Choose the Synchronize Modified Records action, and then choose Yes.
Synchronize Individual Table Mappings
You can use the Integration Table Mappings page to run a synchronization job for table mappings. This will synchronize data for all coupled records and rows in the --- author: edupont04
ms.topic: include ms.date: 04/01/2021 ms.author: edupont
Dataverse tables that are defined by the table mapping. By default, only data that has been modified since the last synchronization will be synchronized.
To synchronize records of an integration table mapping
- Choose the icon, enter Integration Table Mappings, and then choose the related link.
- Choose the Synchronize Modified Records action, and then choose Yes.
See Also
Synchronizing Business Central and Dynamics 365 Sales
Setting Up User Accounts for Integrating with Dynamics 365 Sales
--- author: edupont04