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.

Is there an 'Execute Current Statement' feature?
answered 01-08-2019 09:36:03 -0400

If I have a script containing multiple queries, how can I run just the current statement? That is, execute the statement within which my cursor is placed. I have found this feature very helpful in the past when working with other data studios. I under...

Answers: 1

Unexpected Error Denodo Diagnostic & Monitoring Tool.
answered 01-08-2019 07:32:05 -0400

Hi, I have two Denodo servers, when I access to Denodo Diagnostic & Monitoring Tool from CD2 to CD1, I have information but when I access from CD1 to CD1 Denodo Diagnostic & Monitoring I always get the error "Unexpected error updating server" ...

Answers: 1

Denodo Diagnostic & Monitoring Tool

VDP Server shows "Started" even after fresh Install of Denodo 6.0
answered 01-08-2019 07:20:02 -0400

I have newly installed Denodo 6.0 on my Windows 10 64 bit laptop, and updated to 20190422. When I launch Denodo Control center it shows "Stop all servers" meaning some server is running already. As soon as I start the Virtual DataPort it shows the V...

Answers: 3

VDP administration connection error

Update view descriptions and columns descriptions Automatically
answered 01-08-2019 04:51:58 -0400

I have about a 100 views with a combined 1000 columns. I have descriptions for both the views and columns, but I do not want to manually update the descriptions in Denodo using edit and pasting each description in one by one. Is there another way? Qu...

Answers: 1

DATA Quality features in Denodo
answered 01-08-2019 01:38:16 -0400

Hi , We are trying to explore the below features of Denodo and could you please help us on configuring the below in the application. If there are any documents available on this would be helpful. DATA QUALITY • Library of transformation, filter and m...

Answers: 1

#dataquality

XML Datasource unable to "Create Base View"
answered 31-07-2019 10:03:39 -0400

Followed the following: Created & Saved XML datasource with "GET" method for external "HTTP Client" url, with Proxy as "Default" and Authentication as "Basic" and provided correct userID and Password. I am able to Save and do test connection succes...

Answers: 4

XML Baseview end tag

Denodo MPP evolution and new upcoming Cloudera?
answered 31-07-2019 09:59:01 -0400

Hello, Soon the new Cloudera will be released in favor of Hortonworks/Old Cloudera. How will Denodo integrate with these? Will there be any kind of evolution/communication about this? I could imagine that the new approach to big data would allow for ...

Answers: 1

Denodo custom function
answered 31-07-2019 09:54:37 -0400

Hello, Is it possible to create a custom function in Denodo that can be registered for push down to certain JDBC data sources? Let's say there is a special existing function or stored procedure created in one of our data sources that I want to m...

Answers: 1

exception parsing query near 'insert'
answered 31-07-2019 07:52:47 -0400

I have an issue with several MicroStrategy reports running against Denodo interfaces. These reports were previously working, but now when trying to run them they are failing. These reports have multiple metrics that are creating temp tables, inserting ...

Answers: 1

Microstrategy

Expose entire database schema/model via denodo data catalog
answered 31-07-2019 07:49:35 -0400

Hello, for a certain use case we would like to expose all tables in a SQL server database schema via Denodo (because of the rights management & catalog functionality). Is there a recommended way (VQL) to import with associations & descritpion...

Answers: 3