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

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

Cannot launch Denodo 7.0 Platform Control Center (did work previously)
answered 23-04-2019 07:48:01 -0400

Hello, We installed Denodo 7 on this windows10 enterprise server months ago. It was working fine until recently. Though the server can be started, and Solution Mgr starts on the same machine as it, we cannot launch the Platform Control Center from a sh...

Answers: 1

DriverManager.getDriver() for denodo-vdp-jdbcdriver.jar gives com.denodo.vdb.jdbcdriver.VDBJDBCDriver instead of com.denodo.vdp.jdbc.Driver
answered 22-04-2019 18:30:11 -0400

As part of an application code, I'm trying to get the Driver Classname from the provided JDBC URL. In case of Denodo, for the JDBC URL "jdbc:vdb://localhost:port/dataasset", I'm getting "com.denodo.vdb.jdbcdriver.VDBJDBCDriver" as the Driver Class Name...

Answers: 1

JDBC