Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Link broken in Usage Statistics (404not found)
answered 20-08-2021 17:27:18 -0400

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

Answers: 1

Data Catalog

Denodo Pagination - JSON Source
answered 20-08-2021 16:20:51 -0400

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

Answers: 1

Denodo Pagination

Not able to use order by clause for multiple columns
answered 20-08-2021 14:04:02 -0400

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

Answers: 1

We are able to see lists, yet files attached are only retreived as filenames and not a BLOB
answered 19-08-2021 19:33:35 -0400

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

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

Denodo 8 BLOB SharePoint

Denodo Driver with Java 7.1 version
answered 19-08-2021 03:36:18 -0400

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

Answers: 1

java 7.1 version ODBC Driver IBM INFOSPHERE Datasatge 11.5 v DATASTAGE

Common Table Expression (CTE) and Recursion
answered 18-08-2021 04:59:45 -0400

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

Answers: 3

CTE Recursion

Best Practices
answered 17-08-2021 06:54:50 -0400

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

Answers: 1

unable to connect to the multidimensional server
answered 17-08-2021 06:24:45 -0400

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

Answers: 1

SAP BW

I do not have a finite number of values to include "cases" on to create new columns
answered 16-08-2021 11:08:24 -0400

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

Answers: 2
Related to: How to Pivot and Unpivot views

Register pivot crosstab

Denodo Scheduler Information
answered 13-08-2021 18:37:34 -0400

Does the Denodo stores the job schedule and run information in any of the metadata (scheduled through the Denodo Job Scheduler)? Kindly let me know. Thanks !

Answers: 3

Metadata Denodo Scheduler 7.0