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

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.

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

Accepted answer

KranthiPakala-MSFT 46,592 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

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.
Please sign in to rate this answer.
MS Techie 2,706 Reputation points

2021-05-20T12:11:36.657+00:00

Hi @KranthiPakala-MSFT

Can we connect to other SQL data sources (not SSIS DB) using Managed Identity ?

Is there any sample ConnectionString value that shows how to enter Managed Identity under the "ConnectionManager" section of the "Execute SSIS Package" activity ?

Please help.

MS Techie 2,706 Reputation points

2021-05-20T18:25:04.973+00:00

Hi @KranthiPakala-MSFT

For my SSIS Packages , i have couple of Azure SQL PaaS databases , as the Data source.

I am using the package deployment option of deploying to Azure File Share (not deploying to SSISDB on Azure SQL ). So if i use Package deployment option , can i use Managed identity to connect from Azure SSIS IR to Azure SQL PaaS databases ?

KranthiPakala-MSFT 46,592 Reputation points Microsoft Employee

2021-05-27T21:17:11.237+00:00

Hi @MS Techie ,

Apologizes for the delay in my response. Please refer to below techcommunity articles published by ADF product team which also has a step by step demonstration video on setting connectionString values using Managed Identity under ConnectionManager.

https://techcommunity.microsoft.com/t5/sql-server-integration-services/blast-to-the-future-accelerating-legacy-ssis-migrations-into/ba-p/1792821

https://techcommunity.microsoft.com/t5/sql-server-integration-services/all-in-one-assessing-testing-and-migrating-ssis-packages-with/ba-p/2057563

Demo video - https://www.youtube.com/watch?v=m-d2q-DIncU

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.

KranthiPakala-MSFT 46,592 Reputation points Microsoft Employee

2021-06-01T17:32:46.077+00:00

Hi there,

Just checking to see if the above information was helpful? - Thank you
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

0 additional answers

Your answer