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.

How to get authorised to make API call to external data set
answered 11-02-2020 07:23:19 -0500

Hi Im doing a prototype to call external data sets from a 3rd party externally developed app via invoking the APIs. I would like to use Denodo to access that. How do i do this? I am only given the Access Token and AccessKey. What is required to make ...

Answers: 3

When trying to start "licensemanager.bat" from Ansible (running on (Red Hat 4.8.5-39)), Ansible window is not coming back to prompt even after running the bat file.
answered 10-02-2020 19:07:09 -0500

When trying to start "licensemanager.bat" from Ansible (running on (Red Hat 4.8.5-39)), Ansible (Version 2.9.3) window is not coming back to ansible prompt even after running the bat file on the remote server. python version = 2.7.5 Below please find...

Answers: 1

java licensemanager startup Ansible winrm windows virtual data port startup from remote Starting from remote using Ansible

File privilege and database admin
answered 10-02-2020 12:20:49 -0500

Hi, Question related to the FILE privilege. I configured it to lock to a specific folder. I have a user which is granted admin right on a database, and the restriction on the folder does not apply, e.g. I can create a datasource with any local file. I...

Answers: 3

Cache Load Question
answered 10-02-2020 07:49:05 -0500

Source Database: DB2 I have a view say top_level_view, which takes a long time to query and aggregate from the DB2 database. We decided to cache this view with a where clause for 15K keyids. To begin with we tried to run the view without caching to se...

Answers: 1

Full Cache Cache

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