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.

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

concatenate

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

Unable to use the analytic function in Denodo-VDP
answered 03-04-2019 05:49:30 -0400

Hi, I am trying to use the analytic function in my derived view in VDP. but it did not recognize the functions and getting errors. (tried all the analtic functions , I got the same errror.. see attached the error detail hyperlink) rank() OVER (PARTITI...

Answers: 2

#Analytic function

How to get result in array or registered ?
answered 02-04-2019 10:31:13 -0400

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...

Answers: 2

XPATH XML

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

Error MSSQL

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: 192.168.100.100 ( or data-server if hosts file has been configured) •Port: 1521 •Database URI: jdbc:oracle:thin:@192.168...

Answers: 1