https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000KiVfhIAF&title=Limitations+in+Roles%2C+Users+and+Global+Security+Policies Hi I not sure if its a limitation. However what i noticed was there would be a conflict when assigning privileges to both Roles and User. So for instance if you assign the user CONNECT, CREATE AND EXECUTE privileges to a particular database and I assign the user to a role with the same privileges, regardless how you alter the Global Security Policies, it would not work (e.g. masking confidential tagged columns). On the other hand, if i only assign privileges to the ROLE / USER only, and create my Global Security Policies accordingly, it would work. Is this a limitation in the Role User Management? Tue, 15 Oct 2024 02:31:10 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KiVfhIAF&title=Limitations+in+Roles%2C+Users+and+Global+Security+Policies 2024-10-15T02:31:10Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KefybIAB&title=How+can+I+get+the+users+of+my+Denodo+instance+via+API 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. Mon, 14 Oct 2024 02:18:03 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KefybIAB&title=How+can+I+get+the+users+of+my+Denodo+instance+via+API 2024-10-14T02:18:03Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KOtcXIAT&title=Using+URL%27s+to+HTML+pages+in+a+Link+as+part+of+Description 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? Wed, 09 Oct 2024 06:30:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KOtcXIAT&title=Using+URL%27s+to+HTML+pages+in+a+Link+as+part+of+Description 2024-10-09T06:30:44Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KOpFZIA1&title=Stored+Procedure+Issue 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'; Wed, 09 Oct 2024 05:41:58 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KOpFZIA1&title=Stored+Procedure+Issue 2024-10-09T05:41:58Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KLcl9IAD&title=Check+base+view+is+not+empty+before+integration+view 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". Tue, 08 Oct 2024 13:50:14 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KLcl9IAD&title=Check+base+view+is+not+empty+before+integration+view 2024-10-08T13:50:14Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KJ4lyIAD&title=Does+Denodo+support+older+legacy+DB2+5.4+connectivity Want to know if Denodo supports DB2 V5.4 on AS/400? Thank you! Mon, 07 Oct 2024 20:08:54 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KJ4lyIAD&title=Does+Denodo+support+older+legacy+DB2+5.4+connectivity 2024-10-07T20:08:54Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KGmpyIAD&title=My+Denodo+Essentials+assessment+is+failed 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 Mon, 07 Oct 2024 10:38:38 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KGmpyIAD&title=My+Denodo+Essentials+assessment+is+failed 2024-10-07T10:38:38Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KDFwzIAH&title=Developing+a+Custom+Policy 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. Sat, 05 Oct 2024 12:09:32 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KDFwzIAH&title=Developing+a+Custom+Policy 2024-10-05T12:09:32Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KC9QbIAL&title=Hashbytes+in+denodo 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. Fri, 04 Oct 2024 22:11:18 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KC9QbIAL&title=Hashbytes+in+denodo 2024-10-04T22:11:18Z https://community.denodo.com/answers/question/details?questionId=906Qj00000K6VP0IAN&title=Need+the+denodo-v80-update-20240926+compatibility+matrix+with+Power+Bi%2C+Alteryx%2C+Tableau Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau Thu, 03 Oct 2024 13:16:46 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000K6VP0IAN&title=Need+the+denodo-v80-update-20240926+compatibility+matrix+with+Power+Bi%2C+Alteryx%2C+Tableau 2024-10-03T13:16:46Z