Latest Activity

code

How can you access the Scheduler Log files without Client API?

We are interested in analyzing the Denodo Scheduler log data to monitor jobs, identify trends in errors/job failures, and to identify trends on when jobs are being run. From my research, it looks like the only documneted way to get this data with Denod...

code

What specific value is represented by @LAST_REFRESH_DATE

Hello there, we are trying to implement a generic incremental cache load where we only update rows, that have been changed since the last time the cach load job ran. But to evaluate, whether our method is valid, we need to know, which timestamp is exa...

code

Resource manager rule that blocks VDP admin tool access for some users.

Hi Team, Please suggest a Resource manager rule that blocks VDP admin tool access for some users. Tried with username and access interface but didn't work Thanks, Penchal

code

How to load the cache for specific views in a job?

Hi, I have scheduled a cache job in scheduler and there are around 50 views in that job. I have scheduled it for every 2 hrs. Now the thing is that every time I do not have to load cache for all the views instead I want to load the cache for some view...

code

Is it possible to have some ODBC connections use windows authentication and others use standard?

Using VDP 8.0.20210209 I have configured the system for LDAP and Kerberos. Once I check the box in the Database Management screen "User Kerberos/OAuth for ODBC..." I can no longer use standard authentication. All ODBC connections use the credentials of...

code

Condition statement examples for resource manager rule

CONDITION ''user_name=''testusr'" can we specify like this or only True or false to restrict only for a specific user. In

code

Same query, different results

I have a derived query that joins data from Teradata and AWS Athena sources. Both data sources are updated nightly. The derived view takes about 20minutes to complete. I noticed that the same query returned different results when executed back to back....

code

Denodo Equivalent for Oracle/SQL function "TRANSLATE"

We need to replace any found letters (abcdefg...ABDCDE...) with 9's. This is done in Oracle with TRANSLATE, how can we do this in Denodo: (TRANSLATE(( ENTRPT.F_LEADTIME_HIST.AVAILABILITY ),'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ;.- ','...

code

Please share how to export resource manager plans and rules in denodo 7

Please share how to export resource manager plans and rules in denodo 7 we didn't see this option in export or exprort database. Please suggest.

code

Difference between creating user using SHA512 and TRANSFER

Please share the difference between creating user using SHA512 and TRANSFER