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 September 2019.

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.

Analytic function row_number() is not executable when executing it over a subquery
answered 04-04-2019 02:24:01 -0400

Inspite of enabling the Delegate Analytic functions list in source configuration of a Oracle data source the below query is failing with error "Function row_number is not executable". select Department_id, total_sal, row_number() over(partition by 1 o...

Answers: 1

concatenate rows - same column
answered 04-04-2019 02:03:20 -0400

Hello, I am trying to concatenate data from the same column but on different rows for the same record. The column in question is one that contains notes and what I need to do is combine notes. Below is an example of what I am looking to do. TABLE ID S...

Answers: 4


VQL issue
answered 03-04-2019 10:18:46 -0400

I have an issue with vql, whenever i am exporting and importing existing views are not replacing. suppose if i have folder A having 4 views and folder B having 3 views in Test-Environment when i am importing vql from QA environment with updated vales ...

Answers: 3

I can´t access to scheduller
answered 03-04-2019 08:23:34 -0400

I can´t access to scheduler. I installed denodo, started all servers and scheduler administration tool and when I try to login using admin/admin I get a connection error

Answers: 1

Denodo Scheduler 7.0

Connect to Denodo with C# via Npgsql
answered 02-04-2019 08:21:09 -0400

Good Morning, I am trying to connect via C# to Denodo. My connection string is ssl encrypted. Code is running in catch-branch by connection open. The following message is given: {"Received unexpected backend message ParseComplete. Please file a bug."...

Answers: 1

C# Received unexpected backend message Npgsql

Access to Derived Views from Mysql or Postgres
answered 02-04-2019 08:18:09 -0400

I have created some derived views and I need to read the data from those views and process the data and save it in an external database (Mysql, postbres), in a custom table. How you could do that? Or is possible to publish the information that I get fr...

Answers: 1

external Database PostgreSQL MySQL

Unable to establish connection to MS SQL express
answered 02-04-2019 01:46:36 -0400

Receiving the following error when trying to establish a Denodo 7 connection to MS SQL express (Windows 10, MS SQL version 14.0.2002.14): Unable to establish connection: Cannot open database "MAXXPHASE" requested by the login. The login failed. ClientC...

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


Unable to connect to trianing database
answered 01-04-2019 08:22:00 -0400

Hello, I try to create a jdbc data source as described in the training with the following credentials •Version: Oracle 11g •Host: ( or data-server if hosts file has been configured) •Port: 1521 •Database URI: jdbc:oracle:thin:@192.168...

Answers: 1

How to create a custom handler and exporter
answered 01-04-2019 08:17:57 -0400

I want to send an output file generated from one of the VDP jobs to a different server using FTP. In order to do so, we need to create a custom handler. I went through the link https://community.denodo.com/docs/html/browse/6.0/scheduler/administration/...

Answers: 1

handler import export scheduler isst

Getting error while creating username with number from User management in ADMIN tool.
answered 01-04-2019 04:44:11 -0400

Hi Team, I am getting error while creating username with number from User management in ADMIN tool. Eg, i am trying to create user by name : 212563189 from admin tool by logging as ADMIN user. I am getting error like, Name: Invalid field name. Pleas...

Answers: 1