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

MS Techie 2,671 Reputation points
2021-05-19T11:46:32.943+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,048 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,402 Reputation points Microsoft Employee
    2021-05-19T23:49:42.42+00:00

    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

    98043-image.png

    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:

    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.


0 additional answers

Sort by: Most helpful