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 September 2019.

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 it required to apply latest patch on denodo monitor server
answered 03-02-2020 07:28:28 -0500

Hi Team, We have apllied latest denodo server patch update with 20190903,we need to apply same patch on denodo monitor?,If yes can you please provide the steps to update our denodo server running on linux system

Answers: 1

Essbase single sign on
answered 03-02-2020 07:24:27 -0500

Is it possible to establish a singe sign on connection to essbase from denodo? If yes, do we have the documentation for it?

Answers: 1

hyperion essbase Single sign on

Error accessing the metadata while loading/storing objects
answered 03-02-2020 00:34:31 -0500

I have created a job in the scheduler for loading the oracle transcodification tables and while executing I am getting error as "Error accessing the metadata while loading/storing objects". Please help on this.

Answers: 3

Joining Large Tables
answered 31-01-2020 19:35:22 -0500

There are 11 views in the join. Out of which, six views have rows in the range of 33 to 84 Million. 2 views in the range of 2 to 4 million and the remaining 3 in the range of 220 to 850K rows. It is all simple joins between tables, but due to the size,...

Answers: 1

DB2

Date Range function does not work in path configuration
answered 31-01-2020 19:04:14 -0500

Based on this documentation: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources When I try to put this in the file path of the data source: C:\Users...

Answers: 1

DateRange Date

Connection to Business Objects
answered 31-01-2020 18:51:49 -0500

I"m having trouble setting up a connection from Business Objects to Denodo, was hoping someone could help me. I installed the Denodo driver on the server and created a connection. After publishing a universe I get an error when trying to create a repor...

Answers: 1

Denodo Express Support - Odata
answered 31-01-2020 08:33:53 -0500

Does Denodo Express support odata? If so how do I publish?

Answers: 1

OData

Refresh the views using vql.
answered 31-01-2020 02:26:07 -0500

I used GET_SOURCE_CHANGES() for getting the changes. But is there a way i can make that changes automatically either using vql or any other way. Right now i got the list of changes and i have to go and manually refresh the views. i have to just auto...

Answers: 1

VQL Source refresh

Oracle DB enforce parallelism
answered 31-01-2020 01:53:34 -0500

Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually an...

Answers: 1

performance parallel JDBC Oracle DB connection Issue

Query Takes Longer Than Usual
answered 30-01-2020 20:43:34 -0500

I am running Denodo Virtual DataPort Administration Tool using a Virtual Machine. When I combine the data using a join method and retrieve all the rows from the join, it takes approximately 24 minutes to return ~6.6M rows. I have attached the Tree View...

Answers: 1

Query Speed