Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

VQL statement for Resource Manager rule or plan
answered 06-12-2021 11:40:51 -0500

Please share some examples/link related to VQL statement for creating resource manager rule/plan. Eg. RESOURCE MANAGER PLAN CREATE OR REPLACE RESOURCE_MANAGER PLAN "RMPLAN1" DESRIPTION = "TEST" CONDITION " " ACTION "" RESOURCE MANAGER RULE CREATE OR...

Answers: 2

Resource manager resource manager plan resource manager rule

configuration option not showing in design studio after updating to update 20210715,
answered 06-12-2021 07:26:22 -0500

we need to set time out value in design studio but after update configuration option not showing. after denodo update 20210715,

Answers: 1