Microsoft Dynamics 365 for Finance and Operations is an enterprise-level ERP solution that can be deployed in the cloud or on-premise.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture Deletes | check | All tables and fields |
| 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 |
| History | ||
| API Configurable | check | |
| Priority-first sync | ||
| dbt Package |
Setup guidelink
Follow our step-by-step Microsoft Dynamics 365 for Finance and Operations setup guide to connect Dynamics 365 for Finance and Operations with your destination using Fivetran connectors.
Sync overviewlink
Microsoft Dynamics 365 for Finance and Operations is built on the SQL Server database. Instead of pulling data from its API, we pull directly from the source database, saving time and effort. Read more about our SQL Server connector.
Schema informationlink
To learn about the Microsoft Dynamics 365 for Finance and Operations schema, read Microsoft’s Common Data Model data schemas and Common Data Model Entity Reference documentation.
The schema rules are detailed in our SQL Server connector documentation.