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.

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

how to perform recursive CTE in VQL
answered 12-02-2019 03:15:16 -0500

WITH cte1(inventory_item_id,related_item_id,recursivecallnumber) AS( SELECT inventory_item_id,related_item_id, 1 recursivecallnumberFROM MTL_RELATED_ITEMS B where inventory_item_id=5364273--5623321--142783 and relationship_type_id=6 UNION ALL SELECT e....

Answers: 1

Copying ntlmauth.dll to DENODO_HOME/jre/bin
answered 10-02-2019 22:01:51 -0500

Hi, I would like to add my experience with Denodo 5.5 in Windows 2012 64 bit. I had to copy ntlmauth.dll to %DENODO_HOME%/jre/bin and restart the server instead of %SYSTEMROOT%/system32. The latter wouldn't work and raised a "SSO Failed: Native SS...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

NTLM JDBC Data Sources SQL Server SSO

How to VDP from OBIEE via ODBC where VDP server is ssl enabled
answered 08-02-2019 18:19:57 -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: 1

How to access to VDP from OBIEE via ODBC in linux

LAG funcation in Denodo
answered 08-02-2019 16:50:37 -0500

Hi How i am suppose to implement following function in Denodo LAG(A.DESCRIPTION,1) OVER (PARTITION BY A.ID ORDER BY A.TIME) AS DESCRIPTION_FROM

Answers: 1

problem with acme_crm
answered 08-02-2019 10:56:46 -0500

I use the Denodo platform 7.0 and mysql workbench 8.0.12. Hello, As I made some mistakes in the beginning with the tutorial, I wanted to start again from the beginning so I dropped all folders and the tutorial database too. After I created the tutorial...

Answers: 1

Learning path for Denodo
answered 08-02-2019 09:06:09 -0500

Hi, From my company, we are starting a learning drive for DV and Denodo.I would like to know what should be a course path if we start to learn Denodo today? We do not have much knowledge on Data Virtualization but have a good working experience in BI D...

Answers: 1

listtag in denodo
answered 08-02-2019 06:36:52 -0500

Hi How i am supose to execute following query in denod listagg (C.SHORT, '; ') WITHIN GROUP ( ORDER BY C.SHORT asc) AS DESCRIPTION

Answers: 1