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.

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

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

I have installed Denodo 7.0 Express,But could not able to upload licence file.
answered 06-08-2018 01:13:03 -0400

Could you please help me with licence file and why i am getting this error?

Answers: 1

What privileges are needed to connect to the Data Catalog
answered 03-08-2018 12:23:11 -0400

Hello, I'm an admin on one Denodo 7 database, not a "full admin." My admin created a second user for me to test with. I granted the second user all the priviledges to the database, and can conenct as the second user using VDP admin. When I try to conn...

Answers: 8

data catalog connect

Denodo base view times out in 15 minutes (Microsoft SQL Server 2014 (MS Driver))
answered 03-08-2018 12:20:58 -0400

Denodo Server times out when I try to access the base view that takes more than 15 minutes to execute. Since query timeouts are a client side concept only, I have already altered below settings on BOTH the clients: Admin Tool Preference -> Connect...

Answers: 1

JDBC QUERY_TIMEOUT