SSIS Dynamics CRM Source (Microsoft Dynamics 365, On-Premises CRM)

SSIS Dynamics CRM Source Connector (Dynamics 365 / On-Premises CRM)

SSIS Dynamics CRM Source Connector can be used to read data from Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. You can use simple Table mode or write custom Query to extract desired data.

Features

  • Multiple modes (i.e. Table or Query) to read data from Dynamics CRM Online or On-Premises version
  • Support for FetchXML Query language
  • Support for automatic conversion between UTC date/time and Local date/time
  • Intuitive user interface with Dynamics CRM Object Browser
  • Support for Advanced data types such as Lookup, PartyList, Multi-Select PickList
  • Support for data preview, max rows, batch size
  • Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} )
  • Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see Dynamics CRM related articles

Download Help File Buy
View All Tasks

Featured Articles

ScreenshotsArticles / Useful LinksSystem Requirements
SSIS Dynamics CRM Source - Create new connection to Microsoft Dynamics 365 (CRM Online)


SSIS Dynamics CRM Source – Create new connection to Microsoft Dynamics 365 (CRM Online)

SSIS Dynamics CRM Source - Read data in Table mode


SSIS Dynamics CRM Source – Read data in Table mode

SSIS Dynamics CRM Source - Read data in Query mode using FetchXML


SSIS Dynamics CRM Destination – Read data in Query mode using FetchXML

Click here to learn more about System Requirements
Download View All Tasks Like This