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.

git delete for vdp object
answered 31-03-2020 10:01:22 -0400

I configured git VCS for a databse. In VDP I created some assosiations and commit, push to github server, but when I delete some associations in VDP side and comit, push this deletion of those associations, I can see them disappear in VDP, but they are...

Answers: 3

denodo git delete

Error obtaining the expressions to delegate the projected fields to source vdpcachedatasource
answered 31-03-2020 09:36:18 -0400

Hi, We are obtaining randomly this error (we run the job daily, but sometimes it produces failure, other days not): "Error obtaining the expressions to delegate the projected fields to source vdpcachedatasource" Last time we had to delete the view ...

Answers: 3

Cache error

Error creating jar: Extension was built with a later JVM version
answered 31-03-2020 08:12:31 -0400

I'm getting error while importing a jar file into Denodo using JAR management. "Error creating jar: Extension was built with a later JVM version" Java procedure has been built and trying to import into Denodo using JAR management. (File --> JAR M...

Answers: 6

Java Procedure Denod JVM

No suitable driver exception when trying to connect using Jmeter
answered 31-03-2020 07:47:41 -0400

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to se...

Answers: 1

Jmeter JDBC AWS SQL

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 30-03-2020 11:50:34 -0400

Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...

Answers: 1

VQL unpivot cross apply

JDBC connection to R with the Denodo 6 version
answered 30-03-2020 09:35:31 -0400

In response to the below Answer, Regarding the RJDBC and rJava packages, can you please elaborate more on this. Are these packages to be installed in denodo VDP Server? Thanks Hi, RJDBC and rJAVA packages are only useful when you try to connect to ...

Answers: 1

Denodo 6.0 JDBC

Base view deployed even though table not present in database
answered 27-03-2020 12:22:06 -0400

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

Answers: 1

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

Is it possible to connect to R with the Denodo 6 version?
answered 27-03-2020 08:51:55 -0400

I am trying to establish a connection to R from denodo 6. Would like to know the steps and where to get RJDBC and rJava packages to install? Appreciate your help! Thanks Krishna

Answers: 1

Denodo 6.0 JDBC

Denodo Data Catalog Unable to Query
answered 27-03-2020 06:49:51 -0400

Whenever I try to query a view from the Denodo Data Catalog, it gets stuck saying "loading query tab" which never goes away, keeping the data catalog from being usable. Is there any way to fix this, and how would I go about it? Thanks, and I really hop...

Answers: 3

data catalog

Great video...please keep it up for future updates!
answered 27-03-2020 05:01:46 -0400

Quick feedback that we really appreciate the effort put-in to produce this video. So nice to get a cursory (but firsthand) look at key features without having to skim through detailed release notes!

Answers: 1
Related to: Denodo Platform Enhancements - 7.0 Update 20200310