Q&A

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

Passing encrypted username and password to Denodo Web service
answered 28-02-2018 07:55:35 -0500

Hi, I'm trying to encrypt my Denodo VDP's username and password using encrypt_password.bat and passing it to a webservice on the browser. The encrypted creds doesn't seem to be working. Is there a way I can pass the encrypted string over the browser di...

Answers: 1

encrypt_password.bat

How to populate a column in the base view which is not present in the Datasource?
answered 28-02-2018 05:55:50 -0500

I am trying to populate a column in the base view with same value. For example I have manually added "Year" column in the base view which is not present in the Datasource. I would like to populate the Year column with 2018 for all records. How can I do...

Answers: 1

Base view DataSource