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. I often use statistics Homework HelpS because they never fail. However, isn't consistent with their prices. I gave up trying to find a model that could help me predict their prices. I think there should be a hint about their pricing criteria to help students have adequate preparation before submitting their assignments for help. Meanwhile, apart from the unpredictable price, I love everything else about the platform's Statistics Assignment Help.

  3. 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.

  4. 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

  5. The Programming Homework Help service was worth more than every penny I paid for it. Thanks a bunch for giving me their time and dedication. I loved every bit of the experience I had with one of the Java Homework Help experts, who turned out to be very interactive and professional in the way she handled me and my assignment. The lady was experienced and polite. Thanks, too, for the affordable prices and easy payment process. I'll come again for more.

  6. This Statistics Assignment Help provider has been completing my assignments and helping me understand them at the same time. That is, as soon as he submits the assignment's solutions, he commits himself to explain each of them to me on a video call. I always use this service to achieve perfect presentations and understand more concepts for future use in the examinations. Besides, the Statistics Homework Help specialist is a good advisor. He's generous with sharing his experience with students.

  7. Java isn't my cup of tea, but I'm confident that the Programming Assignment Help services are going to make a difference. I'm waiting for their solutions for the firstC++ Homework Help order that I've just sent. I believe that they're going to help me pass and understand some of the major concepts of the programming language.

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