How to Create Self Hosted IR and Load Data From On-Prem to Azure Cloud - Azure Data Factory Tutorial

Issue:  How to Create Self Hosted IR and Load Data From On-Prem to Azure Cloud - Azure Data Factory Tutorial 2021.

In this blog post we are going to learn how to create Self Hosted IR and load data from On-Prem to azure cloud azure data factory tutorial 2021 step by step.

Create & configure A self-hosted integration runtime :

Open azure data factory & click on manage tab, click on integration runtime and click on new:

Fig - 1 : Create & Configure A Self-Hosted Integration Runtime

Click On azure , self-hosted insert information and click create:

Fig-2 : Information column name & description

Click on the download & install integration runtime.

Fig- 3 Download & install integration runtime

Open integration runtime & copy keys from azure data factory which is shown in below picture

Fig- 4: Copy the keys for self-hosted integration runtime 

Paste the copied key and click on register & then click finsh.

Fig- 5: Insert copied keys for registration

Create a pipeline give the name to our pipeline and click & drag copy activity :

Fig-6 : perform copy activity 

Click on source + new and select sql server & click continue

Fig- 7: Create new source for copy activity

give name , crete new link server, select server name, select self hosted IR,  give data base name + tb user + password and click test connection.

Fig- 8: Create new linked service

Click on open

Click on preview


Click on azure blob storage + select csv file + set properties insert name & link service + create output connection & click ok + debug  and the file will be generated

Fig-9 : Create new blob storage step by step

How To Copy File from local folder to Cloud
Go to the drive where the folder is located right click on the folder go to properties and click sharing and then click share and provide the permission to the user, and click share.

Fig- 10: How To Copy File from local folder to Cloud

copy shared link :

Go to azure data factory and create new pipeline, drag copy data activity and click on source, then click on new then select file system

Fig- 11: create new pipeline

Select binary and click continue

 Name the file and create new linked service 

In the link service select server name, then select self hosted IR, then host then  user name & Password then click on test connection and click create

Click open 

and browse the required file and click ok

go to pipeline and click sink click on Blob Storage Then Click on Binary then Select Azure Blob Storage Link and Select  the output folder and click ok

Click ok Debug

As you can see in below picture task is completed:


How to Create Self Hosted IR and Load Data From On-Prem to Azure Cloud - Azure Data Factory Tutorial


  1. I got the best Programming Assignment Help services from their experts, who showed the highest level of expertise and professionalism. Handling my project faster than expected was the best thing they could do to it, especially given that I also wanted some revision time with the paper and solutions. I'm glad I was able to understand a few more C concepts from the properly-arranged solutions. Cheers to the C Homework Help tutor

  2. The possibly genuine benefit of this is in the event that you plan on having say 60 destinations and need to spread them more than 6 facilitating accounts. Else you'll save immense measures of your online financial plan by facilitating new spaces inside your own current facilitating account.

  3. The location of this new residential project in the Noida expansion area provides an ideal way to easily achieve several important goals, including an education stadium, restaurant, shopping center, and corporate center.If you have any Query visit Now:-Ace Divino

  4. We have been providing quality economics assignment since 2008. Our team of experts has helped thousands of students achieve their academic goals.