idea Re: Add Active Directory support for Microsoft Synapse Analytics - Status changed to: Closed - Declined in Suggest an Idea

Re: Add Active Directory support for Microsoft Synapse Analytics - Status changed to: Open - Collecting Feedback

Tzachi_Nissim — Wed, 25 Nov 2020 08:16:20 GMT

Hi ShireyJW,

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.

Regards,

Tzachi

Re: Add Active Directory support for Microsoft Synapse Analytics

DWH2Go — Fri, 18 Dec 2020 19:30:21 GMT

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.

Re: Add Active Directory support for Microsoft Synapse Analytics - Status changed to: Open - Not Planned

TimGarrod — Wed, 29 Mar 2023 21:09:06 GMT

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.

Re: Add Active Directory support for Microsoft Synapse Analytics - Status changed to: Closed - Declined

TimGarrod — Wed, 29 Mar 2023 21:09:19 GMT