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

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

Create Base view from SQL query
answered 15-02-2019 07:24:08 -0500

Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...

Answers: 1

Denodo Express PostgreSQL Select Query

Windows services dependencies
answered 15-02-2019 06:58:24 -0500

Hi, is there a specific order or sequence that has to be kept in mind when starting the Denodo services on a Windows environment? Thanks in advance!

Answers: 1

windows

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

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