Azure Data Factory Integration Runtime Types

In the previous post, we learnt about Azure Data Factory Integration Runtime. In this post, we will discuss Integration Runtime Types. There are three types of Integration Runtime. Microsoft provides the table and illustration below to better understand the usage scenarios of different integration runtimes:

Integration RuntimePublic networkPrivate network
1Azure Data Flow, Data movement, Activity Dispatch 
2Self-hostedData movement, Activity DispatchData movement, Activity dispatch
3Azure-SSISSSIS package executionSSIS package execution

As we can see from the above diagram, with the Azure Integration runtime, we can run data flows , perform copy activity between various data stores in Azure and dispatch transform activity for various data stores in Azure. Azure Integration runtime can be used while connecting to data stores and compute services with public access endpoints.

Self-hosted integration runtime can be used to run a copy activity between cloud data stores and a data store in an on-prem private network behind a firewall or a Virtual Private Network (VPN).

Azure-SSIS Integration Runtime enables users to run SSIS packages natively within the Azure environment i.e. without making any changes. Azure-SSIS integration Runtime can be either provisioned in the public cloud or in a private network (VPN). With Azure-SSIS Integration runtime, Microsoft provides users the flexibility to choose either Azure data factory pipelines or use existing SSIS packages.

Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

8 thoughts on “Azure Data Factory Integration Runtime Types

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: