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.

Cache invalid rows.
answered 04-12-2017 07:38:13 -0500

Hi guys, There is a situation when we created a view which uses two different data sources (db2 as/400 and ms sql server). Also this view has denodo parameter "IN_Role" with three values: 'DB2' - choose from db2 'MSSQL' - choose from ms sql ser...

Answers: 2

Cache error

Denodo JDBC Connectivity
answered 04-12-2017 07:16:37 -0500

We have identifed that Denodo JDBC is based on RMI. Do you have JDBC Drivers for version 6.0 without RMI.

Answers: 1

Denodo 6.0 JDBC JDBC

temporarily disable connection and related base views
answered 04-12-2017 07:07:22 -0500

We have a complex view stack with data that is pulled from several base views from different databases. One of the databases is going offline (that several base views are built off of) for a week and will not allow connections, thus this will cause our...

Answers: 1

calculation referring to previous row values
answered 04-12-2017 07:03:57 -0500

Hi, I am trying to create a Denodo view in VDP. Requirement is that a field value refers to previous records' field values. Example, Col1 Col2 Col3 10 25 10+25=35 35 5 35+5=40 40 30 40+30=70 70 7 70+7=77 In above, value of previous Col3 should get pop...

Answers: 2

#cyclic #calculated fields

Issue after updating Denodo License file in AWS Instance
answered 04-12-2017 01:38:52 -0500

Hello, I have chef automation script which installing Denodo and Updating license file which got expired with new one. The Denodo server is running in AWS Cent OS. In AWS Instance do we have any scripts which are Reinstalling / Resetting the environm...

Answers: 1

License File

Function similar to LISTAGG in Oracle
answered 01-12-2017 07:24:53 -0500

Hi Team, I am trying to create a VQL similar to an existing Oracle query. In one part of the query, LISTAGG is used. Is there any Denodo function avaliable similar to LISTAGG. Below is the sample oracle query: SELECT DISTINCT WHOLESALER_ID, LISTAGG(L...

Answers: 1

Associations in Denodo
answered 01-12-2017 05:01:00 -0500

Good Afternoon. Some questions looking for help. Can the associations be defined on base views only ? maybe on derived views ?! Can the associations be used to drill down ? for instance from a list of customers drill down to the rows showing thei...

Answers: 1

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

RANK Function
answered 30-11-2017 06:49:27 -0500

Can I use rank function to a csv data source?

Answers: 1

Job execution when Denodo Scheduler service is down
answered 30-11-2017 05:36:26 -0500

Hi Team, I have seen a scenario as below. Please guide if this is the expected behaviour. Denodo Scheduler 5.5 When Denodo Scheduler service is down- • Auto scheduled jobs do not run, • But, login and manual execution of jobs can be done Thanks.

Answers: 4

denodo scheduler