Q&A

Hi, Can I check how can prioritze operational queries over analytical queries? Can I check if the above question can be achieved in resource manager? if yes, if there's any documents that I can refer to do the setup? Thanks!

Load the Denodo Incremental Cache Load stored procedure in Denodo Virtual DataPort. The link was broken in 「Denodo Incremental Cache Load」part. Usage Statistics

I am facing an issue while paginating the data. We are getting response details in JSOn format and we are simply passing the path of that next page in JSON data source. But the Denodo Pagination mechanism is something where complete URI will be replac...

hi i have joined two views and i am trying to use order by clause on the view with the provided functionality in denodo 7 . but i am not able to use two or more columns, Is there any way i can use order by on the integrated view for multiple columns

We have been able to follow the procedure as stated from: https://community.denodo.com/kb/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication?category=Security We can see the lists data ...

Related to: Microsoft SharePoint as data source;jsessionid=58872EBE9D683D863D1323A2BA8F8100

Hi All, We are tring to connect with IBM Infosphere Datastage 11.5 v with Denodo through ODBC. IBM Infosphere supports Java 7.1 version and it cannot be update to Java 8 Can you please tell whether denodo have ODBC Drivers of Java 7.1 version to insta...

I see there is support of WITH statements allowing CTE work. Does Denodo support recursion in CTE's? I have tried to get it working, but the error back is that the name of the CTE does not exist. When I remove the recursion piece of the query, it wo...

On best practices, it is said that if we have multiple join, don't combine all in one view ... instead create layers of view .. Question: how many layers of view is recommended .. ?

We connected to THE DW of SAP according to this document, but encountered some problems. Please kindly check the document we are using https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/multidim...

I have scenario where the number unique values in the column (questionid) could keep getting larger. so I can't set up a static list of CASE conditions is there a way to dynamically take the column value for question id and put it across the top of t...

Related to: How to Pivot and Unpivot views