Latest Activity


I need to force index in a integration view with out edit base view from query

Hi, can us help me with that? i want to know if is possible to "force use index" in a oracle sql db by a integration view. /+ INDEX(bd.table IDX_EXAMPLE) / Thanks,

Oracle SQL to VQL Converter INDEX Oracle


Querying a Denodo objects with mandatory search parameters via Oracle dB link

i can successfully query a denodo object from Oracle over database link via Oracle Database Gateway for ODBC only when the denodo object does not contain mandatory search parameters. For objects having mandatory search parameters, the query erorrs out...

Related to: Connecting to VDP using Oracle DB links

Oracle Mandatory Filter


Oracle SQL Developer Data Modeler to Denodo

Hi All I need to export a file from Oracle SQL Developer Data Modeler and import on Denodo VDP. Is this possible? And if it is possible how can i do it? It would be great help if some one could help us on this. Thanks

Oracle SQL


Error when trying access to Oracle Autonomous Database with Wallet

Hello, I tried to follow guide lines in this article to make a connection to an Oracle Database with wallet Test connection receives this error...

wallet tls1.2 Oracle


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

Date Conversion concatenate Oracle


Denodo cache got invalidated while having changes at the source level

Hi Support, I have noticed that, whenever I have any of the column/data type changes at source level of any of my developed(cached) views, My cached views got automatically invalidated? so the Question is, Is there any way to keep the cache db as it ...

cache oracle


Is it possible to connect to Oracle Stored Procedures?

Trying to create base view from an Oracle Stored Procedure... following message appears "Unsupported type PL/SQL RECORD type for database: Oracle Stored Procedures". Anyone has solved this?

Stored Procedure Oracle


Create Base View for Oracle Function that returns Table Type

I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...

VQL VQL Base view Custom Functions Stored Procedure Oracle


Query delegation

Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, T...

oracle query delegation denodo 7


Converting Oracle Functions to Denodo

Hello, I have an Oracle function that takes a few parameters and spits back out an output based on the logic inside the function. From what I can tell about Denodo, in order to be able to use this function, we would have to convert it to Java and then ...

custom policy oracle java