Dynamics 365 CE/CRM Integration Components

The Microsoft Dynamics 365 CE/CRM components are the components found within the SSIS Integration Toolkit for Microsoft Dynamics 365 that facilitate integration with Microsoft Dynamics 365 CE/CRM.

You can use these components for integration or migration with any of the following:

  • Microsoft Dynamics 365 for Customer Engagement (Sales/Customer Service/Field Service/Project Service Automation/Marketing)
  • Microsoft Dynamics CRM Server 2016, 2014, 2012, 2008 R2, 2008 or 2005

There are 4 components available for use when working with Microsoft Dynamics 365 CE/CRM data:

  • CDS/CRM Connection Manager
    • Facilitates the connection to the appropriate Microsoft Dynamics 365 CE or CRM server instance.
  • CDS/CRM Source Component
    • Facilitates reading data from the Microsoft Dynamics 365 CE/CRM server.
    • Read data through CRM entity, FetchXML query, EntityChanges, or AuditLogs options.
    • The most sophisticated support of complex FetchXML queries. Read CRM audit history in a structured way using the unique AuditLogs feature. Read CRM delta changes easily using the EntityChanges option in the CRM source component.
  • CDS/CRM Destination Component
    • Facilitates writing data to the Microsoft Dynamics 365 CE/CRM server
    • Ten different write actions for writing to the CRM server: Create, Update, Delete, Upsert, Merge, Convert, Send, BulkDelete, ExecuteWorkflow, and CalculateRollUpField.
    • Four Update & Upsert matching options for the most robust solution to write incremental changes to CRM (Primary Key, CRM Duplicate Detection, Manually Specified Fields, and Alternate Key).
    • Write to CRM many-to-many relationships without a single line of code.
    • Text Lookup feature to perform a lookup to CRM records using either text or integer values as the input includes support for using CRM alternate keys.
    • The unique "Change Flag Field(s)" option makes it easy to track the source of the last changes in CRM.
    • "Ignore Null-Valued Fields"  to avoid overwriting existing values with an empty value.
    • "Ignore Unchanged Fields" to avoid triggering some unnecessary plugins or workflows to significantly improve integration performance in some cases.
  • CRM OptionSet Mapping Component
    • Manages the translation and mapping for CRM OptionSet (or picklist) field's option values.
  • Dynamics CRM Command Task
    • A control flow component that can be used to translate SQL scripts or commands into executable Dynamics 365/Dataverse service calls to perform actual data writes at SSIS control flow level.
  • Premium Service Lookup Component
    • Provides lookup capabilities by searching records in Dynamics 365 CE/CRM or CDS instance.
  • Advanced Topics & Known Limitations

Video Resources

Youtube Video - Getting started with the SSIS Integration Toolkit for Microsoft Dynamics 365 CRM