Q&A

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