Ability to create connection from OAC to Azure Data Synapse Connection via MFA User

Ashwik

When connecting to Synapse via OAC, the Synapse needs to be updated to pass MFA authentication through to Synapse as part of the connection process. Current Synapse environment and process does not allow local user to access.

While logging into OAC instance we can configure MFA Authentication where user gets authenticated and access the instance, while creating the connection user is been asked to provide username and password, once provided it is not able to connect to synapse even the same credentials were authenticated while accessing the instance.

This is causing issue while creating Synapse connection in OAC, as synapse only allow MFA user to access the data.