Sign in

Self Hosted Integration Runtime

A self-hosted integration runtime can perform copy operations between a cloud data store and a private network data store.

It can also send transform tasks to compute resources in an on-premises network or an Azure virtual network.

An on-premises machine or a virtual machine inside a private network is required for the installation of a self-hosted integration runtime.

For multiple on-premises data sources, you can use a single self-hosted integration runtime.

It is also possible to share it with another data factory within the same Azure Active Directory (Azure AD) tenant.

When you move data between…


Step on how to upload images to blob storage from web app

You can use either Azure Powershell or Azure portal to do the following steps

Create a resource group

Create a storage account

Create Blob storage containers

Create an App service plan

Create the web App

Configure web app setting to store storage account credentials

Use the following method to upload the image to Blob Storage

public static async Task<bool> UploadFileToStorage(Stream fileStream, string fileName,
AzureStorageConfig _storageConfig)
{
// Create a URI to the blob
Uri blobUri = new Uri(“https://” +
_storageConfig.AccountName +
“.blob.core.windows.net/” +
_storageConfig.ImageContainer +
“/” + fileName);


How to automate pipeline run in DataFactory from any application

Install nuget packages

In any project create a method which will initialize azure settings such as subscriptionid, token, pipeline name, datafactory name as shown in the diagram below , in this example I hav considered a console application in C#.you can take the same reference for different application also.


Go to Key Vault Resource

If Key Vault is not available you need to add Key Vault resource Add KeyVault Resource

  • Go to access policies
  • Add Access Policies

Open Azure portal ,search Azure Active Directory

If the app is already registered go to App Registrations in the side panel other wise select New Registration.

  1. Add Name for the application
  2. Select Supported Account Types
  3. Add Redirect URI (this is optional but a value is required)
  4. Once the application is registered ,open the application and go to Authentication Menu on left side panel.
  • Add Platform from the options available
  • Select the options Access Tokens and ID tokens in Implicit grant and hybrid flows.

The Integration Runtime (IR)is the compute infrastructure that uses Azure Data Factory. It basically means that it uses IR to run copy activities between cloud data store and a private network. …

Sudip Ray

Software Developer having interest in Freelancing ,B2B and SaaS

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store