ADF - (Part 2) Integrate Data From CRM to External system

 In this blog we will integrate data from Microsoft Dynamic CRM to External system's SQL databse. we are going to integrate Account and Contact tables from CRM to external system

Before starting with this, you should have following things : 

1. Microsoft Dynamics CRM Environment
2. Microsoft SQL Server Management Studio Software(SSMS)
3. Azure Portal account

First connect to your SQL server in SSMS and create Account and Contact Table. You can use following query to create table

CREATE TABLE Account(
	[AccountId] [uniqueidentifier] NULL,
	[AccountName] [varchar](200) NULL,
	[CreditHold] [int] NULL
)

CREATE TABLE Contact(
	[ContactId] [uniqueidentifier] NULL,
	[name] [varchar](200) NULL,
	[MobileNumber] [varchar](50) NULL,
	[FirstName] [varchar](200) NULL,
	[LastName] [varchar](200) NULL,
	[AccountID] [uniqueidentifier] NULL,
	[AccountName] [varchar](200) NULL
)

After creating tables, Navigate to Azure Data factory in azure portal, and Create Dataset for your source and destination. For more details please go through video.

After creating dataset you can create pipeline and use Copy Data activity.

Create Pipeline in Azure portal : 

Use Copy Data Activity and configure Source and Sink(Destination) Dataset.

Source Configuration : 

Sink Configuration :

After this we have to do Source and Sink mapping like below

After successfully running pipeline, you will see CRM data of Account table into your SQL table (destination). 

For more information please checkout below video :)