Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Answers: 5

Query Full Cache WHERE CONDITIONS Cache

Select data from view using input variables
answered 18-10-2019 07:31:12 -0400

Hi, Is there a way to use something similar to pl/sql bind variables when selecting from a Denodo view that doesn't have parameters defined? I need to get the data based on an input variable that comes from the application. For example: select * from ...

Answers: 1

Which version of the Denodo Monitor matches the version of VDP Server 7.0 update 20190903?
answered 17-10-2019 07:05:58 -0400

The problem seems minor since monitoring appears to work fine despite the version discrepancy. Still... I stopped monitoring, I installed VDP Server upgrade, I extracted the supposedly new denodo-monitor package I started monitoring $ den...

Answers: 1

denodo monitor Denodo Monitor

Denodo Installation
answered 17-10-2019 07:02:27 -0400

After the installation of Denodo platform server, while starting the VDP server we are getting error Could you pleas help us Unexpected error. 2019-10-15 19:10:36,119 main ERROR An exception occurred processing Appender FILEOUT java.lang.NumberFormat...

Answers: 1

DENODO

Character MisMatch Error while using Coalesce function in Denodo
answered 17-10-2019 05:46:17 -0400

Team , We are using Coalesce function in Denodo which is equivalent of NVL in Oracle. Source Datatype for that particular column is NVARCHAR.We are able to see the data in Base views for these columns. However , While using Coaleasce function in deriv...

Answers: 1

executeVqlCommand(String databaseName, String command) doesn't take account of the databaseName.
answered 16-10-2019 13:48:51 -0400

I'm building a StoredProcedure to change the schemaName of all (Jdbc) baseView of a specified DataSource. I'm using the Denodo java extention. The StoreProcedure is in admin denodo database and i would be able to change the schema name of a baseview ...

Answers: 2

Denodo driver does not support datasource pooling
answered 16-10-2019 08:24:44 -0400

I am trying to connect to Denodo server using VDB JDBC driver. I want to access it through a WebSphere Application Server Application where I am trying to set a Pooled data source with following config: Implementation class: com.denodo.vdb.jdbcdriver....

Answers: 3

Driver JDBC

Denono automatic names for fields when importing base views
answered 16-10-2019 06:15:31 -0400

It seems like Denodo is changing the names when it creates a base-view, from the data source names. I just do not know where to read the rules from. Is there a way to make sure that field names will not be changed (exposed the way they are exposed byt...

Answers: 3

names baseview

Denodo 7.0 training is inaccessible ,getting Authorization error.
answered 15-10-2019 07:47:03 -0400

Hello Team, While doing training for Denodo 7.0 Interediate developer, Getting Auth Error in the Middle of training. Training Module: https://denodolearning.litmos.com/home/LearningPath/73474 Error Details: Application Not Authorized to Use CAS Th...

Answers: 1

How to use a base view as a data source ?
answered 15-10-2019 07:19:13 -0400

Hi, I'm currently having 3 views in oracle and i have created a base view in denodo for each of these Oracle views. On Oracle views are running different reports and i have to run these queries on the base views. Now the question is, how i can use t...

Answers: 3

data source base view integration view oracle