Denodo community Q&A RSS feed Latest Denodo community answered questions How can I get the users of my Denodo instance via API 2024-10-14T02:18:03Z 2024-10-14T02:18:03Z Hi, so I have loaded up an instance of Denodo, which currently runs on a VM on my machine. When I log in to Denodo Design Studio, I see the vql shell that's open by default, and set to the **admin** Database. I input "list users" and hit execute and get back my users of denodo, which is what I see when I go to Administration > User Management I see the same users. I don't have any views or external sources linked to this denodo instance at this point, I just strictly need to be able to retrieve my denodo user info. 2024-10-14T02:18:03Z Using URL's to HTML pages in a Link as part of Description 2024-10-09T06:30:44Z 2024-10-09T06:30:44Z I want to introduce links to Web-pages, for example Visio, as a part of the documentation of our solution. For example a Datamodel drawn i Visio. But when I save the Link object i the Description it just convert to a non clickable normal text. Is it possible to include Links to Web-pages in the Cataloge? 2024-10-09T06:30:44Z Stored Procedure Issue 2024-10-09T05:41:58Z 2024-10-09T05:41:58Z So you know how when you want to insert variable in python is f"{variable_name}" For denodo I am unable to do so for the execute statement in custom stored procedures For instance the execute statements below would not work. What is the proper way of formatting it? * execute_statement := 'ALTER USER ' || user_name || 'GRANT METADATA, EXECUTE ON ' || affected_element; EXECUTE "execute_statement"; * execute_statement := 'ALTER USER ' || user_name || 'GRANT METADATA, EXECUTE ON ' || affected_element; EXECUTE (execute_statement); //Normal SQL way * EXECUTE 'ALTER USER ' || user_name || 'GRANT METADATA, EXECUTE ON ' || affected_element; * EXECUTE 'ALTER USER "user_name" GRANT METADATA, EXECUTE ON "affected_element" '; * EXECUTE 'ALTER USER user_name GRANT METADATA, EXECUTE ON affected_element'; 2024-10-09T05:41:58Z Check base view is not empty before integration view 2024-10-08T13:50:14Z 2024-10-08T13:50:14Z I have a json files for each sample in a folder. Each json reports results but sometimes these files exist but are empty (no results). From this json, creating data source and base view is not an issue, but when you want to perform some integrations, I got errors. I would like to check that a bv is not empty before running the iv command but I am unable to find a proper way to do this. In case is empty I would like to return a similar structure but with dummy values. Now these could be "field1,field2,field3". 2024-10-08T13:50:14Z Does Denodo support older legacy DB2 5.4 connectivity 2024-10-07T20:08:54Z 2024-10-07T20:08:54Z Want to know if Denodo supports DB2 V5.4 on AS/400? Thank you! 2024-10-07T20:08:54Z My Denodo Essentials assessment is failed 2024-10-07T10:38:38Z 2024-10-07T10:38:38Z Hi Denodo team, I have complted course of Denodo Essentials but I am failed in test so I need to reapprear for same course once again and pass the test so that I can apperar for remaining Denodo training. Please provide me solution for this issue. Thanks & Regards Vikas Thombre 2024-10-07T10:38:38Z Developing a Custom Policy 2024-10-05T12:09:32Z 2024-10-05T12:09:32Z I would like to ask which version started supporting the "Developing a Custom Policy" feature. Additionally, is there a way to apply a Custom Policy to every view by default? Thanks. 2024-10-05T12:09:32Z Hashbytes in denodo 2024-10-04T22:11:18Z 2024-10-04T22:11:18Z what is the equivallent of sql function HASHBYTES in denodo? cast(HASHBYTES('', 222) AS INT) i tried using hash function which gives me string values but i need numeric values. quick help will be appreciated. 2024-10-04T22:11:18Z Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau 2024-10-03T13:16:46Z 2024-10-03T13:16:46Z Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau 2024-10-03T13:16:46Z Re-register for expired course 2024-10-02T08:17:05Z 2024-10-02T08:17:05Z Hi. I am trying to access this course https://community.denodo.com/training/course/8.0/Advanced%20Configuration%20of%20Denodo%20View. The course has expired however I wish to re-register. The option is not available to re-register for this course, only a link to Launch Course in LMS which does not work as it has expired. Please could you help? Thanks, Gareth 2024-10-02T08:17:05Z