Q&A

Is there a query to get a list of views with EXECUTE permission for current user?
answered 26-07-2021 17:08:48 -0400

I want to list views accessible by the current logged user. Seems I should use GET_VIEWS(), GET_PERMISSIONS() and GET_EFFECTIVE_PERMISSIONS(), but cannot realize how

Answers: 2

VQL predefined stored procs

Unable to connect with Derived view from REST datasource with variable getting feeded from another view
answered 26-07-2021 12:48:33 -0400

Version :- Denodo 8.0 Hi, i want to use rest api url as one data source, for which i configured it as https://bioreg-uat.gsk.com:1743/bioreg/api/v1/entities/@{instanceId} Now we dont have instance ID this will be fulfilled from another data source whi...

Answers: 1

Joining of Two Rest API DataSources Data

Spring throws: "java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver" on Data Source instantiation
answered 26-07-2021 07:10:30 -0400

Hi dears, I imported Denodo JAR using maven and I configured my app to access Denodo views with the following properties and driver class name: spring.datasource.denodo.url: jdbc:vdb://<ip>:<port>/<db> spring.datasource.denodo.usern...

Answers: 1

springdatajpa JDBC Driver

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