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.

Connection from Python to Denodo
answered 09-04-2019 08:29:33 -0400

Hello, I want to access data from denodo using python3. My code looks like the following: import jaydebeapi hostname = '####################' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '#####' password = '#####' path = '/home/I011404...

Answers: 7

Python

When will Denodo support analytic functions (i.e. RANK, NTILE, PARTITION BY....)?
answered 09-04-2019 08:27:40 -0400

When will Denodo support analytic functions (i.e. RANK, NTILE, PARTITION BY....)?

Answers: 12

Accessing from BI tools (Japanese Edition)
answered 09-04-2019 05:32:02 -0400

Hello, I installed Denodo Express 7.0 on Windows 8.1 Enterprise Japanese edition. (CPU:Intel Core i7-6600U CPU @ 2.60GHz 2.70GHz, RAM:20GB, 64bit) And I registered "DenodoODBC" (Unicode x64) with system DSN. My data source is MySQL5.5, and there are m...

Answers: 2

Error

VDP Indexer job with only restricted columns
answered 09-04-2019 04:11:32 -0400

We are using denodo 6 with Nov update currently. Is there a way to create a VDP indexer jobs but not index all the columns of the view, rather only select columns which are relavant to be indexed. The current Indexer jobs run for number of hours for us...

Answers: 4

Date conversion issue when the input date has month in 'MMM' format
answered 08-04-2019 19:01:56 -0400

I am trying to convert an input of format 03-Aug-2018 into date using the function to_date('dd-MMM-yyyy',03-Aug-2018') but it's returning NULL value. Where I am doing wrong in above function. I am executing this in Denodo Xpress (although I think it's...

Answers: 1

use Azure Data Lake as cache?
answered 08-04-2019 18:08:41 -0400

Azure Data Lake as source is clear to me: https://community.denodo.com/answers/question/details?questionId=9060g000000L756AAC&title=Azure+Data+Lake+Connection can it also be used for caching?

Answers: 1

cache azure

Denodo Client 5.5 & 6.0
answered 08-04-2019 12:07:39 -0400

Hi, Can i have 2 client versions on same server, we have Denodo 5.5 version install on citrix server other team use it to connect to denodo servers. Can i install Denodo 6.0 client on same machine? if yes what are thing to keep into conciderations? Ple...

Answers: 1

denodo client

Cannot START "Denodo Training QuickStart Virtual Machine.ova" in Oracle VM VirtualBox
answered 08-04-2019 09:02:29 -0400

Hi, I followed the steps from "installation and Configuration Guide" (Denodo Training QuickStart Virtual Machine) But in section "Launching DQVM", When I click START green arrow, I got this message: VT-x is not available (VERR_VMX_NO_VMX). Code d'err...

Answers: 1

VirtualBox Denodo Training QuickStart Virtual Machine OVA Virtual Machine

Ms-Access database connection for Lab - call_tracking
answered 08-04-2019 08:52:21 -0400

I am trying to connect to a MS ACCESS DB. I followed the instructions in the posts: https://community.denodo.com/answers/question/details?questionId=9060g0000000A0OAAU&title=Ms-Access+database+connection https://community.denodo.com/answers/questio...

Answers: 1

DESC VQL VIEW require Write Permission
answered 08-04-2019 08:43:08 -0400

May I know why "DESC VQL VIEW" require write permission

Answers: 1

Permissions