Q&A

Denodo FileSystem CustomWrapper - Error Loading data source
answered 20-02-2020 06:57:52 -0500

Hi all, I am currently working to see If the fileSystem connector would be suitable for a problem we have recently discovered. However, after following the procedures outlined here: https://community.denodo.com/docs/html/document/denodoconnects/lates...

Answers: 1

Custom Connector BINARY file system

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