Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

Wim
Contributor III
Contributor III

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

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...

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.

4 Comments
Nulee_Massaro
Employee
Employee

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

Status changed to: Open - On Roadmap
dtlamontmh
Partner - Contributor
Partner - Contributor

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.

Meghann_MacDonald

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived