Q&A

Issue when accessing the GraphQL service on denodo
answered 19-04-2021 09:21:50 -0400

Denodo version 8 followed doc at https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/graphql_service/graphql_service Upon visiting the service http://denodo:9090/denodo-graphql-service/graphql/<our-database-...

Answers: 1

GraphQL

load comments from tables of a orig data source (Oracle) to existing data ource on Denodo
answered 19-04-2021 08:26:11 -0400

Denodod 8 original tabel is on Oracle DB I added some comments to a table which on a Oracle DB and I want ot load the comments to the table/base view on Denodo

Answers: 1

Is it possible to create an enterprise VDB that contains primary data sources to be shared with other VDBs?
answered 19-04-2021 08:20:40 -0400

If we create a view in one VDB, can it actually be based on a data source located in a separate VDB?

Answers: 1

Base view I cannot see query capability
answered 19-04-2021 04:05:34 -0400

hello, I am using Denodo Express 8 and While applying training exercises I can not see Query capability for any base view. Actually when I open a Base view, I click on Option then Seach Methods, I have only Method Name, Wrapper Name and Madatory field...

Answers: 1

Base View configuration

Error while using custom function. com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable
answered 16-04-2021 08:36:36 -0400

Thank you for the answering my previous question on custom funtion for the error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable. I didn’t find any synt...

Answers: 1

Custom Functions

Isolated query of a joint view
answered 16-04-2021 08:35:01 -0400

Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...

Answers: 1

Denodo 8.0 performance join

Direct Query in Power BI Dashboard is not working
answered 16-04-2021 07:24:51 -0400

Hi and thank you for read this. I did a connection between a view in the Denodo Data Catalog and Power BI Desktop data set through a gateway selecting the Direct Query import option. Then I upload my data set and dashboard to the Power BI Service. I st...

Answers: 1

Power BI Dashboard Direct Query Power BI Service

Help rewriting REGEXP_LIKE Query to VQL
answered 16-04-2021 05:39:36 -0400

We are needing some assistance/suggestions in rewriting the following Oracle query. Query is basically creating a list(listagg) of a list of regions gathered from abc.table123 (security config table, each row is different region), and then needs to be ...

Answers: 1

VQL REGEXP_LIKE regexp_like Oracle SQL to VQL Converter SQL to VQL to_char

ODBC DSN connection error
answered 16-04-2021 04:16:53 -0400

Hello, I'm using Denodo Express 8.0 and trying to configure DSN for ODBC connections, but getting weird error went trying to test it (image attached). All ports are default. ODBC driver is installed from <DENODO_HOME>/tools/client-drivers/odbc. ...

Answers: 1

ODBC Error DSN

Column based security in Custom Policy?
answered 15-04-2021 23:55:15 -0400

We've built a Java custom policy that returns certain rows of data based on the user's security in a config table, but can Custom Policies give us column-level security? As in, can Denodo return only a certain amount of columns of a table based on the ...

Answers: 1

Denodo 8.0 custom policy data security