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?