Latest Activity

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

code

Remote table Vs Cache

What is the difference between remote table and cache

code

unable to connect local instance of denodo to azure analysis service

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

code

Problems in converting oracle math operation and the concatenation operator

Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...

code

Error in CASE Clause end as {name} in field expression

Dear support team, I have a problem in putting a specific column name in my case clause, below is the line I'm running in the field expression. When i set it to end as priority it shows that "Could't repair and continue parse" but when i set the it as...

code

Access to Oracle Redo Log files

Is it possible to access and read Oracle redo log files and Oracle archived redo log files from Denodo 8? Access can be done through Oracle LogMiner via the 'V$Logmnr_contents' view and then SQL, but I want to access the view directly via Denodo 8.