Connector Details

Connector Attributes	Details
Name	Dynamics 365 FO (Dataverse via Synapse Link)
Description	Dynamics 365 Finance and Operations (FO) Synapse Link is a transformative integration that connects Dynamics 365 FO with Azure Synapse Analytics, enabling organizations to seamlessly analyze and derive insights from their financial and operational data. By leveraging Synapse Link, businesses can unlock the full potential of their Dynamics 365 FO data by integrating it with Azure Synapse Analytics, a powerful analytics service. This integration facilitates real-time data ingestion, processing, and analysis, empowering organizations to gain deeper insights into financial performance, supply chain efficiency, and operational effectiveness. With Dynamics 365 FO Synapse Link, organizations can make data-driven decisions, optimize business processes, and drive operational excellence across the enterprise.
Connector Type	Class D

Features

Feature Name	Feature Details
Load Strategies	Full Load, Incremental Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Not Supported

Dynamics 365 FO (Dataverse via Synapse Link) connector has optional values such as Bronze Schema and Silver Schema
Incremental extraction is supported in the connector. The incremental step has been optimized to identify the table partitions that could contain incremental data by comparing the watermark start date to the modified times of the files.
An incremental extraction should use the modifiedon column as the watermark and the id and versionnumber columns as the candidate key.
Occasionally, the extraction will fail while reading a CSV file. Previously, it was thought this was due to corrupt files, but further investigation shows that this happens most frequently on high-traffic tables meaning the problem is a simultaneous read/write. To approach this, the connector will attempt a second read of the source data after 20 seconds. This should mitigate but will not remove the problem entirely. Future optimization might attempt to identify when the files are actively being written.