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

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

Build POC (proof of concept)
answered 14-02-2019 13:39:40 -0500

Good morning, SCAI Finance is a Denodo partner. We need to build a simple proof of concept (POC) that does the following: through an operator interface (which is the subject of my request) I would like to see a report I built with Denodo (the data mode...

Answers: 1

POC

Query to get the execution as output
answered 14-02-2019 12:56:21 -0500

Select * from view_name trace is giving me the query output which is the view data but I’m unable to get the execution trace as data. Please hlp me to get the execution trace or EXECUTION PLAN() as output so that I can redirect the same to a file for f...

Answers: 1

limit the tables involved in the select query
answered 14-02-2019 06:57:54 -0500

In a normal scenario for a data model, I think a query should only bring the tables(in JOINS) that are involved in the select query. However in Denodo, the select query is brining in all the tables involved in the model(the model is created based on 10...

Answers: 1

Slf4j dependency conflict changing to "Insufficient resources to execute operation" when trying to connect Dremio as a JDBC datasource
answered 13-02-2019 08:21:43 -0500

Hi, I'm currently running Denodo Platform v7.0 on Windows. I'm attempting to connect Dremio as a JDBC datasource and running into errors when testing the connection. I have added the Dremio JDBC driver .jar file to a new directory in the {DENODO HOME...

Answers: 2

JDBC JDBC Data Sources

Decode oracle function in denodo
answered 13-02-2019 03:17:16 -0500

Hi How i am supose to implement following function in denodo DECODE (B.Blue,'1', 'Test' ,'2' ,'Test2' ,B.Blue)||' - '||B.Red ``

Answers: 1

JDBC: How to find the description of a user within java program
answered 13-02-2019 03:07:14 -0500

Hi, Denodo Version 6 From within java program, using JDBC connection to Denodo, is there any way to find the description of a user that is available from the "desc user" VDP command? Regards, Subrata

Answers: 1

jdbc desc user

Java Heap space error while running query
answered 13-02-2019 00:07:14 -0500

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Answers: 1

Base view java Select Query 'Java heap space'

solution manager question
answered 12-02-2019 18:16:43 -0500

When i create a revision from development environment. by dbname is db1_dev. But when i want to promot it to sit environment . it should be db1_sit. where can i change it? i am using solution manager for deployments.

Answers: 1

#Deployments

Issue with SSL
answered 12-02-2019 10:24:23 -0500

Hi Denod Team, We are facing issues when we try connecting denodo as data source in OBIEE RPD. Issue with SSL enabled Denodo server. 1. We have denodo on machine A which is Windows server. We have enable SSL. 2. We are trying to connect Denodo D...

Answers: 2

Connection timed out (Write failed) - How to keep connection open?
answered 12-02-2019 04:55:55 -0500

Hi, We have a schedulaled caching-job that suddenly started to fail with the following error after arbetray time, a span from 2 hours to 3.30 hours: [CACHELOADERROR] There was an error while inserting data : I/O Error: Connection timed out (Write f...

Answers: 1

keepAlive Connection