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.

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


Converting varchar to timestamp
answered 06-08-2018 16:10:33 -0400

Hello, I wanted to convert a datetime field I have to a unix timestamp. This thing is - that the datetime values are stored as varchar on the DB. Is there a way to convert a varchar to unix timestamp on Denodo? Thanks, Itay.

Answers: 4

Insert is not working when I use Join with Insert
answered 06-08-2018 05:44:03 -0400

Hi Team, I am trying to insert data into my target table based on source table as I used below code for that but Iam facing error like this (INSERT INTO only available for materialized and temporary tables). My scenario is: I have 2 tables src_typ1 an...

Answers: 1