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.

how to use a interpolation variable in where condition of a derived view
answered 13-11-2018 06:21:11 -0500

Hi, I want to to pass a dynamic value as filter in where condition. I am try column1 =@input_value_for_column1 can you suggeset as why its not working, do we need to do anythign else to use interpolation variable or to pass the value dynamic in the w...

Answers: 1

Interpolation Variables

Denodo username and name of user with LDAP authentication
answered 13-11-2018 03:47:33 -0500

We are utilizing 7.0.20181011 with LDAP authentication. We are looking to improve our capability to monitor access permissions. We utilize the CATALOG PERMISSIONS() stored procedure but it shows only username (e.g. smithj), not the name of the user (e....

Answers: 1

#LDAP

How to create 2 different environments in one Denodo Platform installed?
answered 12-11-2018 19:48:32 -0500

Currently, I have a virtual database named "xyz" in Denodo 7.0. As per my project's requirement - I would like to replicate the same virtual database with a new name "xyz_staging" as I have only ONE Denodo platform installed. And, I would like to renam...

Answers: 1

Denodo 7.0 Environments

I want to substract numeric column from a date column and i'm using addday() fucntion
answered 12-11-2018 07:41:59 -0500

Hi, I want to substract numeric column from a date column and i'm using addday() fucntion as below- addday(xxbi_oe_order_lines_all_v.promise_date, mult (xxbi_oe_order_lines_all_v.delivery_lead_time,-1)) where 'xxbi_oe_order_lines_all_v.promise_date' ...

Answers: 1

Function

Ltpa token
answered 12-11-2018 07:35:05 -0500

Hi, i have to call a web service with ltpa token authentication, is possibile to do this with denodo? thanks.

Answers: 1

ltpa token

Join condition failing for text datatype in Denodo
answered 12-11-2018 04:55:22 -0500

Hi Team, Since Date function or datatype got deprecated in Denodo 7.0 I used some formatting in a coulumn in view name called A and got the desired value : "WED NOV 07 00:00:00 EST 2018" as required using, regexp(replace(cast(formatdate('EE MMM dd HH:...

Answers: 1

Denodo + Spark SQL
answered 12-11-2018 04:38:38 -0500

I had created spark conenction in denodo. Datbase Adapter: Spark SQL 1.6 Driver Class : org.apache.hive.jdbc.HiveDriver Database URI : jdbc:hive2://xyx.abc.com:10000 But while running queries;still the job is running on mapreduce. In yarn for the job...

Answers: 4

Spark-sql connection

unable to create VDPCache job in scheduler
answered 09-11-2018 13:29:47 -0500

Hello, I'm trying to create a VDPCache Extract job from scheduler in Denodo 7.0. I'm able to create a Datasource sucessfully, when I try to create a VDPCache job, I'm selecting a baseview from dropdown sucessfully and when I try to save the job it thr...

Answers: 1

Denodo 7.0 Denodo Scheduler 7.0 VDPCache

Connecting to Tableau, Connection Guide no longer exists
answered 08-11-2018 09:08:12 -0500

Hi, I am trying to setup a connection to denodo within my tableau v 10.5 . Seems like the documentation on how to do this is gone. https://community.denodo.com/kb/view/document/Connecting%20Tableau%20Desktop%20to%20Denodo?category=Northbound+Connecti...

Answers: 2

DENODO Tableau

In my Derived view there is one field message. it's return value in XML. How do I get some field from there?
answered 08-11-2018 06:32:44 -0500

In my message field I got ><ns2:ResponseDateTime>2018-09-20T14:10:26.607-04:00</ns2:ResponseDateTime>><ServiceName>test</ServiceName><ServiceRequestDateTime>2018-09-20T14:10:26.508-04:00</ServiceRequestDateTime&gt...

Answers: 3

VDP XML DENODO