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,600 points
4,545 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,170 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 22, 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
598 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,170 points
2,037 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,170 points
423 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,170 points
599 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,170 points
628 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,170 points
1,434 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,170 points
256 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,170 points
531 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP