Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

How to get file modified date for an excel file in FTP location
answered 30-01-2020 11:26:17 -0500

We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...

Answers: 2

File Modification Date

Is there a way to connect Denodo to Unix server non-interactively and use it as a data source
answered 30-01-2020 11:19:42 -0500

Hello, I need to connect Denodo to the specific folder on the Unix server, so I can use flat files as a datasource. Our security team only permits non-interactive login. Is there a way to connect Denodo to the Server non-interactive, and how that con...

Answers: 1

#connection #server #Unix

Denodo Scheduler authentication error
answered 30-01-2020 01:15:41 -0500

Hi, I can't execute a job in the scheduler because "dataSource 'PRE_CD2'. authentication error: The username or password is incorrect" I've configured in 'Data Sources > New Data Source > VDP' the PRE_CD2 which has the correct 'Connection URI' ...

Answers: 1