Microsoft Dynamics 365link
Microsoft Dynamics 365 is a cloud-based ERP and CRM enterprise system built by Microsoft for maximum flexibility and extensibility.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture Deletes | check | |
| Custom Data | check | |
| Data Blocking | check | Column level, table level, and schema level |
| Column Hashing | check | |
| Re-sync | check | Table level and connector level |
| History | ||
| API Configurable | ||
| Priority-first sync | ||
| dbt Package |
Supported applicationslink
| Application Name |
|---|
| Customer Service |
| Field Service |
| Marketing |
| Sales |
| Talent |
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.
Setup guidelink
Follow our step-by-step Microsoft Dynamics 365 setup guide to connect Microsoft Dynamics 365 with your destination using Fivetran connectors.
Schema informationlink
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.
To zoom, open ERD in new window
StringMap tablelink
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 |
|---|---|
| stringmapid 🔑 | STRING |
| attributename | STRING |
| attributevalue | LONG |
| displayorder | LONG |
| langid | LONG |
| objecttypecode | STRING |
| organizationid | STRING |
| value | STRING |
| versionnumber | STRING |
Historical synclink
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.