Q&A

Getting Year Value : 1 through getyear function for date field in HANA where the date field is null.
answered 13-12-2021 08:03:20 -0500

We created a denodo view on top of HANA view where we tried to use getyear function for a date field. That field is also getting null values and also date values. For date values the year is properly displayed but for date values which are null it is d...

Answers: 1

getyear null values for dates

OAuth2 in RESTful services
answered 13-12-2021 08:00:20 -0500

Is OAuth2 authentication supported for RESTful services as like its available for GraphQL? We have some extened querying requirements which GraphQL (for which we use OAuth2) doesn't seem to support. But RESTful services as per documentation support on...

Answers: 1

Denodo RESTful Webservice
answered 13-12-2021 07:43:01 -0500

With respect to Denodo RESTful Webservice, which of the following is the appropriate URL to delete a customer record (of cust_id=100) from a customer view, assuming that the primary key of the view is cust_id? http://localhost:9090/denodo-restfulws...

Answers: 1

Impersonation on RESTful and GraphQL services.
answered 13-12-2021 06:13:36 -0500

We are invoking the APIs using service account from an application but need to execute the query in Denodo as the user connecting to the calling application. Can this be achieved for RESTful and GraphQL services? Impesonation only seems to be support...

Answers: 1

Improper import and element showing in VDP
answered 13-12-2021 01:32:11 -0500

Hi Team, I am facing a weird issue in denodo 8 VDP. so i have 1 derived where i am doing joins . In that join i am joing base table A with table B and table C. Now i modified the derived view vql and replaced the table B with D and table C with E na...

Answers: 1

import missing element

long field. division
answered 10-12-2021 07:22:39 -0500

Hi Team I have a column of type 'long'. values like 20, 15, 133, 100. I have to create a new column using it which must have values like .20, .15, 1.33, 1.00 so something like long field/100. How do I do that. ? for me 'long field'/100 is returning ...

Answers: 1

long

Is there a way to enable non admins to assign roles to users and other roles ?
answered 10-12-2021 06:16:24 -0500

Is there a way to allow users in non admin role to assign roles? They are able to create new users and roles, assign privileges but not able to assign roles and also not able to export vql with user privileges. They are admin on all databases and are a...

Answers: 1

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)