What is integration runtime in azure data factory?

0 votes
Can somebody explain what is integration runtime in azure data factory? Thanks.
Jan 2 in Azure by anonymous
• 18,400 points
2,023 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 by anonymous
• 58,130 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 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
274 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is affinity group in azure?

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

answered Jan 21 in Azure by Sirajul
• 58,130 points
279 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 in Azure by Sirajul
• 58,130 points
212 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 in Azure by Sirajul
• 58,130 points
671 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 in Azure by Sirajul
• 58,130 points
103 views
0 votes
1 answer

Incremental data copy using azure datafactory.

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

answered Jan 2 in Azure by Sirajul
• 58,130 points
242 views