Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

DenodoODBC Difference
answered 19-02-2019 03:48:08 -0500

what is the difference between DenodoODBCAnsi(x64) and DenodoODBCUnicode(x64) Drivers? Which one is recommended to use?

Answers: 1

#odbc

How to schedule HTTP query run in VDP?
answered 19-02-2019 01:24:44 -0500

Hi team, I am new to Denodo. I have created an xml data source to run HTTP query. I can run it sucecssfully. I want it to run automcatically at defined date/time, how can i do that? I tried to explore Denodo scheduler but could not find any way to do t...

Answers: 1

Denodo Monitor: way to log the trace for an incoming query
answered 18-02-2019 04:10:42 -0500

Hello, is there a way to configure denodo monitor to log the execution trace or the queryies going to underlying datasources for incoming Denodo Queries? Even when the incoming query does not specify it needs to be traced? Lets say I get incoming que...

Answers: 1

Denodo Pagination: how to pass variable in "Offset for the next requests"
answered 18-02-2019 03:29:39 -0500

Hi team, How can I specify value for "Offset for the next requests" to populate dynamically based on value of parameter returned in response on page 1? Is there any way to pass parameter name instead of number?

Answers: 1

days function
answered 18-02-2019 01:05:21 -0500

Hi Team I am able to execute on DB2 but not on the Denodo , is am i missing something (days(current_date)-days(view_a.DATEOFBIRTH))/365

Answers: 1

VDB error on the combination of to_date and formatdate functions
answered 17-02-2019 23:36:32 -0500

Hi Team I am using following functions on a filed but i am getting the VDB error Statement to_date('YYYYMMDD',formatdate('YYYYMMDD',cust.dateofbirth)) Error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing cap...

Answers: 1

Join view OR Operator
answered 15-02-2019 10:08:42 -0500

Hi How to use OR operator in join condition my query looks like this bv_1.id = bv_order.id AND (UPPER(bv_code.CODETYPE) = 'ADMINISTRATIVEGENDER' **OR** bv_ce.C_CODE IN('4','5')) ERROR what i am getting currently The join condition is not vali...

Answers: 2

Are newer versions of subversion supported on Denodo 7
answered 15-02-2019 07:28:14 -0500

I noticed that the documentation refers to supporting Subversion 1.7. Our version of the CVS repository is slightly newer than that. Will it work correctly.

Answers: 1

VCS SVN

Create Base view from SQL query
answered 15-02-2019 07:24:08 -0500

Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...

Answers: 1

Denodo Express PostgreSQL Select Query

Windows services dependencies
answered 15-02-2019 06:58:24 -0500

Hi, is there a specific order or sequence that has to be kept in mind when starting the Denodo services on a Windows environment? Thanks in advance!

Answers: 1

windows