Support for [Azure Data Factory SSIS IR]

[nitin-natu]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

Hello Azure Terraform Community Team ,
we are working on enterprise level SSIS Integration runtime set ups in Azure Data factory.

We are creating SSIS Integration runtime IaaC templates using Terraform.
SSIS Integration runtime needs Catalog Database Server endpoint which can be configured to access via SQL Login as well AAD Authentication with MSI.

What we found is Terraform template for Azure Data factory with SSIS Integration runtime dont support Catalog DB access via MSI.

PFB Ref from Azure Portal for SSIS Integration runtime , where provision is given to use MSI access for Catalog endpoint which is not supported
by Terraform template.(its only supporting SQL login)

https://www.terraform.io/docs/providers/azurerm/r/data_factory_integration_runtime_managed.html

We follow best security practices in our organization to use MSI Access for Azure SQL connections we dont use SQL auth which is having passwords to maintain/rotate and which are potential risk for compromise.

We need your help to support and expedite MSI Enabled Catalog DB access configuration in Terraform ADF SSIS Integration runtime template, as we are having planned prod deployments by Dec 2020.

New or Affected Resource(s)

azurerm_data_factory_integration_runtime_managed

Potential Terraform Configuration

# Copy-paste your Terraform configurations here - for large Terraform configs,
# please use a service like Dropbox and share a link to the ZIP file. For
# security, you can also encrypt the files using our GPG public key.

References

[ghost]

This has been released in version 2.49.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.49.0"
}
# ... other configuration ...

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!