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.

Parametrised Query
answered 19-02-2020 14:07:59 -0500

How can i apply filter on two column at the same time like or in below mentioned URL(What and where should i add second column condition): http://<host of the denodo server>:9090/server/<name of the database>/<name of the REST API>/v...

Answers: 1

Metadata limits
answered 19-02-2020 13:28:43 -0500

Hi, I have been checking through the documentation but have not be able to find the information. Are there any limits on the number of databases / views that can be put on a Denodo server? I am pretty sure I have heard in some presentation that there ...

Answers: 1

No row limits in REST Web Service
answered 19-02-2020 09:41:28 -0500

Hello: I am using REST Web Service (no RESTful) and I want to avoid the pagination. I mean, It always shows only 25 rows in any view, and I need to have all the rows in the same web page. Is there any option? I have done it with RESTful, but I need i...

Answers: 2

Job Scheduler
answered 18-02-2020 07:26:01 -0500

Hi, can we create a job to join two tables without create this denodo view to predefined this join? Our info security has legal requirement that only eceute the job like "select a1.b,a2,c from a1 join a2 on a1.d=a2.d" without creating denodo view first...

Answers: 3
Related to: Master-slave configuration for Scheduler

Denodo Parameter Error - without search methods
answered 18-02-2020 05:35:01 -0500

I created a view with a parameter. If there is specific value typed into that parameter the view processes just fine.However, I need the parameter field to be blank, so when you open the view the end user has the option to type in the parameter they ar...

Answers: 1

search methods Parameter

Cannot connect to the SOAP web services
answered 17-02-2020 05:33:26 -0500

Hi Team, I've downloaded the Denodo Express Platform and I've got stuck in this part of the tutorials: Advanced Operations - Importing SOAP Web services When I try to create a SOAP data source and then, press the 'Create Base View', nothing appears....

Answers: 1

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