Q&A

joining multiple base view error via custom wrapper parquet file in S3.
answered 08-07-2020 11:00:56 -0400

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

Answers: 3

S3 parquet file DENODO AWS S3 derived view custom wrapper

Query to find our who has access to an interface?
answered 08-07-2020 09:41:45 -0400

Is there a query we can run or API to determine who has read access to an interface? Anything more elegant than exporting the create with users and permissions and look at the VQL? Anything in Data Catalog? Damn. No way to edit the typo in the questio...

Answers: 1

Duplicate views are getting created while creating base views
answered 07-07-2020 14:18:41 -0400

Hi Team - I am creating base views on a delimited data source(CSV). For this I created a base view under this data source object in the server explorer pane of VDP Admin client. I also see another base view (with the same name) also getting created aut...

Answers: 2

Base view

Code deployment using Solution Manager
answered 07-07-2020 09:20:41 -0400

While creating a revision through SM, is the only option we have is to select the VDP elements(e.g. a view) which are currently available in a VDP server's metadata repository ? or we can go to a branch of Git and select elements from that branch, whi...

Answers: 1

Deployment using Solution Manager Best Practice

Denodo VDP integration with Git
answered 07-07-2020 07:14:01 -0400

The question is regarding the Revert operation on Git. I understand I can go into repository and pull a historic version of an element. Questions are - 1) Can we revert an entire database in one-go ? 2) Can we also revert individual elements(say a view...

Answers: 1

Denodo with Git

Using Create Revision API of Solution Manager
answered 07-07-2020 02:41:52 -0400

I am looking at the documentation of creating a Revision from a VQL file https://community.denodo.com/docs/html/browse/7.0/solution_manager/administration/appendix/rest_api/rest_api#create-a-revision-from-a-vql-file Couple of questions on the usage of...

Answers: 1

Solution Manager API

Traverse links at associations
answered 06-07-2020 16:23:15 -0400

hey, I saw at documentations that we can't traverse links execpt if primary key defined at view , but I create assocciation wihtout definig primary keys at views and I traversed links at resftful webservice , how that happen please?

Answers: 1
Related to: Associations in Denodo

Association Associations

From where do the solution manager gets the details of the VDP elements while creating a revision ?
answered 06-07-2020 10:01:58 -0400

From where do the solution manager gets the details of the VDP elements while creating a revision ? Does it connect directly to a VDP server's metadata repository and fetch all the objects and shows in the Create Revision UI or it connects to VCS (e....

Answers: 1

Deployment using Solution Manager Best Practice

Business Objects universe
answered 06-07-2020 09:34:39 -0400

I am trying to connect a business objects universe to denodo. I succesfully installed the JDBC client and was able to create a connection in Business Objects. In the Bobj IDT I am able to create a simple universe and publish. However when I try to crea...

Answers: 3

Create from query is not working with Oracle dates
answered 06-07-2020 08:29:10 -0400

Team, I found that parmeterization of a date column present in oracle 11g database is not working while using as a parameter in create form query option.for example, in date column x we have value as '01-NOV-20', when we create view using create from ...

Answers: 1

Oracle Date