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,598 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.

Hope this helps!!

To know more about Azure, enroll today with our Azure certification course.

Thanks!!

answered Jan 2, 2020 by anonymous
• 59,090 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
475 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,090 points
1,500 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,090 points
323 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,090 points
475 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,090 points
461 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,090 points
1,105 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,090 points
195 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,090 points
403 views