Q&A

Denodo Training QuickStart Virtual Machine.ova​
answered 12-02-2020 22:50:58 -0500

I have been trying to set up envritonments for on-demand courses based on "Denodo Training QuickStart Virtual Machine. So far, I have finished installing Oracle Virtual Machine. Then in section, Importing the DQVM in Oracle VM VirtualBox," it says that...

Answers: 4

DQVM

Need more details on Developer (Introduction) - Exam
answered 12-02-2020 05:31:45 -0500

CAn i know more details about the Exam: DEN70EDUD01 - Data Virtualization Developer (Introduction) - Exam Need to know what pattern the exam will be, the waitage of each modules and any specific module will be given more importance in exam. how many ...

Answers: 1

exam

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