[Microsoft Dynamics 365, Microsoft Dynamics 365, is a cloud-based ERP and CRM enterprise system built by Microsoft for maximum flexibility and extensibility., Features, 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 applications, 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 dont see an application you need listed, reach out to our support team.”, Setup guide, Follow our step-by-step , Microsoft Dynamics 365 setup guide, to connect Microsoft Dynamics 365 with your destination using Fivetran connectors., Schema information, 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 table, 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 sync, After establishing connection, the connector would start in a , Paused, state.nAfter un-pausing Fivetran starts to sync each accessible Entity. It starts to fetch entity records from the beginning of time.nDynamics 365 allows Entities to be configured for , Change Tracking, . You may choose to Enable or Disable , Change Tracking, .nEnabling , Change Tracking, for an Entity will allow Fivetran to fetch only those records which have been created/modified/deleted after the last sync.nEntities, 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 columns, Fivetran can sync empty tables and columns for your Microsoft Dynamics 365 connector. For more information, see our , Features documentation, .]