Azure Data Factory (ADF) Integration Runtime Types for SQL Server Integration Services (SSIS) Jobs Migration

Integration Runtime (IR) Types for SQL Server Integration Services (SSIS) Jobs Migration

Question

Cleave is building an Azure Data Factory (ADF) job to implement SQL Server IntegrationServices (SSIS) jobs migration to Azure.

Which of the following Integration Runtime (IR) types he can select?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Correct Answer: A.

Cleave, who is building an Azure Data Factory (ADF) job to implement SQL Server Integration Services (SSIS) jobs migration to Azure, can select the Azure-SSIS Integration Runtime (IR) type.

Azure-SSIS Integration Runtime (IR) is a managed cloud service that is used to run SSIS packages in Azure. It is designed to provide a platform for the migration of SSIS packages from an on-premises environment to the cloud. With Azure-SSIS IR, you can run your SSIS packages on an Azure Virtual Machine or Azure SQL Managed Instance without the need to install and manage the underlying infrastructure. Azure-SSIS IR provides several features such as package execution, package scheduling, package monitoring, and logging.

The other Integration Runtime types available in Azure Data Factory are as follows:

  • Azure: It is used to move data between Azure services or from an on-premises system to Azure.

  • On-premises: It is used to move data between on-premises systems or between an on-premises system and Azure.

  • Self-hosted: It is used to move data between an on-premises system and Azure. Unlike On-premises Integration Runtime, Self-hosted Integration Runtime can be installed on a virtual machine in a public cloud or a private data center.

However, for the purpose of SSIS jobs migration to Azure, only the Azure-SSIS Integration Runtime is applicable.