Denodo community Q&A RSS feedLatest Denodo community answered questionsXML DATASOURCE2025-07-02T10:45:40Z2025-07-02T10:45:40ZHi,
I would like to create a XML datasource that has a XLS extension. The file is located in a SFTP route. How can I create the datasource and the base view ?
Best regards,
Olga2025-07-02T10:45:40ZDate Format-Arabic calendar2025-06-30T13:05:57Z2025-06-30T13:05:57ZHi Team ,
My Oracle source table has date format like this 31-DEC-22 ,when I bring this value to Denodo it gets converted into timestamp ,I converted this to date format like 2022-12-31.
Now when I am trying to put filter condition like below
UPPER(formatdate('dd-MMM-yy',to_localdate('yyyy-MM-dd','2022-12-31')))
it doesn't work because above expression gets converted into Arabic calendar like 31-12-' some Arabic word' and condition gets failed.
Could you please provide syntax on how to convert date 2022-12-31 into 31-DEC-22 so that it doesn't fail in Denodo (I know that above syntax will work but since my server is in middle east region so locale is getting converted into 31-12-' some Arabic word' ) any suggestions for the same would be appreciated.2025-06-30T13:05:57ZDenodo Storage Costs2025-06-30T11:11:54Z2025-06-30T11:11:54ZHello, what are the storage costs of Denodo? Does anyone have an idea how it works? Thanks.2025-06-30T11:11:54ZHow 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:51ZHow to Create User-Based Dynamic Views in Denodo Based on Department in DENODO 92025-06-20T09:00:03Z2025-06-20T09:00:03ZHello,
I would like to create dynamic views in Denodo where each user only sees the data related to their department. The idea is that, upon logging in, a user should automatically be restricted to the data of their respective department.
Could you please advise how to link the current user session to a department table or view, so that I can filter the data accordingly? If possible, I would also appreciate a small example or sample code demonstrating this setup.
Thank you very much in advance for your help!
Best regards2025-06-20T09:00:03ZWhich 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:09Z