Managed Identity from Azure SSIS IR to access Azure SQL PaaS ?

Question

We are migrating our SSIS Packages to Azure Cloud , using the lift and shift approach feature of Azure SSIS IR ( we don't want to provision a VM in azure having SSIS. i want to use the Azure SSIS IR runtime of ADF V2 )

In our Azure Datafactory , we are using Azure SSIS IR , which is VNet Integrated to enable connection to on-premises SQL Servers.

We will execute our SSIS Packages by creating a Pipeline which uses the "Execute SSIS Package" activity. Few of the SQL databases in our case will remain on-premise (business requirement) and couple of databases are on Azure SQL PaaS.

Can we connect using Managed Identity from Azure SSIS IR to Azure SQL PaaS ?
Please advise

Answer 1

Hi @MS Techie ,

Thanks for the ask and using Microsoft Q&A forum.

Can we connect using Managed Identity from Azure SSIS IR to Azure SQL PaaS ?

Yes, when you run SSIS packages on Azure-SSIS IR, you can use managed identity authentication to connect to various Azure resources

Currently managed identity authentication is supported in the following connection managers.

OLE DB Connection Manager

ADO.NET Connection Manager

Azure Storage Connection Manager

For more info please refer to below document:

• Enable Azure Active Directory authentication for Azure-SSIS Integration Runtime

Hope this helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.