Q&A

How can you access the Scheduler Log files without Client API?
answered 09-12-2021 07:09:31 -0500

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...

Answers: 1

scheduler log Scheduler Jobs Denodo Scheduler 7.0 DENODO LOGS

What specific value is represented by @LAST_REFRESH_DATE
answered 09-12-2021 02:08:14 -0500

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...

Answers: 1

Incremental Load LAST_REFRESH_DATE Denodo Scheduler 8.0 Cache Loading Cache Updating Cache

Resource manager rule that blocks VDP admin tool access for some users.
answered 08-12-2021 08:16:05 -0500

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

Answers: 5

resource manager rule block vdp admin tool access for user(s)

How to load the cache for specific views in a job?
answered 08-12-2021 08:02:41 -0500

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...

Answers: 1

Denodo Scheduler 8.0 Cache

Is it possible to have some ODBC connections use windows authentication and others use standard?
answered 08-12-2021 07:05:40 -0500

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...

Answers: 1

Kerberos ODBC

Condition statement examples for resource manager rule
answered 08-12-2021 05:36:14 -0500

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

Answers: 2

Resource manager Rule

Same query, different results
answered 07-12-2021 08:05:10 -0500

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....

Answers: 7

athena Teradata

Denodo Equivalent for Oracle/SQL function "TRANSLATE"
answered 07-12-2021 07:34:21 -0500

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;.- ','...

Answers: 2

Please share how to export resource manager plans and rules in denodo 7
answered 07-12-2021 03:42:10 -0500

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.

Answers: 1

export resource manager plans rules

Difference between creating user using SHA512 and TRANSFER
answered 06-12-2021 11:51:37 -0500

Please share the difference between creating user using SHA512 and TRANSFER

Answers: 2

create user transfer sha512