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 create excel data source
answered 30-10-2017 07:57:55 -0400

I've a flat file. Could you pls explain me how to create excel data source & we're using Linux as Operating System. Thank you

Answers: 1

No Name in query execution plan
answered 27-10-2017 09:09:36 -0400

Hi Team, Thanks for your support. I have a dervied view which was comming like this. one base view "A" and another base view "B" i am joining these two on some column and final derived view "C" when I go for excution plan I am seeing "no name" as like ...

Answers: 5

Azure SQL Data Warehouse
answered 27-10-2017 08:46:11 -0400

Is there any well known way to integrate Denodo with EDW running on Azure SQL Data Warehouse?

Answers: 1

Data Source sql data warehouse azure

Order by Collation
answered 26-10-2017 08:51:56 -0400

Hi, guys. Could you please help me to set the order by collation properly in the following situation: there is a set of strings: with names as ( select 'Zoë' as name union all select 'Émilie' as name union all select 'Zsolt' ...

Answers: 1

Denodo Express installation GUI is too tiny
answered 26-10-2017 08:37:26 -0400

I'm trying to install Denodo Express on Windows 10. The GUI is too small to enter preferences, license file name, etc. I tried the 64bit install and the 32bit install. This reminds me of running certain games on a 4k HD monitor. Any help would be appre...

Answers: 1

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