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.

days function
answered 18-02-2019 01:05:21 -0500

Hi Team I am able to execute on DB2 but not on the Denodo , is am i missing something (days(current_date)-days(view_a.DATEOFBIRTH))/365

Answers: 1

VDB error on the combination of to_date and formatdate functions
answered 17-02-2019 23:36:32 -0500

Hi Team I am using following functions on a filed but i am getting the VDB error Statement to_date('YYYYMMDD',formatdate('YYYYMMDD',cust.dateofbirth)) Error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing cap...

Answers: 1

Are newer versions of subversion supported on Denodo 7
answered 15-02-2019 07:28:14 -0500

I noticed that the documentation refers to supporting Subversion 1.7. Our version of the CVS repository is slightly newer than that. Will it work correctly.

Answers: 1

VCS SVN

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