Q&A

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

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

Build POC (proof of concept)
answered 14-02-2019 13:39:40 -0500

Good morning, SCAI Finance is a Denodo partner. We need to build a simple proof of concept (POC) that does the following: through an operator interface (which is the subject of my request) I would like to see a report I built with Denodo (the data mode...

Answers: 1

POC

Query to get the execution as output
answered 14-02-2019 12:56:21 -0500

Select * from view_name trace is giving me the query output which is the view data but I’m unable to get the execution trace as data. Please hlp me to get the execution trace or EXECUTION PLAN() as output so that I can redirect the same to a file for f...

Answers: 1