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.

VQL Required to add a data movement plan using Alter?
answered 01-04-2020 15:37:11 -0400

What is the VQL required to Alter a data movement plan? Here is the context from the CREATE statement: CREATE OR REPLACE VIEW sv_basespace_rundata as field1 field2 field3 CONTEXT (DATAMOVEMENTPLAN = iv_getsession_roles : JDBC datasources."ds_BaseSpace...

Answers: 1

VQL 7.0

Installing Denodo Platform on Linux boxes
answered 01-04-2020 00:07:38 -0400

Hello All, I am new to Denodo and interested to learn denodo from scratch, so to do so I am looking for denodo installer for cloud platform. Could anyone help me where to get installer for 64 bit linux ? Thanks in Advance!!

Answers: 3

Linux aws free-trial new installation

Login Error
answered 31-03-2020 23:14:43 -0400

I have downloaded denodo but when I select the Icon from my desktop, I receive an error stating there is an initialattion error and connection refused. Please advise. Thanks, Louise

Answers: 2

Denodo VCS for Users, Roles with git
answered 31-03-2020 10:32:06 -0400

Hi Team, Our project have git configured in VDP, and we can see data sources, fodlers, views are in gitlab repository, but we cannot see anything about the users, roles in gitlab repository, can we have version control for users, roles through VDP inte...

Answers: 1

git VSC Roles Users

Can Denodo be integrated with Bitbucket?
answered 31-03-2020 10:02:16 -0400

For version control , can denodo be integrated with Bitbucket? As per documentation it cam be integrated with svn and Github

Answers: 1

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

unpivot VQL cross apply