Microsoft Dynamics 365 Finance and Operations Private Previewlink
Microsoft Dynamics 365 Finance and Operations is an ERP solution for medium to large organizations.
Microsoft Dynamics 365 Finance and Operations uses Azure Synapse Link for Dataverse which enables you to choose and reduplicate data from the finance and operations apps and export it to the Azure Data Lake Storage (ADLS) continuously. Our Microsoft Dynamics 365 Finance and Operations connector pulls data from the Azure Data Lake Storage connected to your Azure Synapse Link environment.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
Custom data | check | All tables |
Data blocking | check | Column level, table level, and schema level |
Column hashing | check | |
Re-sync | check | Table level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Microsoft Dynamics 365 Finance and Operations to connect Microsoft Dynamics 365 Finance and Operations with your destination using Fivetran connectors.
Sync overviewlink
Instead of syncing your data from the Dynamics 365 Finance and Operations database, we sync from the Azure Data Lake Storage that contains your exported data.
Capturing deleteslink
When Microsoft Dynamics 365 Finance and Operations deletes a row in a table, Azure Synapse Link adds a new row for the deleted record and marks the IsDelete
value as True
to the file in the corresponding incremental folder in ADLS. For the deleted records, we use the value in the IsDelete
column and update it in the _fivetran_deleted
column accordingly.
Schema informationlink
All the tables have an id
column, which represents a unique row ID. This column is used as a primary key for all the tables.