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.

Group by condition failure with mysql database in Denodo 6.0
answered 10-08-2018 05:24:06 -0400

Hi, I am trying to create a derived view using group by condition with specific fields in denodo 6.0 with mysql database. There seems to be an issue with it. I am either getting communication link failure or it is atleast taking more than 2 minutes to...

Answers: 3

Using load tests with Denodo
answered 10-08-2018 05:11:44 -0400

Hello, How do run Load tests in Denodo? (i.e. using HP LoadRunner). The plan is to sen JSON messages to Denodo, and then from Denodo to the MySQL database (we need to read/write/update in the MySQL database)

Answers: 1

Denodo Testing Tool

Invalid parameter : Content-type
answered 10-08-2018 03:40:06 -0400

Hello, I am trying to consume a Rest API hosted on Apigee. The API is secured with oauth2 and I am trying to use the OAuth credentials wizard to retrieve the access token. However, the token request call specifically requires a content-type : applicati...

Answers: 1

REST API oauth

Algorithms used.
answered 10-08-2018 02:38:31 -0400

I am a student and I am working on a project on Network Virtualization so I came across DENODO so i wanted to know the different algorithms that are used in DENODO techonology for virtualization.Please help me.

Answers: 1

algo

Connecting Alteryx to Denodo throws error.
answered 10-08-2018 00:21:15 -0400

Hi, I'm getting error like when connecting Alteryx to Denodo Output Data (5) Error creating table "TESTING.IND_Purchasing": ERROR: Syntax error: Exception parsing query near '.'¶java.sql.SQLException: Syntax error: Exception parsing query near '.';...

Answers: 1

Folders not showing in Spotfire
answered 09-08-2018 18:48:26 -0400

We are connecting denodo to Spotfire using the JDBC driver. For our Data Source Template we have the XML below. Now, we can see all the objects we have authorize to display (mostly Base Views and Interfaces), however, the folders do not show. This is a...

Answers: 1

Denodo 6.0 JDBC spotfire Driver

query the admin.dvvdpquerieslog and getting only a couple days worth of the log.
answered 09-08-2018 13:03:02 -0400

I am attempting to query the admin.dv_vdp_queries_log in Denodo to understand view usage, but the data appears to only go back a couple days. Previously there were several months of data. I am gathering this is a setting that I am missing. where do I g...

Answers: 2

Error handling in base view of web service data source
answered 07-08-2018 18:08:20 -0400

Hello I have a base view that comes from a web service data source, when I make a query to the base view that is not found in the web service this sends an exception and the query returns an error (" Finished with error: Error executing query. Total t...

Answers: 1

source file info
answered 07-08-2018 15:14:16 -0400

Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...

Answers: 3

Excel XML Delimited Files

How to use Azure Data Lake as Source
answered 07-08-2018 14:30:26 -0400

I have CSV file in Azure Data Lake. I understood that Azure Data Lake is just a HDFS system and it can be accessed through the standard WebHDFS API. What is next step in Admin portal? What is data source type for this scenario? How to configure access?

Answers: 1