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

ITPilot and Aracne disabled
answered 05-06-2017 06:59:13 -0400

I installed all the Denodo tools including ITPilot and Aracne but when I open my Denodo platform control center these two are disabled on my Windows system. Kindly help.

Answers: 1

Aracne ITPILOT

Connect Denodo 5.5 thru IBM Infoserver(Datastage) using JDBC Connector
answered 02-06-2017 07:24:10 -0400

I am trying to connect Denodo 5.5 thru IBM Infoserver(Datastage) using JDBC Connector and throwing CertpathBuilder exception, is any one tried this connection. Denodo environment is SSL enabled.

Answers: 1

Denodo 5.5 thru IBM Infoserver(Datastage) using JDBC Connector
answered 02-06-2017 07:22:31 -0400

I am trying to connect Denodo 5.5 thru IBM Infoserver(Datastage) using JDBC Connector and throwing CertpathBuilder exception, is any one tried this connection. Denodo environment is SSL enabled.

Answers: 1

Debug request response issue
answered 02-06-2017 07:14:40 -0400

We rarely face below issue and Its kind of Internal Server Error. ‘Error retrieving data from ‘Path’. HTTP error code: 500.’ I want to debug this issue and find the cause of this . Why request-response does not work sometimes. Please help me to resol...

Answers: 3

Unable to fetch data from webservice(happens rarely)

Denodo installation steps on mac os
answered 02-06-2017 06:46:27 -0400

Hello everyone, I am absolutely new to denodo tool. I would really appreciate if someone can guide me through simple steps to install denodo on mac. My current mac os version is Mac Sierra 10.12.5 and java version is 8. Please help. I just need to get...

Answers: 1

DENODO MAC os new installation

Denodo Express install
answered 01-06-2017 13:11:33 -0400

I have downloaded the denodo express and when I try to launch this application, it is only showing vistual dataport admin tool to launch. But how do I get the dev tool itself. Please share any document on how to launch denodo ?

Answers: 1

Localization for web application
answered 01-06-2017 07:23:26 -0400

Hello, guys. Is it possible to enable the "Internationalize query results" option not only for VDP, but for web application which queries the denodo (there are timestamp fields in the database)? The main purpose is to use server locale where database...

Answers: 1
Related to: Internationalization configuration and dates

i18n

OBIEE report QueryTimeout
answered 31-05-2017 15:44:50 -0400

as per this doc, configured OBIEE to connect with Denodo. but couple of my reports are failing with time out error. I verified my ODBC.ini file it has QueryTimeout=0 which means no time limit. but still it is failing, can you pls advice on this issue ?

Answers: 1
Related to: How to access to VDP from OBIEE via ODBC in Linux

QueryTimeout

datediff year
answered 31-05-2017 08:46:39 -0400

What is the translation of datediff(Year,date1,date2)?

Answers: 1
Related to: Microsoft SQL Server SQL to Denodo VQL Quick Reference

Creating a Denodo derived view with correlated subquery
answered 31-05-2017 07:34:02 -0400

We are using Denodo 6.0 and trying to create a Denodo derived view which has a corrleated subquery. SELECT T1.TRNS_ID, T2.BLD_TS FROM bv_CMSN_TRNS T1 INNER JOIN bv_CMSN_STAT T2 ON T1.EDI_TRNS_ID = T2.EDI_TRNS_ID WHERE T2.BLD_TS = (SELECT MAX(BLD_TS) F...

Answers: 1