finos / legend

The Legend project
https://legend.finos.org
Apache License 2.0
864 stars 188 forks source link

Add Windows Authentication for SQL Server #833

Open reyes-michael opened 2 weeks ago

reyes-michael commented 2 weeks ago

Feature Request

Add Windows Authentication for SQL Server RelationDatabaseConnection

Description of Problem:

Currently, you can only use Username and Password References in the Credential Vault for Microsoft SQL Server. While this works, organizations handle authentications using Windows Authentication (Active Directory (AD) authentication).

Potential Solutions:

I don't have a full understanding of how those credentials flow across from the Windows Session to how Legend Studio sends the information to the SQL Server. If this is possible it could be a win for organizations that use SQL Server allowing them to authenticate on the SQL Server without the need of username and password.