Latest Denodo community answered questions 2024-10-15T02:31:10Z 2024-10-15T02:31:10Z

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?

2024-10-15T02:31:10Z 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 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 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 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 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 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 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 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 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