Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Denodo Scheduler - Passing Parameter values at run time
answered 10-02-2022 06:54:05 -0500

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

Answers: 5

Text Processing Function
answered 10-02-2022 06:38:25 -0500

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.

Answers: 1

Authentication with Azure APIM
answered 10-02-2022 06:31:49 -0500

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

Answers: 1

Subqueries in the WHERE Clause of the Query unable to find the table
answered 10-02-2022 05:59:27 -0500

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

Answers: 1

Subquery

How to include a subquery in the CASE clause of a field expression
answered 10-02-2022 01:27:40 -0500

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

Answers: 1

CASE Clause

Remote table Vs Cache
answered 09-02-2022 07:43:44 -0500

What is the difference between remote table and cache

Answers: 1

cache Remote table

unable to connect local instance of denodo to azure analysis service
answered 09-02-2022 06:35:33 -0500

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

Answers: 3

Problems in converting oracle math operation and the concatenation operator
answered 09-02-2022 04:57:35 -0500

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

Answers: 1

Date Conversion concatenate Oracle

Error in CASE Clause end as {name} in field expression
answered 08-02-2022 06:22:45 -0500

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

Answers: 1

CASE Clause

Access to Oracle Redo Log files
answered 08-02-2022 06:01:04 -0500

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.

Answers: 1

Redo log