What is integration runtime in azure data factory

0 votes
Can somebody explain what is integration runtime in azure data factory? Thanks.
Jan 2, 2020 in Azure by anonymous
• 19,610 points
3,402 views

2 answers to this question.

0 votes

The integration runtime is the compute infrastructure that Azure Data Factory uses to provide the following data integration capabilities across various network environments:

  • Data movement: For data movement, the integration runtime moves the data between the source and destination data stores, while providing support for built-in connectors, format conversion, column mapping, and performant and scalable data transfer.

  • Dispatch activities: For transformation, the integration runtime provides capability to natively execute SSIS packages.

  • Execute SSIS packages: The integration runtime natively executes SSIS packages in a managed Azure compute environment. The integration runtime also supports dispatching and monitoring transformation activities running on a variety of compute services, such as Azure HDInsight, Azure Machine Learning, SQL Database, and SQL Server.

answered Jan 2, 2020 by anonymous
• 59,070 points
What is the limit on the number of integration runtimes?
+1 vote
IR is like act as brige between your ADF and network (public/private) . If you want to connect to on-premise sql server then you need to create self Hosted IR because on-premise is private network and azure sql is public network.
answered Feb 21, 2020 by yahya sharif

Related Questions In Azure

0 votes
0 answers

What is the use of cloud service configuration file (.cscfg) in azure?

What is the use of cloud service ...READ MORE

Sep 30, 2019 in Azure by Pratibha
• 3,690 points
460 views
0 votes
1 answer

Does data factory have self-hosted integration runtime for data flows ?

Self-hosted IR is an ADF pipeline construct ...READ MORE

answered Jan 3, 2020 in Azure by Sirajul
• 59,070 points
1,402 views
0 votes
1 answer

What is Azure Data Lake? Is it a Azure cloud service?

Azure Data Lake is a cloud solution ...READ MORE

answered Jan 13, 2020 in Azure by Sirajul
• 59,070 points
308 views
0 votes
1 answer

What is affinity group in azure?

Affinity groups ensure that resources created within ...READ MORE

answered Jan 21, 2020 in Azure by Sirajul
• 59,070 points
447 views
0 votes
1 answer
+1 vote
1 answer

What is redis cache in azure?

The concept of Azure Cache for Redis ...READ MORE

answered Jan 23, 2020 in Azure by Sirajul
• 59,070 points
427 views
0 votes
1 answer

Azure Data factory : Pipeline data flow execution fails.

This error usually occurs when dataset contains ...READ MORE

answered Jan 2, 2020 in Azure by Sirajul
• 59,070 points
1,070 views
0 votes
1 answer

How can I schedule a pipeline to run in azure datafactory?

You can use the scheduler trigger or ...READ MORE

answered Jan 2, 2020 in Azure by Sirajul
• 59,070 points
186 views
0 votes
1 answer

Incremental data copy using azure datafactory.

If your blob is well named with a ...READ MORE

answered Jan 2, 2020 in Azure by Sirajul
• 59,070 points
388 views