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.

Denodo Solution Manager Monitoring Tool - java.sql.SQLException: Incorrect syntax near ')'.
answered 25-04-2019 18:49:11 -0400

I am in process of setting up the Denodo Solution Manager Monitoring Tool. After much pain in getting the connection string sorted out, I now get the following error in the solution-manager.log: 501926880 [Thread-90] ERROR 2019-04-24T15:31:53.363 com....

Answers: 1

Unable to connect to VDP server running on AWS with Admin tool on personal machine
answered 25-04-2019 16:26:07 -0400

As you suggested in my earlier question, I made the following checks before I tried to connect to Denodo server running on AWS from VDP admin tool on local computer. This time I am connecting to Denodo 7.0 enterprise edition installed on AWS. The Deno...

Answers: 1

Unable to use the analytic function in Denodo-VDP
answered 25-04-2019 09:12:14 -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: 4

#Analytic function

Redshift Spectrum table
answered 24-04-2019 18:13:27 -0400

Hi Denodo Team, We have configured redshift and everything working fine for redshift tables. however having issues with Redshift Spectrum tables. for Spectrum we see the schema name and if I hit Plus sign it returns nothing. we have many tables under ...

Answers: 1
Related to: How to connect to Amazon Redshift from Denodo

XML Data Source : Character reference "&#xB" is an invalid XML character.
answered 24-04-2019 18:09:45 -0400

Hi, I'm using v7.0 20181011. Attemting to create a base view from an XML data source, I'm getting the error "Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Character reference " " is an invalid XML character....

Answers: 1

XML XML Data Source

Schema change and Source Refresh with Denodo and Cache store
answered 24-04-2019 17:23:09 -0400

Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...

Answers: 1

Source refresh schema change Cache error Cache

HTTP client JSON
answered 24-04-2019 17:22:22 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a JSON HTTP client example to practice. This does not work : http://data-server:8080/sales-ws/sales/ Thanks.

Answers: 1

JSON HTTP client

HTTP client
answered 24-04-2019 13:38:18 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a MS Excel HTTP client example to practice. Thanks.

Answers: 3

Excel HTTP client

JARS Export
answered 23-04-2019 21:28:36 -0400

Hi Team, Is there any option to export jars alone in denodo 5.5 Version. If it so could you please share us the steps to do

Answers: 1

Make Server Configuration Changes VIA VQL
answered 23-04-2019 18:17:48 -0400

Is it possible to make to server configuration changes using VQL? For example, is it possible to alter kerberos settings, like adding User Base values?

Answers: 1

VQL Server Configuration Changes