idea Re: Enhancement Qlik Replicate SQL authentication to Azure SQL DB server in Suggest an Idea

Enhancement Qlik Replicate SQL authentication to Azure SQL DB server

l9phan1 — Thu, 02 Jul 2020 17:05:59 GMT

Enhancement Qlik Replicate SQL authentication to Azure SQL DB server.

The Qlik Replicate connection to Azure SQL DB server is only accept username and password. There is no other option beside username and password.

Can you add on new feature to use Azure AD authentication, manage identity or key vault? Basically anything other than enter username/password combo.

Re: Enhancement Qlik Replicate SQL authentication to Azure SQL DB server - Status changed to: Open - Collecting Feedback

Ola_Mayer — Mon, 13 Jul 2020 12:36:46 GMT

Cam you check if you already connect with SSMS from on prem to the DB on Azure using AD?

If yes, can you please share with us the setting information and point us to the documentation you used?

Thank you in advance.

Re: Enhancement Qlik Replicate SQL authentication to Azure SQL DB server

rlisio — Tue, 17 Nov 2020 10:30:27 GMT

Hey Ola! This is when you use Microsoft Azure SQL DB as a TARGET.

The options you are given are only sql user id and password. As for SSMS I can connect through a Azure Active Directory by using AAD Universal with MFA.

Re: Enhancement Qlik Replicate SQL authentication to Azure SQL DB server - Status changed to: Delivered

Shelley_Brennan — Wed, 12 May 2021 13:46:49 GMT

The Azure SQL Database target now includes support for Azure AD authentication with the May 2021 release. Thank you!

Re: Enhancement Qlik Replicate SQL authentication to Azure SQL DB server

l9phan1 — Wed, 12 May 2021 14:12:12 GMT

THANK YOU !!!