Denodo community Q&A RSS feedLatest Denodo community answered questionsHow to Implement Dynamic Filtering in Denodo Views Based on Userâ??s Department - DENODO 92025-06-20T09:05:51Z2025-06-20T09:05:51ZHello,
I am looking to implement dynamic filtering in Denodo, where each user only sees data relevant to their own department. The goal is for the view to automatically filter data based on the department associated with the currently logged-in user.
Could you please advise how to link the user session to a department table or view, so that this filtering happens dynamically? If possible, I would really appreciate a small example or sample code to help illustrate this setup.
Thank you very much for your support!
Best regards2025-06-20T09:05:51ZWhich version of the Helm Charts belongs to Denodo 9.2.2? Where can I find that information?2025-06-17T07:18:07Z2025-06-17T07:18:07ZWe try to upgrade from 9.2.1 with charts 2.0.6 to 9.2.2 and charts 2.0.7. Latest greatest.
2.0.7 doesn't match with 9.2.2 because of a mount issue with custom-scripts in the SolutionManager.2025-06-17T07:18:07ZInformatica AXON to Denodo2025-06-13T10:04:54Z2025-06-13T10:04:54ZHi ,
Is it possible to connect Informatica AXON to Denodo and pull AXON database tables in
Denodo and create reports ?
I know it is possible other way around but can you guide me on the same.2025-06-13T10:04:54ZAI chatbot created in tutorial cannot access samples_bank database2025-06-13T08:21:47Z2025-06-13T08:21:47ZPlease help me about this problem.
https://community.denodo.com/tutorials/browse/chatbot/index#4
I have created an AI chatbot using the tutorial in the above link.
I have successfully connected to the LLM (gpt-4o), but when I try to access the Denodo data, it says "It seems that there are no tables available in your Denodo instance, or there might be an issue with the connection or permissions."
Since the database shows up in Web Design Studio and Virtual DataPort Administration Tool, I believe that the AI chatbot is not getting data from Denodo's servers for some reason.
I tried to solve this problem by using ChatGPT, but it seems to be difficult. By the way, I tried both methods with and without Docker, and the same phenomenon occurred in both cases.2025-06-13T08:21:47ZPulling data from excel source2025-06-13T08:07:53Z2025-06-13T08:07:53ZHi ,
How can we pull data from website in Denodo 8.0. Also what is file size limitation while pulling data from excel sheet source.
Thanks and Regards2025-06-13T08:07:53Z404 Error received and selecting Design Studio for any environment from SOlution Manager2025-06-12T21:45:09Z2025-06-12T21:45:09ZRecenly, I am getting a 404 Error when trying to open Design Studio or Scheduler for any environment from the Solution Manager welcome screen. These open fine when using the specific URL for these tools.2025-06-12T21:45:09ZMultivalued views parameter does not work on DB2 zOS2025-06-12T12:48:16Z2025-06-12T12:48:16ZI have created a deriver view with Multivalued parameter.
It does not run because it add acolumn null as param
in the select sent to the database.
It gives an error SQL Error [42703]: NULL IS NOT VALID IN THE CONTEXT WHERE IT IS USED. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.26.142025-06-12T12:48:16ZHow to get all dependent views in next layer2025-06-12T06:06:21Z2025-06-12T06:06:21Zhello team,
I would like to know if there is a stored procedure allowing me to get all dependent views in next layers.
How many views depend on such view or its particular columns?
For example, view_ 1 is a derived view and it has columns calling column _1, column _2, column_3...
view 2 and view_3 are derived integration views based on view_ 1 by using selection.
view_4 is the derived integration view based on view 2 by using selection.
If I change column name from column_ 1 to column 1_1 in view _1, view 2, view_3 and view_4 will all be affected.
How can I know all the dependencies of view_1 in this case so that I can know all views which will be affected before updating column_1 in view_1?
Thank you.2025-06-12T06:06:21ZData lineage not loading for few columns in Denodo View2025-06-10T11:48:27Z2025-06-10T11:48:27ZHi,
There is a view in which few columns are not loading in data lineage and it shows VDP tool not responding in a minute or so and it never shows the lineage, what can be done?2025-06-10T11:48:27ZColumns in a view2025-06-05T10:11:25Z2025-06-05T10:11:25ZHi ,
If my view has approximate 200 columns and has millions of rows as data ,how it will impact performance.2025-06-05T10:11:25Z