Latest Activity

code

Clickable link in the view description

Hello people, I have a question about the view description. Is it possible to add a clickable link into the description of a view? Or is there are another place in the view that I can add a link for an external page?

code

Base view from HTTP with headers but no payload/body

I have a JSON data source which first needs an authentication call (HTTP POST), that returns the session cookie to be used in consecutive (HTTP GET) calls. Unfortunately the first POST call doesn't return any HTTP body, so I can't create a base view. ...

code

Error Saving View When Joining to Same Table Multiple Times

I'm trying to create a derived view using the Denodo Design Studio web app. Let's say I have two views: DERIVED_VIEW and BASE_VIEW. These two views have a one-to-many relationship (DV-to-BV). I'm trying to create a new derived view which uses DV as the...

code

What is the internal_user in the last_user_modifier field in the predefined stored proc GET_VIEW()

From where is this USER being picked up to be added? It is NOT part of the Denodo id created under user Administration User Management in teh VDP/ Thanks. last_modification_date,name, type,last_user_modifier 2023-08-14 15:48:12-07:00 PayGradeByJobCod...

code

Table.UnpivotOtherColumns - Denodo Equivalent

Hello. Does Denodo have a function similar to the Table.UnpivotOtherColumns available in Power BI (https://learn.microsoft.com/en-us/powerquery-m/table-unpivotothercolumns)? Thank you.

code

Denodo scheduler Excel output file not adding new sheets to existing file

Hi Team I would like to create a job in which output data is stored in an excel file.I will be executing this job everyday.Instead of overwriting/creating new file, i want to add the output data to new sheets everyday.Appending file option will not wo...

code

Unable to create base view on top of JSON Datasource

Hi Team, I'm getting the below error while trying to create a base view on a JSON DS Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected character ('<' (code 60)): expected a valid value (JSON String, N...

code

how to get scheduler job results (complete or error) through curl command or shell script ?

how to get scheduler job results (complete or error) through curl command or shell script ? Please let me know just required either from curl command or shell script to get the results to compare in our shell scripting.

code

configure external metadata database to connect to read replica in cloudsql postgresql

We are having Denodo installed on GCP Linux servers, have configured external metadata database (CloudSQL PostgreSQL), everything works on the primary region. Now we are trying to build disaster recovery, created a read replica on CloudSQL PostgeSQL, W...

code

predefined procedure to access role management info

I am trying to find see if there is a predined procedure or any query to find the views assigned to a cloud role with privileges through Denodo Design Studio/Administration/Role Management. looking for below info: cloud role name, database name, datab...