idea Re: Extending Azure AD support for Azure SQL DB and Azure Synapse - service principal - Status changed to: Closed - Archived in Suggest an Idea

Extending Azure AD support for Azure SQL DB and Azure Synapse - service principal

Wim — Mon, 30 Jan 2023 11:58:12 GMT

This is an extension of what was already requested by another user here:

https://community.qlik.com/t5/Suggest-an-Idea/Enhancement-Qlik-Replicate-SQL-authentication-to-Azure-SQL-DB/idi-p/1724596

Based on this ideation Azure AD support was added for SQL DB, but only with user/password authentication.

Our security standards require AAD authentication using service principal, which is not supported for the SQL DB connector, and only supported for the staging store for the Synapse connector and not the Synapse connection itself.

Also we would like to take it another step further and support the retrieval of the secret from an Azure Keyvault, instead of hardcoding it in the connectors configuration.

Re: Extending Azure AD support for Azure SQL DB and Azure Synapse - service principal - Status changed to: Open - On Roadmap

Nulee_Massaro — Tue, 28 Feb 2023 19:19:05 GMT

Thank you for your suggestion. We have added this to our roadmap!

Re: Extending Azure AD support for Azure SQL DB and Azure Synapse - service principal

dtlamontmh — Wed, 01 Mar 2023 11:48:07 GMT

It would be great if the Azure SQL Database connector could support all of the six different Authentication options that are available in Microsoft SQL Server Management Studio. Our customer has Qlik Sense Enterprise installed in an Azure server and we have been trying unsuccessfully to connect to an Azure SQL DB that is on another Azure server. Whilst we have connected using three of the Microsoft SQL Server Management Studio Authentication options, the Qlik Azure SQL Database connector still won't connect.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:29:50 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Extending Azure AD support for Azure SQL DB and Azure Synapse - service principal - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:29:52 GMT