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

Interpolation variables ? How to add runtime query view in Denodo?
answered 31-10-2016 05:29:23 -0400

Hi I am new to Denodo .. i want to create a web service for my table’s join view, But how shall i pass the input values from my program which will call that web service to the Where clause of the query? how do i declare/use/;map the input data to my w...

Answers: 1

Interpolation Variables

Denodo extraction
answered 28-10-2016 21:08:41 -0400

We have a question in regards to running multiple Denodo extracts in parallel in production. In the past ( a few years back ) we attempted to run extracts simultaneously only to run into issues such as locked processes or incomplete extracts ( we specu...

Answers: 1

Denodo 5.5 extraction

empty dates in MySQL problem
answered 28-10-2016 19:21:22 -0400

I'm connect Denodo to a MySQL server. I have a table with datatime columns. Some of the values are empty, thich look like '0000-00-00'. These are not null values, these are empty values. It appears Denodo cannot handle these values and reports an error...

Answers: 1

mysql

Where to download npgsql driver
answered 28-10-2016 09:11:16 -0400

Not able to find any npgsql driver from the information available in the <DENODOHOME>/samples/vdp/Vdp-clients-ADO.NET directory. Can you suggest a way to get the npgsql driver . Also what is the dependency of entityframework for this implementa...

Answers: 3

Copy the certificate file for Hive
answered 28-10-2016 08:14:58 -0400

what location should the certificate file copied to. I am connecting from Denodo to Hive, i want to copy hive cert file.

Answers: 1

#hive #bigdata

Differences between default restful webservice and specially created ones
answered 27-10-2016 17:44:34 -0400

We are using Denodo to publish data for consumption by our java application via the REST interface. Is there any advantage to creating new web services in Denodo versus using the default denodo-restfulws? We are consuming the data as JSON, currently us...

Answers: 1

Denodo VQl server 5.5 service
answered 27-10-2016 12:53:56 -0400

Denodo VQl server 5.5 service is stopping even if we are starting service. We changed startup type of the service from automatic to manual and vice-versa but still issue persist.Kindly help

Answers: 1

data service

error in SQL
answered 27-10-2016 12:53:12 -0400

I am not getting desired results from below query group_concat(distinct product_type) e.g. if i have product_type cat, dog, cat Need to get cat,dog

Answers: 1

#VQL

Error in updating Denodo 5.5 update 20161024
answered 27-10-2016 12:01:36 -0400

Team, I am getting error while apply new patch (update 20161024) to Denodo 5.5. I have tried to update it from "Denodo 5.5 update 20160620 hotfix 20160714". I have also tried to update it from fresh installation. But each time it fails with same err...

Answers: 1

patch upgrade update

Additional trace settings
asked 26-10-2016 11:02:41 -0400

To see the LDAP search query the following trace setting should also be applied call logcontroller('com.denodo.vdb.engine.wrapper.raw.ldap.executor.LDAPExecutor', 'trace');

Answers: 0
Related to: LDAP authentication best practices