Q&A

How to backup user queries under Data Catalog?
answered 26-07-2021 23:32:49 -0400

Hi, Is there a way to automate backup of the Saved Quries by users? Currently I can see that an admin user has an option to "Export All User Queries" under "My Queries", but this is a manual way to do. Does the export script contain user saved queries...

Answers: 1

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