Microsoft Dynamics 365 is a cloud-based ERP and CRM enterprise system built by Microsoft for maximum flexibility and extensibility.
|Data blocking||check||Column level, table level, and schema level|
|Re-sync||check||Table level and connector level|
|Fivetran data models|
We use the Common Data Service to retrieve data.
Dynamics 365 applications also use the Common Data Service to store and secure application data. The service stores the data within an entity set. An entity is a set of records used to store data. The service includes a set of standard entities and also allows you to create custom entities.
If you don’t see an application you need listed, reach out to our support team.
Follow our step-by-step Microsoft Dynamics 365 setup guide to connect Microsoft Dynamics 365 with your destination using Fivetran connectors.
Fivetran creates a table for each Entity in the Dynamics 365. You may select/deselect entities that you do not want to sync from the Dynamics 365 dashboard.
Fivetran creates an additional table
STRINGMAP to sync the string values and the mapping information of your picklist attributes. We sync the following fields:
|Field Name||Data Type|
After establishing connection, the connector would start in a Paused state. After un-pausing Fivetran starts to sync each accessible Entity. It starts to fetch entity records from the beginning of time. Dynamics 365 allows Entities to be configured for Change Tracking. You may choose to Enable or Disable Change Tracking. Enabling Change Tracking for an Entity will allow Fivetran to fetch only those records which have been created/modified/deleted after the last sync. Entities, which do not have Change Tracking enabled, will be synced once a day and all records from the source system will be synced.
Syncing empty tables and columnslink
Fivetran can sync empty tables and columns for your Microsoft Dynamics 365 connector. For more information, see our Features documentation.