Add Active Directory support for Microsoft Synapse Analytics
We would like support added for Active Directory when creating a connection in Qlik Compose for Microsoft Synapse Analytics. Currently, there is only the option for USERNAME and PASSWORD.
The Benefit for this would be that the account management can stay with Active Directory and the database account creation would no longer be necessary.
This option exists for the other Microsoft SQL Server options.
There is an option to specify your own connection string for both JDBC and ODBC. Did you try to use that option to set active directory authentication? I believe that should be possible regardless of when we add this to the UI.
Ditto for Snowflake with Active Directory (AD). User & password does not work as that is not a federated access method. Snowflake drivers do support JWT through Okta but not AD. Other applications I have seen provide AD support through OAuth 2.0 - and that has to be implemented through application integration. We also verified that manually setting up key pair authentication works for a short time with SF/AD - the trouble is a new token is generated every ~10 minutes, and therefore OAuth is required to keep alive the session to receive the updated tokens.
This is not planned for Azure Synapse as a specific feature, but should be able to be supported as active directory w/ password via the Additional ODBC properties.
