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

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Displaying VQL for all Data Sources in Denodo
answered 27-07-2018 05:35:28 -0400

DESC DESC VQL DATASOURCE source_name datasource outputs the VQL for the datasource in text format. Can we get this output in the query result? I'm getting datasource name and database name by calling the below procedure: 'call get_elements(null, nu...

Answers: 1

Unexplicable high total number of connections in Denodo? Numbers of idle and active do not add up? How to check / close connections?
answered 26-07-2018 17:50:16 -0400

In Denodo VDP server I see via the monitor a very high number of connections. Where do they come from? The numbers of idle and active do not add up to this number How can I close these connections? How can i manage the number of non-active, n...

Answers: 1

Connect to Tibco iProcess
answered 26-07-2018 16:00:43 -0400

Hello, I am using Denodo 6.0. Does this version of Denodo have the drivers to connect to the Tibco iProcess software.?

Answers: 1

tibco iprocess

Error 10061 ; WSAECONNREFUSED: Connection refused
answered 26-07-2018 05:49:29 -0400

Please help me know more about this error and how to resolve it.

Answers: 1

Need help from Denodo Team.
answered 26-07-2018 05:26:08 -0400

Hi Team, I need your help on Denodo side on "No Name in query execution plan" long back i was posted this question, I could not find any solution yet. Just wanted to know below. is there any way to send the screeshots or attachment to you guys to u...

Answers: 1

Received exception with message 'Incorrect syntax near 'AT'.'
answered 25-07-2018 16:54:17 -0400

can please some one point me what does this error mean. The same query works fine in DEV and fails in QA select *,FORMATDATE('yyyy-MM-dd', dob) Finished with error: Error executing query. Total time 0.273 seconds. DV_XXXX_name [VIRTUAL] [ERROR] DV_...

Answers: 1

How can I customize errors in REST API?
answered 25-07-2018 16:03:28 -0400

How can I customize error in Denodo's REST API? (Format:JSON) E.g. Insted of this error - {"name":"derived view name","elements":[],"links":[{"rel":"self","href":"http://ServerName:Port/server/dbname/apiname/views/derived_view_name?columnname=value"}]}...

Answers: 1

REST API

Develop Custom Data catalog using Virtual dataport
answered 25-07-2018 08:45:49 -0400

I wanted to check if it is possible to leverage virtual dataport to create a custom web based Data catalog to allow technical and business users query, search and browse data and metadata information stored in a Virtual DataPort using the Custom data c...

Answers: 3

Is paging possible in REST API?
answered 25-07-2018 01:36:33 -0400

I have created an REST API on Derived View which has 11 million records. Is paging possible in REST API? or Can I show REST API output in chunks, let's say on first page(chunck) it will show 10,000 records, next chunck will have 10,000 records and so o...

Answers: 1

REST API

Numbering of array elements in flatten()
answered 24-07-2018 19:43:57 -0400

Hi, I have a Denodo view "personaldata" with a column "addresses" containing an array of addresses. I created a flatten view like this CREATE OR REPLACE VIEW personaldata_addresses AS SELECT user_id, last_udpated, _updated AS address_last_updated, ...

Answers: 3