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

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

to get views in a single folder from every database
answered 07-08-2018 14:29:48 -0400

Hi, Is there a possible way to get views from a single folder from all the databases in VDP. For ex: I have 20 databases in VDP and I want to get a list of only interface views from every database in VDP. currently I am using get_views procedure to pu...

Answers: 1

views from all databases

Denodo installation error
answered 07-08-2018 14:28:33 -0400

Hi All, I am trying to install denodo express, it shows 0 bytes for all the packages. And for common package it shows 68.21MB. None of the package is getting selected, hence unable to install denodo. Please suggest how to fix it.

Answers: 4

cache refresh info
answered 07-08-2018 02:22:08 -0400

Hi Guys, is it possible to get a list of views having caching enabled, to check their latest cache refresh using VQL? If not using VQL, does Denodo have other ways to check for caching info about views?

Answers: 1

VQL VDP Cache