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. Hi there, I found your website by means of Google while looking for a
similar matter, your site got here up, it looks great. I have bookmarked it in my google bookmarks. BLUE COOKIES MEDICAL KUSH FOR ALL I have got you bookmarked to look at new stuff you .

  2. I can't praise Programming Homework Help services enough, except for the previous order. It wasn't completed and sent in time. There were also a lot of mistakes and a few plagiarism issues, too, but I'm glad they came in and resolved the issue quite fast. Please make an effort to match experts with the right orders. The previous Python Homework Help must have been an amateur, though I appreciate his food knowledge. He only needs some experience to be perfect.

  3. My lecturer gave us an assignment almost at the end of the semester when we were supposed to be preparing for our examinations. I had to choose between studying for the exams and completing the assignment and going to the exams unprepared. So I paid for Statistics Homework Help on Then, I used the same Statistics Assignment Help expert's services for revising. After my results, I can confirm that working with the expert was a win-win. His assignment results were perfect, and I also scored most of the things he taught me right in the exams.

  4. I need Matlab Homework Help services but can't see the prices. So how do I go about it? It's a Matlab emergency order with 20 questions, and it's due in the next 2 days. The Matlab Assignment Help task is not so complicated, because I'm a first-year student and it's my end-semester exam. Please let me know how to go about the order placement process.

  5. I always show them my good side and I'm extremely grateful for that. There's no single time that I've ever run into an issue, neither have I failed before with their expert Economics Assignment Help. I'm not sure if everyone else always gets the same treatment as mine, but I want to believe that the service is what makes them loyal customers. Otherwise, your Economics Homework Help is worth the investment. I'll keep you posted in case of more.

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

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

  8. I want to thank you for the extra effort put to ensure that I scored the best grade in my Matlab Assignment Help. I've established trust now, and I'll keep coming back to get more projects to be completed by their senior Matlab Homework Help experts. I'll share their good gospel with my friends, too. Thanks for the top mark.

  9. Hi. Thanks a bunch for giving me grades that I never expected from I only used the organization's Economics Assignment Help out of desperation, but it helped me discover that there is likely no better online service like it. I highly recommend the platform and this Economics Homework Help provider (the poster). He's such a fast and professional economist

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

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

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

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

  14. Getting the perfectMatlab homework help solver has always been a challenge because very few Matlab assignments help experts understand all the concepts of Matlab. However, for the time they have been tackling my communications system assignment, they have given me new hope because they may not have one person working on all Matlab topics but they have different tutors in one pool. That is the main reason why I am so comfortable working with them.

  15. I am completely tired. I have just arrived from work only to realize that my economics assignment is due tomorrow. I am not in a position to complete it tonight, and therefore, I am requesting your Economics assignment help. I believe with theEconomics homework help experience, they will help me get better grades. I am proceeding to submit the assignment on your website.

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

  17. Statistics became harder than I thought before I joined the university. To make it worse, my lecturer wasn't the type of person that explains concepts deeply. So it was everyone for himself. Then I started the hunt for where I could getStatistics Homework Help online and bumped into I considered myself lucky to meet this trustworthy expert at my first attempt. He's a one-of-a-kindR Homework Help specialist.

  18. Looking for a master’s levelMatlab homework help solver. I am starting my image processing project but I don’t have time for it. I want aMatlab assignment help expert who will work on it from start to finish. Our professors like it worked step by step so that they can check and return comments for corrections. The tutor I want will be receiving the comments, correcting them, and then returning them to the professor. Once they are corrected and given a go-ahead to continue the tutor will then go ahead to the next chapter until the project is completed. Let me know whether they have someone who can do that.

  19. How can I be sure that they will complete my assignment on time? I have fallen into the hands of fakeEconomics assignment help experts so many times. I am now looking for a genuineEconomics homework help expert who is ready to partner with me for the next 2 years. I would appreciate it if you send me their samples to see the quality of your work

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