SSIS Dynamics CRM Integration Pack

SSIS Dynamics CRM 365 Integration Pack

SSIS Dynamics CRM Integration Pack is your complete toolset to automate Dynamics CRM integration scenarios in SSIS. Using simple drag and drop interface you can read data from Microsoft Dynamics CRM or Bulk insert/update data into Dynamics CRM. It includes Dynamics CRM Source Connector, Dynamics CRM Destination Connector and Dynamics CRM Connection Manager for Microsoft Dynamics 365 (Online) and CRM on-Premises.

Features

  • Support for Microsoft Dynamics 365 (Online) and CRM on-premises
  • Multiple modes to read data from Dynamics CRM (i.e. Table or Query)
  • Support for FetxhXML Query Language (FetchXML is Dynamics CRM Query Language)
  • Support for automatic conversion between UTC date/time and Local date/time
  • Intuitive user interface with Dynamics CRM Object Browser
  • Load data into Dynamics CRM.com from any source with drag and drop user interface
  • Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert)
  • Support for executing assignment rule after Update/Insert operation for Case, Lead or Account
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: Dynamics CRM related articles
Download Buy View All Tasks

SSIS Dynamics CRM Source Connector (Query/Read/Extract CRM Data)

SSIS Dynamics CRM Source Connector SSIS Dynamics CRM Source Connector can be used to extract large amount of data from Dynamics CRM.com without any programming. You can use simple Table mode or Query mode with full FetchXML query language support.

Read more

SSIS Dynamics CRM Destination Connector (Bulk Insert, Update, Delete, Upsert)

SSIS Dynamics CRM Destination Connector SSIS Dynamics CRM Destination can be used to bulk insert/delete large amount of records to Dynamics CRM storage from any data source using SSIS.

Read more
Download View All Tasks