Q&A

Alert Configure after Detect Changes in Data Source (Oracle DB)
answered 18-10-2019 08:06:33 -0400

Hi team, I already knew that we can detect changes in data sources as shown in the following help page. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources After detecting the changes...

Answers: 4

alert SOURCE_CHANGES() datasource

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