Latest Activity

code

Rank over a union view

Hi, we are using denodo version 8 and have been trying to implement the rank function. The delegate analytical function has been specified on the datsource. We are facing the below issue. 1.We have two seperate views which we union. 2.The unioned view ...

code

Isnull

How to use isnull in denodo? provide the solution with example

code

Connect of ADLSv2 with Dendod Docker Container. Error while creating the Base View.

Hi Team, I have tried placing the core-site.xml inside the denodo docker container which is running on a Azure VM. I have established a connection between ADLSv2 container with denodo docker container. When I try to test connection the connection is ...

code

Lag() function used together with Group By

Hi, we are currently running VDP 7 20210818. The query can be delegated to an SQL Server. I try to use the Lag() function in a Group by VQL clause. Select lag(a.activity_id) over (partition by a.patient_id order by max(a.startdatetime)) as prev_activ...

code

VQL Display rows

denodo 8: VQL Option Display rows: seems to be that the max value there is 1000. is it possible to force to display all rows (enabling also retrieve all rows)?

code

SQLAlchemy Denodo Connection Issues

Hi there, I am trying to use sqlalchemy with denodo but I am running into a few issues. I have the dialect added as per the instructions from your sqlalchemy dialects page, and I can parse the connection string it seems. However, whenever I create a c...

code

JSON datasource - HTTP POST - ARRAY request and response FLATTEN

HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...

code

Denodo Usage metrics

Total Number of Users on platform Total number of objects created on daily basis How do I query and get the above information using catalog queries? Thanks

code

Has anyone successfully implemented HP Voltage custom decryption function?

We are unning into problems while loading native libraries and JARs. logger.debug("VOLT: build context - policyUrl: " + policyUrl); logger.debug("VOLT: build context - trustStoreDir: " + trustStoreDirectory); logger.debug("VOLT: build context - vibeS...

code

Solution manager account

Do we have to use admin account to login to solution manager,? is there a role or something similar to grant to indivisual id, so indivisual can login with his credentials. we dont want to use admin account to login to solution manager