search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.11k stars 4.12k forks source link

MSSQL Domain Credential #5300

Open marrocksd opened 3 years ago

marrocksd commented 3 years ago

Tell us about the problem you're trying to solve

Hi all, it seems that the SQL connection only accept Basic Authentication (Username/password). I would be great if we can login using Windows Credential/Domain Credential because they are quite common for MSSQL users. Or if you already have support for that, please tell me how. Thank you all for such a great product.

Describe the solution you’d like

I think we might need the jtds driver for that.

Describe the alternative you’ve considered or used

Example using Datagrip image image

grishick commented 2 years ago

Tagging this for DB & DW sources team for now. Once we finish the implementation for the MS SQL Source, please file an issue for MS SQL destination

danieljaniga commented 1 year ago

@marrocksd Iam using following JDBC URL Params for setting custom domain: integratedSecurity=true&authenticationScheme=NTLM&domain=yourdomain

prateekmukhedkar commented 11 months ago

@marrocksd does setting the JDBC url parameters work for you? Thanks @danieljaniga for your help!