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.

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

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

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

Errot installing DENODO Express 7.0
answered 01-04-2019 04:42:01 -0400

Just at the beginning of DENODO installeation (Windows 64 bits) I got a popup saying "Variable JAVA_HOME not found" with this additionalt text: "The environment variable JAVA_HOME must be set in order to install DENODO Platform.... What Can I do ? Ri...

Answers: 1

JAVAHOME %installDenodo