Q&A

Date Range error
answered 10-02-2020 05:55:55 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Create Base View

Date Range parameter doesn't accept date
answered 10-02-2020 05:50:58 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Delimited file data source Create Base View delimited file sources rows columns pattern tupple

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered 07-02-2020 20:22:19 -0500

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc

Answers: 1

Create Base View JSON Delimited Files

Denodo Union / Sort Merge Performance Issue
answered 07-02-2020 18:46:56 -0500

I currently have two derived views, say D1 and D2, that are unioned together to create D3. I originally had an issue with both D1 and D2 which involved a sort merge. Both D1 and D2 are a join of two base views; each ran very well when I had a date fil...

Answers: 1

performance sort merge UNION

Accessibility with screen reader
answered 07-02-2020 07:10:32 -0500

Hello. I'm blind and use JAWS 18.0 (screen reader). I installed Denodo Platform 6.0, but I can't interact with it. Is there a package to install, which makes Denodo Platform 6.0 accessible? System information: OS Name Microsoft Windows 10 Enterpri...

Answers: 1

blind Accessibility JAWS 18.0

Error using Context in a Stored Procedure
answered 07-02-2020 07:08:23 -0500

Virtual DataPort v7.0 update 20190312 I try to use Java Scheduler API into a stored procedure to grant access to training user in the scheduler. When i run my code in Eclipse debug, everything goes well. But when i import the store proc into VDP and r...

Answers: 1

Denodo Scheduler 7.0

Error using Context into a Stored Procedure
answered 07-02-2020 07:03:25 -0500

Virtual DataPort v7.0 update 20190312 I try to use Java Scheduler API into a stored procedure to grant access to training user in the scheduler. When i run my code in Eclipse debug, everything goes well. But when i import the store proc into VDP and r...

Answers: 1

Denodo Scheduler 7.0

CustomWrapper returns 0 records when the file has additional column headers
answered 06-02-2020 12:58:56 -0500

Hi We've written a basic custom wrapper to read a text file and export to a table. The scheduled job to call the wrapper has been working pefectly for many months, however a change was made to append some additional columns to the file without our kno...

Answers: 3

Joining two tables
answered 06-02-2020 12:53:28 -0500

We are using Denodo Platform 7.0 I have question that in denodo how we join one column from a table and that column is lying within the range i.e minimum and maximum of columns in the second table . Ex : A is a column in table 1 and in table 2 we have ...

Answers: 1

Scheduler extractor part is displaying all the views .
answered 06-02-2020 07:52:51 -0500

Hi, I was trying to create a new vdpcache job in scheduler 7.0. In the extractor section after selecting the database, still I see that when i select new load process I see all the views showing in the list. Although in the VDP i restricted the access...

Answers: 1

Denodo Scheduler 7.0