You can analyze a data export action in the data exchange log. On analyze:

  1. Validation is done: The number of records in the source database (D365 FO/AxDB) is compared to the number of records in the target database (BYOD). If the number of records is equal, no further analysis is done.
  2. If the number of records differs, the records in both databases are compared.
  3. The result of the comparison is stored and can be viewed on the Analysis details page.
  4. A message is shown to indicate the difference.

The result of the comparison, as shown on the Analysis details page, can be:

  • Identical: The record exists in both the source database and the target database.
  • Missing: The record exists in the source database, but not in the target database.
  • Extra: The record exists in the target database but not in the source database.

Note:  You can use the Analysis details data for troubleshooting purposes. This data is not used for synchronization.


Standard procedure

1. Go to Data modeling studio > Data modeling studio > Data exchange monitoring.
2. In the Summary section, find and select the desired record.
3. Of the logged actions as shown in the Log section, you can only analyze data export actions with a data set or data entity name defined in the message.
  In the Log section, find and select the desired export action.
4. Click Analyze.
5. Sub-task: View analysis result.
  5.1 In the Log section, find and select the desired export action.
  5.2 Click Analysis details.
 

Note: Analysis data is only available if you have analyzed the related tables and differences are found.

  5.3 Close the page.
Related to Notes

Troubleshoot data export

 

Provide feedback