Latest Activity

Base view I cannot see query capability

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...

Error while using custom function. com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable

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...

Isolated query of a joint view

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...

Direct Query in Power BI Dashboard is not working

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...

Help rewriting REGEXP_LIKE Query to VQL

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 ...

ODBC DSN connection error

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. ...

Column based security in Custom Policy?

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 ...

Can't Create job - Error saving job: Internal error

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

Denodo storing the data in external database.

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?

I'm not able to retrive attribute from xml using xpath

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();...