Microsoft Dynamics 365 Finance
Microsoft Dynamics 365 Finance is an ERP solution for medium to large organizations.
Dynamics 365 Finance allows its users to export their raw data to Azure Data Lake. Our Microsoft Dynamics 365 Finance connector pulls your data from the Azure Data Lake storage connected to your Dynamics 365 Finance environment.
IMPORTANT: Microsoft deprecated the Export to Data Lake feature on October 15, 2023, and will end support on November 1, 2024. As a result, the Microsoft Dynamics 365 Finance connector will stop working. We recommend that you use our Microsoft Dynamics 365 Finance and Operations connector that uses Azure Synapse Link for Dataverse.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables and fields |
History mode | ||
Custom data | check | All tables and fields |
Data blocking | check | Column level, table level, and schema level |
Column hashing | check | |
Re-sync | check | Table level |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guide
Follow our step-by-step Microsoft Dynamics 365 Finance setup guide to connect Dynamics 365 Finance with your destination using Fivetran connectors.
Sync overview
Instead of syncing your data from the Dynamics 365 Finance database, we sync from the Azure Data Lake storage that contains your exported data.
NOTE: We do not sync the columns with
null
values into your destination.