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

[esar]

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.

[onlyshiva]

Good Afternoon. Alteryx 2024.1 does not have the Microsoft Azure SQL Database --> Quick Connect. Can we get the steps for connection in this Latest version please?

[renat_isch]

Hi Onlyshiva, that's not exactly correct. The Alteryx Desiger 2024.1 build does have Azure SQL Database Quick connect option. If you don't see that option, please reach out to our customer support and they will assist you with finding it.