Latest Activity

code

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

code

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

code

Error while inserting data with bulk load activated on Oracle Data source

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have an Oracle instance running on the same computer. I run catldr.sql as sysdba on the Oracle database. I created a data source (dstrcr) and activated "Use Bulk D...

Bulk Data Load Oracle

code

oracle "date" column convert to "timestamp" column in Denodo

Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...

date oracle timestamp

code

Fail to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM.

Hello, I try to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM. A screenhot is joined for illustrate, the error message is (ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )...

DQVM Oracle

code

Data type mapping

Hi, Happy New Year I have been asked to produce a data type mapping from Oracle to Denodo. I can't figure out what happens, for instance to integers: In Oracle an integer would be a Number(38), so -999..(38 9s) to 999... In Denodo the Int data type h...

oracle datatype

code

Interpolation of function and variable.

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Function Interpolation Variables oracle

code

How to change database schema of Oracle base views

Hi, in our development system (denodo 6.0, latest update) we frequently want to change the database schema of many existing base views belonging to the same Oracle data source. The problem is that the schema name is included in every JDBC wrapper, fo...

Denodo 6.0 JDBC oracle wrapper

code

How can I create an Oracle DB Link to Denodo?

Dear Denodo, How can I create an Oracle DB Link to Denodo? I see in the Denodo 5.5 Update 20150319 VDP Release notes that you fixed bug #20859. I didn't even know that we could create an Oracle DB link into Denodo. How do I create this DB link from...

oracle

code

Slow performance when joining tables from oracle database

Two issues related to vql performance. I am connecting to a oracle 12c database and trying to query a record from huge table. Denodo is not returning records . I am testing joining two oracle tables using the base views . The performance of the query ...

oracle Sql performance