You can translate the question and the replies:

Reading user details along with LDAP configuration for that user

Dear Team, I want to read the user details for the given username along with LDAP Configuration details from denodo using VQL command via JDBC request. DESC user <username> Results the following when we execute from VQL Shell user name: '<username>' description: '<username> - ldap admin user' admin: true LDAP Configuration: DataSource: <datasourcename> Login: CN=<XXX>,OU=<XXX>,OU=<XXX>,OU=<XXX>,OU=<XXX>,OU=<XXX>,DC=<XXX>,DC=<XXX> But when we execute same above VQL query via JDBC client or DBVisualizer using JDBC connection only the user name, description and admin details are returned. I don't find a way to read LDAP configuration details for the given user. Can you please help me how to read the values of LDAP configuration like DataSource and Login string values from Denodo using the JDBC client or query the complete user details result. Thank you
user
12-03-2020 12:13:38 -0400
code

1 Answer

Hi, I created a join over the following views to obtain all the information that is returned as an output of DESC USER <username> command through the VQL shell: 1. Base view created from query on JDBC data source connecting to Virtual DataPort Server using DESC DATASOURCE LDAP <ldap datasource name>. 2. Base view created from query on JDBC data source connecting to Virtual DataPort Server using DESC user <username>. 3. Derived view to filter user specific information created from base view on LDAP datasource which gets all users with details of the groups they belong to. You can choose to pass the username or any other parameter dynamically by using [Interpolation Variables](https://community.denodo.com/docs/html/browse/latest/vdp/vql/advanced_characteristics/execution_context_of_a_query_and_interpolation_strings/execution_context_of_a_query_and_interpolation_strings). Do check [DESC commands]( https://community.denodo.com/docs/html/browse/latest/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands) and [Using Create Base View From Query Option]( https://community.denodo.com/kb/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option?category=Data+Sources) to understand the options the Denodo provides you with to extract information from a data source. Hope this helps!
Denodo Team
16-03-2020 07:41:05 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here