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.

Run a query in a JOB to create a table
answered 22-05-2019 20:54:44 -0400

I read data from different datasources (EXCEL), and I do a complex process to get a final result. In the middle of this process I created a materialized table, to improve the performance of the process. I have a job in the scheduler, that get data fro...

Answers: 1

Job scheduler materialized table

Get rows with a minimum value from a column
answered 22-05-2019 20:54:11 -0400

I have a view, and for example, the output is: ID Name City Priority 1 John London 2 2 John Paris 1 3 Jane London 4 4 Jane Berlin...

Answers: 2

MIN function

While connecting thru JDBC to Oracle 12c Could not initialize class oracle.jdbc.driver.DMSFactory
answered 22-05-2019 20:53:51 -0400

Hello Experts, While I try connecting to Orcale 12c, I am getting the error "Could not initialize class oracle.jdbc.driver.DMSFactory". Error details below, please note this is first time installed Denodo and trying connect to Oracle db. Details belo...

Answers: 1

Oracle 12c Oracle DB connection Issue

Downloading custom wrapper
answered 22-05-2019 12:44:12 -0400

Hi, I have installed denodo free trail and wanted to connect to s3. It lloks like I need to download custom wrapper from support.conodo.com. But I get the error message as I don't have the licence to perform this task.

Answers: 1

aws free-trial

Data Catalog multi view
answered 22-05-2019 11:50:24 -0400

Hi, We have a question on Dendo 7 Data Catalog. Does “Data Catalog” tool support querying data across multiple views or user can only query on a single view at a time like how it used to be with ISS (information self service tool in denodo 6). It woul...

Answers: 1

data catalog

Query history in vdp
answered 22-05-2019 08:21:57 -0400

Hi, When using the vdp client, we tend to open multiple query windows but looks like the query history doesn't sync up in differnt shells. It should be standard that all the queries that are run should be showing in all the execution logs. Is there a...

Answers: 1

DenodoExpress Quickstart Guide
answered 22-05-2019 08:00:54 -0400

I have been trying to set up environments for labs on Virtual Machine. But since there are a few guides to follow, I am a little confused about it. So I would appreciate it if anyone could answer the following questions. 1.Where can I download the Den...

Answers: 1

QuickstartGuide

How to access Denodo Base view in SQL server?
answered 21-05-2019 20:35:07 -0400

I created base view in Denodo from mutiple source like oracle and other sorces. How can i access the baseview from SQL?

Answers: 1

bas DENODO API SQL base

Schedular administration tool not starting
answered 21-05-2019 06:30:52 -0400

Hi iam installed ssl in denodo local server .ala servers started properly but schedule administration tool was not going to start. give me proper solution Thanks

Answers: 1

Optimization denodo
answered 20-05-2019 14:15:17 -0400

Is there any option in denodo like SQL developer (Query optimizer option) if I supply an sql ,denodo will be showing the areas of improvement for that sql on areas of performance . For example if the query is a taking a specific plan and if the same qu...

Answers: 1