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.

Denodo JDBC Connection Error
answered 06-03-2018 05:17:01 -0500

Hi Team, I have a JDBC connection to oracle DB and I took below table into Denodo. it was wokring fine at that time, but if try to run the same table\view in denodo later on (tomorrow), i am seeing the below error. but when i check connection, it was w...

Answers: 1

Certificate of Training
answered 05-03-2018 12:23:03 -0500

Hi, I completed on-demand Denodo DV Architect training today (03/04/2018). Under Achievement tab it is showing completed but I do not see any option of printing certificate or share on linkedIn. Please advise how can I get certificate of successful com...

Answers: 1

Custom Function Class Name
answered 05-03-2018 10:11:18 -0500

We need to built Custom function to get AWS Authorization Request Header . Before implementing custom function thought of check how the custom function need to be configured in denodo I have created Jar file out of Concat_SampleVdpFunction.java . I wa...

Answers: 1

Custom Functions

SOAP Request is returning full XML strings
answered 05-03-2018 05:52:09 -0500

Hi all, I am trying to use data from the National Oceanic and Atmospheric Administration’s SOAP web service as a source. I have been able to create the data source, see the operations and create base views. However, I don’t think their web service is s...

Answers: 1

SOAP Web Service

Denodo Union Performance issue
answered 02-03-2018 08:10:01 -0500

Hi Team, I have a base view "A" from DB1 and one more base view "B" from DB2 I am doing union in Denodo getting "C". while I am excuting "C" for one applicationid, it is taking more than 10 seconds to fetch the data, my original base views "A" and "B...

Answers: 1

selection queries cannot be delegated to the database using case clause from Hive
answered 02-03-2018 07:34:32 -0500

I have used full join between two tables and added the new column with sample case statement as CASE WHEN A IS NOT NULL THEN B WHEN C IS NOT NULL THEN D ELSE NULL end. If I see the query plan showing warning as selection queries cannot be delegated to ...

Answers: 3

Denodo and Hadoop

ReST API - cookie
answered 02-03-2018 00:52:55 -0500

We have ReST API which should returns cookie and value . Obviously we can capture the values thru the base view but how do we capture cookie as part of the result. Our idea is capture the Cookie value and use it as interpolation variable for the subseq...

Answers: 1

REST API REST

Using functions in parameter mappings in the Exporter section
answered 01-03-2018 11:50:10 -0500

I have defined a parameter mapping in my JDBC exporter. When trying to convert the field _$job_starttime to datetime I get the following error: Group0#JDBCExporter0: Document 1: Incorrect syntax near ')'. Is it not possible to use functions in the "D...

Answers: 1

Scheduler export

Folder level access
answered 01-03-2018 08:22:44 -0500

Hi Experts, I have couple of folders under my vdb. how can I grant write access to only one folder and other folders are read only access ? can you pls share any commmond or way to do that ? thnaks!

Answers: 1

vdb folder access

Similar Question to Location of keytab file for Kerberos authentication on windows server
answered 01-03-2018 05:32:50 -0500

The answer given to the question https://community.denodo.com/answers/question/details?questionId=90670000000L5RZAA0&title=Location+of+keytab+file+for+Kerberos+authentication+on+windows+server was not the best. Could the Denodo team please clarify...

Answers: 1

Kerberos Keytab