Q&A

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

Does Denodo supports Data presentation through charts and reports
answered 15-04-2021 18:18:14 -0400

Hi, Am doing POC on Denodo express. Just worried if Denodo supports a graphical presentation though graphs or charts, filtering etc on Data Catalogs? I am comparing the features with Kibana (from ELK stack) where it does virtualization as well as prese...

Answers: 2

presentation VDPs' Reports chart

Can't Create job - Error saving job: Internal error
answered 15-04-2021 09:08:44 -0400

Hello I am trying to complete the DEN80EDU15DS03, but when I try to create a new scheduler job I keep getting this error: Error saving job: Internal error Can anyone help? Thanks

Answers: 1

Job scheduler