Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

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

Denodo storing the data in external database.
answered 15-04-2021 08:41:35 -0400

Hi Team, If connection breaks from Denodo to exteranl database dues to some network issue or if external database instance goes down then what is retry startergy? How often Denodo tries to reconnect? what is max retry count?

Answers: 1

external database denodo retry

I'm not able to retrive attribute from xml using xpath
answered 15-04-2021 08:33:52 -0400

I want to retrieve an attribute from xml value using xpath but I cannot retrieve it. If I execute statemet: SELECT cast('text', XPATH ( CAST ('xml' , '<Root attr="1111"> test </Root>' ) , '/Root/text()', true)) as xpath_results FROM Dual();...

Answers: 3

XPATH