Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions Using URL's to HTML pages in a Link as part of Description 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 Stored Procedure Issue 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 Check base view is not empty before integration view 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 Does Denodo support older legacy DB2 5.4 connectivity 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 My Denodo Essentials assessment is failed 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 Developing a Custom Policy 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 Hashbytes in denodo 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 Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau 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 Re-register for expired course https://community.denodo.com/answers/question/details?questionId=906Qj00000K1S6nIAF&title=Re-register+for+expired+course 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 Wed, 02 Oct 2024 08:17:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000K1S6nIAF&title=Re-register+for+expired+course 2024-10-02T08:17:05Z can i install denodo with postgresql version 16 https://community.denodo.com/answers/question/details?questionId=906Qj00000JwxftIAB&title=can+i+install+denodo+with+postgresql+version+16 can you confirm that i can install denodo entreprise 8 associated witt a postgres sql v 16 I cannot find a compatibility matrix with such detail thanks Tue, 01 Oct 2024 08:21:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JwxftIAB&title=can+i+install+denodo+with+postgresql+version+16 2024-10-01T08:21:44Z