Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Connect Azure SQL Database with Azure AD AAD interactive, Multi-Factor Authentication MFA

Connect to Azure SQL Database with Azure AD also with Multi-Factor Authentication is a crucial feature nowadays. The tool should be configurable by interface tools so we can change the database within the same Azure Database server.

 

There is a workaround to use ODBC for this but it does not support caching credentials and that's why problematic to use. The credential prompt is appearing every time we run the workflow. With ODBC it's also required to have a separate DSN for every database in the same server.

 

To make it easy for users there should be a native connector for this feature. The user experience should be easy as it's in an azure data lake connector.

 

 

6 Comments
KylieF
Alteryx Community Team
Alteryx Community Team

Thank you for the idea and feedback!

 

Our data connectors and IN-DB team always appreciate all the feedback they get on what data sources are the most helpful and how user would like to see them behave. I noticed you're new to the idea boards (welcome!) so if you haven't yet be sure to check out our Submission Guidelines as it included information on the process after an idea has been posted.

machag
5 - Atom

Currently , We are trying to complete a POC with Azure Synapse SQL pool . Same issue with the ODBC 17 driver

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
renat_isch
Alteryx
Alteryx

Hello, everyone, this idea has been implemented and released as part of 23.2 release. The MFA is now completely handled by Alteryx Designer and all credentials are "cached", stored, in DCM. 

VojtechT
Alteryx
Alteryx
Status changed to: Implemented