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.

row_number not working with the get_view_columns
answered 14-02-2020 21:44:17 -0500

Hello Denodo gurus! Why does row_number not work with the get_view_columns? select database_name, view_name, column_name as denodo_column_name, ROW_NUMBER() OVER ( PARTITION BY view_name ORDER BY database_name ) row_number_with_partition from get_vi...

Answers: 1

row number Delegate get_view_columns

Resource Manager Query to queue
answered 14-02-2020 21:43:02 -0500

Hi, Is there a way to automatically send a query to queue if it surprasses for example, 80% of CPU usage? Thank you, Best regards

Answers: 3

How to get VQL command metadata response message using JDBC connection.
answered 14-02-2020 07:18:59 -0500

Hi Team, I am using JDBC connection to execute the VQL commands from my application. Let's say I want to create a role or modify the description of the role using 'Create /Alter command query' as shown in example below For example: Create role testro...

Answers: 3

VQL VQL Role

How to import column descriptions from MS SQL Server data sources?
answered 14-02-2020 07:11:47 -0500

Similar to the following article about Oracle: https://community.denodo.com/kb/view/document/How%20to%20import%20column%20descriptions%20from%20Oracle%20data%20sources?category=Data+Sources How does it work for MS SQL server to get the descriptions/c...

Answers: 5

Bypass Denodo Scheduler Webadmin User
answered 13-02-2020 10:55:02 -0500

Hi Team, While using Scheduler API, is there any way to bypass the Denodo Scheduler Webadmin user. By Default we see that when we try to login into schedler webadmin by default uses admin/admin. Once we are logged into webadmin, then we are redirected...

Answers: 3

Denodo Scheduler 7.0

Create a Selection View and get only the first 2 records
answered 13-02-2020 07:32:36 -0500

Hello I want to create a selection view of a derived view that has a column "date" (localdate), and in this selection view I waht to order by date desc, and I only need the first 2 records. How can I do that in denodo? I have this record: 2019-12-01 ...

Answers: 3

select derived view

Is there a way to export data to EXCEL from a weblink?
answered 13-02-2020 05:36:23 -0500

I am trying to Export the data displayed from the weblink of Denodo Restful Web service into a excel spreadsheet. I dont see the functionality on the page.

Answers: 1

Export

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

Delimited File sources with DateRange
answered 12-02-2020 06:57:16 -0500

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 6

Interpolation Variables Delimited Files

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