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

QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Invalid column name 'true'.'
answered 06-10-2017 05:17:31 -0400

I'm using Tableau 10.4 using the included denodo data source. During the generation of filters I get the message Finished with error: Error executing query. Total time 0.093 seconds. QUERY [GROUPBY] [ERROR] QUERY [PROJECTION] [ERROR] QUERY [VIRTUAL]...

Answers: 1

list all view and their VDB
answered 06-10-2017 04:27:29 -0400

Hi, is there a View in Denodo which can provide me list of all the views and their corresponding VDB available on a server ? Currently the only option i find is using LIST VIEWS ALL : but it only provides Views of the VDB i am logged in catalog_...

Answers: 2

SaveFile after PostData
answered 05-10-2017 12:45:25 -0400

How to use SaveFile after PostData have executed. I want to save the output of the PostData. PostData(SomePostAction); SaveFile(PostData, directory); Like this. Thank you.

Answers: 1

Request header was not found
answered 05-10-2017 11:21:37 -0400

I got this error message when i follow your steps. Any idea? => ERROR ( The requested header was not found)

Answers: 3
Related to: Downloading a file from a website

How to create base view which accepts parameter
answered 05-10-2017 05:32:10 -0400

Hi Team, How to create base view which accepts input parameter? If you can share sample VQL then it will be helpful.

Answers: 1

base view

Get current url
answered 04-10-2017 12:51:36 -0400

How can i get the current url of the page i am visiting? javascript equivalent is window.location.href

Answers: 1

time conversion issue
answered 04-10-2017 08:58:01 -0400

Hi, I have a Redshift table where datetime is recorded in UTC and when i access the same table through a base view in Denodo, the time it shows is not correct.Basically it substract 5 hrs from the datetime column of redshift( I am in the CST time zone)...

Answers: 1

Save file after submit button
answered 04-10-2017 01:07:34 -0400

Is there way to extract the file after the button is submitted. Example scenario: Submit button clicked > file is view to the browser (http://website.com/file.doc) How to download the file or How I can get the url of the file in the browser (htt...

Answers: 3

Extracting data from Facebook
answered 03-10-2017 07:24:09 -0400

Is there a tutorial for how to configure a data extract from Facebook? I'm looking for posts on a page and who liked the page.

Answers: 1

Multiple created values in a CTE
answered 03-10-2017 05:02:17 -0400

Good afternoon, I am trying to use a CTE with multiple values. ie: ;with pd as ( select '12345' ) But I need a large amount of values, and am not sure of the syntax needed to do multiple select's in a CTE in this manner. So I would need 12345, 1234...

Answers: 1

CTE