Q&A

JiSQL setup failing with Could not find or load main class
answered 19-04-2021 11:35:55 -0400

Hello, I have been try to setup jisal , i followed steps likes downloaded the .zip extracted and also copied the jdbc driver "denodo-vdp-jdbcdriver.jar" in jisql-2.0.11/lib/ . But when i try java -classpath lib/jisql-2.0.11.jar:lib/jopt-simple-3.2.j...

Answers: 3

JiSQL

Can't create Remote table, Denodo says that the view was not found, but it exists
answered 19-04-2021 09:36:27 -0400

Hello I am trying to create a remote table in DEN80EDU23DS06 as follows: SELECT * FROM CREATE_REMOTE_TABLE() WHERE remote_table_name = 'bv_cc_case_call_remote' and query = 'SELECT call_id, location_id, problem_code, status_code, date_ticket_issued, dat...

Answers: 2

Base view remote table

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