You can translate the question and the replies:

Pass-through security for SQL Server data sources

Currently we are using LDAP and Active Directory to allow users to authenticate to data sources in Denodo. We would like the capability to ignore this and use pass-through authentication, based on SQL Server permissions. In other words, if a user has Windows authentication to a given SQL Server / database, we'd like them to be able to connect to a corresponding data source in Denodo, regardless of if a user would be able to authenticate through LDAP. We thought this might be accomplished by simply choosing "Use Pass-through session credentials" under Authentication in a data source configuration, and that does work for individuals who are able to query via tools such as VDP Administration Tool or DB Visualizer. However, we need reporting tools such as Power BI and Alteryx Designer to be able to connect to these data sources via pass-through. All such tools fail to connect. Note that users are connecting to Denodo using ODBC driver v7. Is this possible?
Active Directory Denodo_SQL_Server SQL Server pass-through
user
18-12-2019 10:44:07 -0500
code

1 Answer

Hi, It is currently possible to configure SSO for ODBC connections to Virtual DataPort through Kerberos authentication with LDAP. I do this when I do not want to provide credentials for the DSNs connecting to Virtual DataPort. To set up Kerberos authentication, I follow the steps outlined in the below documentation: * [Setting-up Kerberos Authentication](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/postinstallation_tasks_in_virtual_dataport/setting-up_kerberos_authentication) in the Denodo Platform Installation Guide * [Setting-Up the Kerberos Authentication in the Virtual DataPort Server](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/kerberos_authentication/setting-up_the_kerberos_authentication_in_the_virtual_dataport_server) in the Virtual DataPort Administration Guide * [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) Knowledge Base article You can take a look at the [Denodo Power BI Custom Connector](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Power%20BI%20Custom%20Connector%20-%20User%20Manual) User Manual which explains how to connect to Virtual DataPort from Power BI using Windows authentication. Hope this helps!
Denodo Team
18-12-2019 17:13:58 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here