Q&A

How i can connect denodo db in java

I have a user who needs to install and run Denodo Express on MAC. He was told via the community to download and install the version without JRE included. He installed that version of Denodo Express but is getting an error when starting the vqlserver. ...

i recently testing the upgrade from vers 7.0 to vers 8.0 on linux centos 7 between import file process (vdp, data catalog, scheduler, scheduler index, ITPilot) , only scheduler and scheduler index got the warnings. i don't create any jobs on scheduler ...

We have to create extract from views into a file based on data columns. Parameterized query: Select * from <view> where creation_date >= '@PREV_RUN_DATE' I need to give the value of "@PREV_RUN_DATE" to the parameterized query at run time, li...

What would be the best way to put this function in Denodo as split_part isn't supported in Denodo? ltrim(split_part(split_part(unique_geo_id, '-', 1), ':', 1), 'T') Also, we need to ensure the translated code in Denodo gets delegated to Redshift.

Does anyone have a working example of authentication against Denodo using Basic Auth or Basic Auth with VDP using Azure APIM and Azure Policy? I am trying to send a basic auth header from Azure APIM against a known username that works, but I am finding...

Hello, I have added multiple tables in the view and joined all those tables. In the WHERE CONDITIONS, I have written something similar to this: A IN (select A from TABLEA where TABLEA.A=TABLEB.A ). It has been validated successfully, but when I want t...

Hi Denodo Team, Is there any function to add subquery in CASE clause of field expression? For example, case when Type like 'something' then 0 else (select a from table1 where table1.a=table2.a) end

What is the difference between remote table and cache

i have an azure account and i am trying to connect azure analysis service to denodo. it gives me a strange error: Unable to connect to the multidimensional server: unknown protocol: asazure I am able to connect my local SSMS and power bi to the azure ...