Latest Activity

code

DATA not matching with redshift source table and Denodo base view

Hi Team, DATA type is differrent than source table column which is created from redshift spectrum table. in source it is float but in denodo it is round off. source value: 12.85,20.11 Denodo: 12,20

code

Power BI dashboard report with Dax queries are performing slow on Denodo

I am having slow performance issue in Power BI dashboard built on top of denodo. Denodo is on top of HANA. Trying to figure out where it went wrong. One of the PBI dashboard built on top of Denodo is taking 16 sec to show the data. There are 20+ que...

code

Denodo connect

How i can connect denodo db in java

code

vqlserver for Denodo Express on MAC not starting

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. ...

code

scheduler and scheduler index import problem

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 ...

code

Denodo Scheduler - Passing Parameter values at run time

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...

code

Text Processing Function

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.

code

Authentication with Azure APIM

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...

code

Subqueries in the WHERE Clause of the Query unable to find the table

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...

code

How to include a subquery in the CASE clause of a field expression

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