ODBC connection with AD

Hi, While configuring ODBC we have to give the user name and password. Is there any way to use Active Directory instead of user name and password. Best Regards,
30-07-2019 05:29:51 -0400

1 Answer

Hi, I was able to access the Virtual Dataport with ODBC using Microsoft Active Directory (AD). This can be achieved by configuring the Kerberos with single-sign-on (SSO) and pass-through session credentials. To configure SSO, I have followed the steps mentioned in the Knowledge Base article [How to set up SSO with pass-through for ODBC connections to Denodo](https://community.denodo.com/kb/view/document/How%20to%20set%20up%20SSO%20with%20pass-through%20for%20ODBC%20connections%20to%20Denodo?category=Northbound+Connections). Please note, to enable ODBC with Kerberos authentication in the Virtual Dataport, you should enable “ODBC/ADO.net authentication type” set to “Kerberos” in the Virtual Dataport database. For more information, you can refer to document [Configuring and Deleting Databases](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/configuring_and_deleting_databases) of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
30-07-2019 08:25:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here