Q&A

DECLARE CACHE CLUSTER INDEX in MSSQL 2017 ignored?
answered 01-08-2019 16:43:25 -0400

We are utilizing Denodo 7.0.20181011 and MS SQL Server 2017 for our cache database. The cached tables are always getting created with non-clustered indexes regardless of view index settings. The cache indexes are set to be the same as the view indexes....

Answers: 2

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