Q&A

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

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

FK/PK constraints in Hive3
answered 13-08-2021 08:00:01 -0400

Hi denodo team i have a question about denodo and hive3. I heard that hive3 will be add into official support source database in next denodo updates. And will denodo collect releationships(PK/FK) automatically when create several base view from hive l...

Answers: 1

Hive Denodo and Hive

Make use of external key management system for encryption
answered 13-08-2021 07:48:05 -0400

Hi all, Can I check if Denodo allowed us to make use of external key management system for encryption and maintaining the encryption keys? Thanks!

Answers: 1

pictures
answered 13-08-2021 05:56:10 -0400

Hi, Some pictures on this article are not visisble, please fix them

Answers: 1
Related to: How to obtain permissions of LDAP users

Any success story implementing high load client-facing applications that use Denodo as DV in between many datasources?
answered 13-08-2021 04:11:16 -0400

Hi community Is anybody could share success story implementing high load client-facing applications that use Denodo for retreiving data coming from many datasources (local databases as well as foreign cloud databases) ? Based on your experiences, plea...

Answers: 1

customer facing

Associations between base views and derived views?
answered 12-08-2021 17:29:23 -0400

Hi Team, Does it makes sense to create associations between base views and dervied views? Ot just create associations between base views ? And create seperate associations between derived views? Also for the scenario where there is no PK FK relation s...

Answers: 4