Microsoft Dynamics 365 Finance and Operations
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.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
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 overview
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 deletes
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 information
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.
Syncing empty tables and columns
Fivetran can sync empty tables and columns for your Microsoft Dynamics 365 Finance and Operations connector. For more information, see our Features documentation.
Limitations
The limitations of the Finance and Operations tables and Azure Synapse Link are also applicable to our Microsoft Dynamics 365 Finance and Operations connector.