Latest Activity

code

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

code

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

code

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

code

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

code

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

code

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

code

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

code

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?

code

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

code

VDP v7 Not able to pull from Gitlab

Hi - when pulling the latest code from remote, it succedes. We can see the correct files on the Denodo server. But when pulling inside the VDP client, not all changes appear, but no error is reported. We are running version v7.0.2x We can also push...