Latest Activity

code

List Database Folders

Hi, is there a way to list the denodo folders for a particular denodo database via VQL? so for example: sandbox (database) - 0. Raw Data (folder) - 1. Interfaces (folder) - 2. Derived Views (folder) - 3. Final Views (folder) So i want to be able t...

code

API error - 429

Hi Team, I am connecting to an API and started getting error 429 - too many requests. Is there a way where in i can put a wait before the next request? Or any other recommendations? Thanks!

code

Posting data to materialized view via Denodo web service

Hi, We're using a separate software to route messages between a Denodo webservice and an external webservice. What is the best option to store the replies from the external webservice? It could be both error messages and data. I tested using a separate...

code

Corresponding function Denodo to ORA_HASH in Oracle

Can you help me with corresponding function to ORA_HASH function in oracle. we're using Denodo 7.0

code

scheduler load process report

Hi Team, how denodo stores scheduler load process reports for cache jobs. how can we bring that in to denodo vdp. Thanks.

code

Date format

Hello Team, I have a request to expose a date for a client to this formt "yyy-MM-ddT00:00:00.000Z" the OriginalDate is like "2022-02-08T00:00:00" i used the following function but in the result the 'Z' doesn't appear: formatdate('yyyy-MM-dd''T''HH:m...

code

add view to default role

Hi Team, If I create a new view, how can I automatically add it to allusers role in Denodo. Thanks.

code

fetch cache details.

Hi Team, I need to build views in Denodo, which could fetch below information: when was the view last refreshed how many records got loaded please suggest what tables from cache DB can be utilized . Thanks.

code

identify views in scheduler jobs

Hi Team, If we have multiple jobs in denodo scheduler, than how to find which view can be in which job ? Thanks.

code

Denodo connection in selenium

How i can connect denodo in selenium end execute queries.