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

how to trim zero in in the Denodo Data
answered 26-10-2017 07:50:43 -0400

Hi Team, Please help me in below issue once. I have a column EMPID its has data in the below format 012345 045684 015484 014584 its starting with "zero", so i need to remove only "zero" mean I want data as below 12345 45684 15484 14584 I tried left tr...

Answers: 3

Class that implements XA Datasource in JDBC Client?
answered 26-10-2017 07:41:58 -0400

Is there a class that implements XA Datasource in the Denodo JDBC Client?

Answers: 2

JDBC

Data Architect
answered 26-10-2017 07:25:45 -0400

I tried to access the VDP in denodo express using the uid of admin and the pw of admin but i keep getting a connection error. connection refused error. can someone help?

Answers: 1
Related to: Denodo Platform Installation Guide

Access Denodo Express

Denodo User Name and User Description
answered 25-10-2017 09:13:29 -0400

Hi Team, When a user is created in VDP tool, there is a field "Description". Now "catalog permissions" view gives details of these users. Is there any way to find out user name along with the description which we gave while creating the user ?

Answers: 2

Role and User Management

Finished with error: No search methods ready to be run. The following fields are obligatory:
answered 23-10-2017 09:57:39 -0400

Hi, Created one customized Base view. On top of that created selection view with parameter (from view parameter option; Passed teh default value as well). In where condition pass this parameters like: "BV_fact_table"."TC_D_TXN_VALUE_AS_OF_DATE" >=...

Answers: 1

Denodo

Need to delegate the date column's data into two different databases-Hadoop and Oracle, but facing issue.
answered 23-10-2017 09:56:53 -0400

Hi Team, Scenario is like that: I have a Union View which is based on Hadoop+Oracle. Now, when I am mentioning any date condition like 'dd-MON-yy' (while executing), I am getting the result from Oracle but from Hadoop( Impala) I am not getting any re...

Answers: 1

DENODO

How to Delegate to_date function instead of to_timestamp into Oracle DB-at runtime
answered 23-10-2017 09:31:53 -0400

Hi, I created base view with interpolation variable (where expression) where I am passing “where” condition at runtime. But when I am passing the date value from denodo, from execution plan I do see the date value is converting to timestamp always and...

Answers: 3

DENODO

Getday/months function mask to two digits number
answered 23-10-2017 07:05:19 -0400

Hey denodo team, Is it possible to get a two digits number for those months that are lower to 10? I'm using the getday and getmonth functions to join both date fields (because they are on different times and I only want the date information). We use...

Answers: 3

Date Conversion Data Mask getday

Change user-agent in Denodo
answered 23-10-2017 03:21:53 -0400

Hi. I'm using Denodo Express (current version - June 2017) on my local machine for evaluation purposes. When I try to access web resources over http, I have the problem, that our proxy blocks the user agent that Denodo provides (MSIE 5.5; Windows NT5.0...

Answers: 1

Latest update available and its information
answered 23-10-2017 03:14:57 -0400

Hi team! Just a quick question, which is the latest update available for version 6 and where I can see the fixes/enhancements it contains? Thanks in advance! Best, Fabian

Answers: 1

patch upgrade update