How to Configure A Self-Hosted IR as a Proxy For An Azure SQL Server Integration Service IR in Azure Data Factory.

Issue: How to Configure A Self-Hosted IR as a Proxy For An Azure SQL Server Integration Service IR in Azure Data Factory.

In this article, we are going to learn how to configure a self-hosted IR as a proxy to An Azure SQL Server IR in Azure Data Factory, let's start our demonstration.

How to create Self Hosted Integration Runtime:

To create a self-Hosted IR, go to the Azure Data factory studio, go to the Manage tab, click on integration runtimes, and click on the + New button.

Select the Azure Self-Hosted, then click on continue.

Then select Self-Hosted, and click on continue then name your Self-Hosted IR and click on Create.

Open the Internet Explorer and download the latest version of Integration Runtime and then install it.

Once the Integration Runtime is installed successfully, it will open another window go back to the Azure data factory, go to the integration runtimes select your IR and copy the Authentication key, then paste it and click on Register once it got registered click on finish. 

How to Create SSIS Package:

Open Visual Studio, then click on File, select new project and it will open a wizard, select integration services, then click on integration services project, then make your project and select the location then click on ok and then inside the project you can make data flow task and copy your data from on-prem to Azure SQL database, etc.

How to create Blob Storage:

Open the Azure portal, then find and go to the Storage accounts, then click on the + Create button to create new blob storage.

In the basics tab, select your Azure subscription, then select your resource group, then name your blob storage, Select your region, then click on Review + Create and then click on create, it will create your blob storage and later you can create multiple containers in your blob storage as per your requirement.

Once Our blob storage is created go to the Azure Data Factory studio, then go to the Manage tab, and create a new linked service for your blob storage.

Once our linked service is created, now create Integration Runtime.

Once we created the linked service, now go to the visual studio and deploy the SSIS package.

Select SSIS in SQL Server and then click on next.

Provide the server name, then select authentication type, then provide username and password, then click on connect then select the path where our packages will be deployed, and then click on next, it will start deploying once it will done get click on close.

To see your deployed packages, Open the SQL Server Management studio, then connect with your SQL server database, and then in the packages you will find your deployed packages.

Next, open your Azure data factory studio, then go to the author tab, and then click on + sign to create a new pipeline, then find and drag ''Execute SSIS package'' activity, then go to the settings tab, and select Azure SSIS IR, then provide the package location, folder name, select the project and then select the package which is Lift and Shift package, it will load the data from on-premises to Azure SQL database and here we are good to go, click on Debug.

Video Demo: How to Configure A Self-Hosted IR as a Proxy For An Azure SQL Server Integration Service IR in Azure Data Factory.