Q&A

Denodo 8: synchronize the VDP server metadata with Data Catalog using Data Catalog REST API
answered 23-07-2021 20:15:36 -0400

Hi Team, I am following page https://community.denodo.com/docs/html/browse/7.0/vdp/data_catalog/appendix/rest_api/rest_api#rest-api for metadata synchronization from VDP to Data Catalog for Denodo 8. Can you please help confirm if the Denodo 8 can use ...

Answers: 3

Denodo 8 REST API VDP Synchronize Data Catalog

VDPCache for multiple tables
answered 23-07-2021 19:48:20 -0400

Hi , I want to load cache of multiple views through single VDPCache job from Scheduler . can we do it ? is there any example for the same ? (Version 8.0) TIA SJ

Answers: 1

LIST DATASOURCES
answered 23-07-2021 11:59:38 -0400

Hi Guysi am struck with getting List all datasources for Excel dataSourceType i am using this LIST DATASOURCES Excel ON scholar; query it is not working can any one help me on this

Answers: 1

A subquery is not delegated to the source and facing a timeout
answered 22-07-2021 18:31:52 -0400

In this, the subquery is not delegated to the source because it is executed from dual(). when we execute this full query, it is loading more than 2ml records first (Reason for query timeout) and then it applies the subquery logic in where conditi...

Answers: 1

denodo7 subquery

Passing case statement as subquery in select statement.
answered 22-07-2021 17:57:43 -0400

We are automating function to get prior two business days excluding weekends using below logic : select * from dw_vdb.cib360_bv_daily where as_of_date in (select case getdayofweek(current_date) when 3 then addday(current_date, -4) when 2 then addday(c...

Answers: 3

Denodo 7.0 Select Query CASE

I am integrating denodo view with Spring DATA JPA and facing unrecognized ssl connection error.
answered 22-07-2021 14:26:48 -0400

(http://)com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@987ff5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed a...

Answers: 1

SSL I/O error springdatajpa DENODO

Modifying the Scheduler export .
answered 22-07-2021 12:10:21 -0400

Hi , I have an export of DENODO scheduler of DEV environment ,When I promote it to higher environment like ST or UAT I want to modify the name of denodo Data source that I have created as per the respective environment . E.G - if in DEV I have - se...

Answers: 1

Preserve View Comments
answered 22-07-2021 12:07:48 -0400

I have noticed when creating a view any comments inserted are stripped out. I can't understand why stripping out comments would be a feature as comments are an extremely important part of development. Is there a way to preserve the comments like there ...

Answers: 1

Connecting from Microsoft PowerBi
answered 22-07-2021 11:53:32 -0400

Hi Team, Quick question, I've just downloaded and installed MS PowerBI on one of my VM's, however, am struggling to figure how can I connect it with Denodo. If I go to PowerBI then > Get Data > Database - in the dropdown list Denodo doesn't sh...

Answers: 2

denodo-v80-update-202107152200.jar fails command line update
answered 22-07-2021 03:07:00 -0400

./jre/bin/java /opt/denodo/updates-for-denodo-20210715/denodo-v80-update-202107152200.jar "/opt/denodo/denodo_platform_8_0" -c Error: Could not find or load main class .opt.denodo.updates-for-denodo-20210715.denodo-v80-update-202107152200.jar Caused b...

Answers: 1

Denodo 8.0 update Error Virtual DataPort