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
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
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
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
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
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
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
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
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
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