Q&A

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

Fetching columns from denodo with space in column names through informatica bdm
answered 29-01-2020 21:08:34 -0500

While selecting columns with space in column names from denodo , informatica bdm is throwing error as such a column doesnot exist.

Answers: 1