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.

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

Request header was not found even the pdf exists in recording
answered 02-10-2017 10:34:07 -0400

I successfully save the pdf when recording the sequence. But when I play the sequence, I got this error. It means that the pdf is exists. => ERROR ( The requested header was not found)

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

Denodo Scheduler Extracted and Processed tuples
answered 28-09-2017 09:04:47 -0400

Hi Team, I have cached a view and refreshig\loading data from one of the job. My view has around 4.5 million records in DB, same number of records are extracted, but processed tuples would be 19k only, I am not sure why its behaving like that...it supp...

Answers: 1

Protocol to connect Denodo Scheduler from a third party
answered 27-09-2017 04:31:29 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 4

DENODO Denodo Scheduler 6.0

Denodo Monitor log
answered 26-09-2017 09:40:38 -0400

Hi Team, It is possible to get a monitor log,VDP-threads.log,VDP-resource.log for the particular date if the log is not available for that date. Thanks

Answers: 1

records limit in derived view in VDP
answered 26-09-2017 09:15:13 -0400

Hi Team, I have a derived in Denodo with many views joins, i have same SQL code. when I run this SQL in oracle its showing 380000 records but when I run the derived view in denodo it not populating all the records ...at least its now showing the number...

Answers: 3

Virtual dataport security exception: dsa signature not available
answered 26-09-2017 07:04:39 -0400

Hi, I am getting below error while staring VDP . 1 [main] ERROR 2017-09-26T12:05:05.601 com.denodo.vdb.catalog.storage.DBDerbyStorageManager - Unable to initialize databasejava.sql.SQLNonTransientConnectionException: Connection refused : Fatal: There...

Answers: 1