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.

Filter on a Rank function
answered 10-11-2017 05:17:08 -0500

Hi team! I'm facing a common scenario using the Rank function and need some help. Below is the sentence I'm using, basicaly a Rank function with a Partition and Order by conditions: rank() OVER ( PARTITION BY xx_fa_deprn_summary.asset_id, xx_fa_deprn...

Answers: 3

RANK Function #Analytic function

An I/O error occured while sending to the backend.
answered 10-11-2017 05:15:07 -0500

Hi Team Getting below error while executing a view. Also we've added a socketTimeout of 60 at Datasource level. An I/O error occured while sending to the backend. But same view is getting succeded if we run through GP DB. Pls Suggest.

Answers: 2

Does denodo 6.0 integrate with Oracle Access Manager
answered 09-11-2017 13:40:27 -0500

Hello, Can you integrated OAM with Denodo 6.0?

Answers: 2

Exalsol as Cache DB
answered 09-11-2017 07:22:24 -0500

I want to configure Exasol DB as a Cache Database. In the first step I configuare a normal JDBC-Datasource for the Exasol DB. That works. In the second step I configure a generic cache DB. I use the following parameters: Driver class Path: '/opt/deno...

Answers: 1

Exasol as Cache DB
answered 09-11-2017 06:35:47 -0500

I try to config Exasol as Cache DB. After I config the Connection Parameter and the cacheConfig-generic.xml I load a table in the cache. After a while I get this Message: Finished with error: Error executing query. Total time 1800.005 seconds. ZT_TAB...

Answers: 1

Read Data from SharePoint list
answered 09-11-2017 06:20:39 -0500

I want to read data from Sharepoint list, can anybody tell me the best way. Regards Amit

Answers: 1


JDBC connection error - DriverManager.getConnection
answered 08-11-2017 18:23:51 -0500

we are unable to establish connection using Denodo JDBC Connection through WebMethods. Connection conn = DriverManager.getConnection(URL, USER, PASS); connection error: unrecognized method hash: method not supported by remote object However, the call...

Answers: 2

Denodo 6.0 JDBC JDBC

Make input parameters optional when importing a SQL Stored Procedure
answered 08-11-2017 06:55:56 -0500

Hello, I have a Stored Procedure in SQL. I imported it into Denodo and made a RESTful service from it. Here I am seeing all the input fields as required in the service. I want to make all the input fields as optional and if I don't give any value to t...

Answers: 1

REST API Denodo Stored Procedure

DAOVDBProxy executeDeferred error
answered 08-11-2017 06:51:29 -0500

We are trying to connect to Denodo from a JDBC client but are getting the below error - com.denodo.vdb.jdbcdriver.dao.DAOVDBProxy.execueDeferred(DAOVDBProxy.java:448) We verified that the jar files are the same on both client and server. Can you pl...

Answers: 1

JDBC Data Sources

command to move table from one folder to another folder
answered 06-11-2017 05:02:51 -0500

Hi , is there a command to move tables T from x folder to y folder? I am aware of following solutions but looking for solution something with command: Already known soltuions: export vql from folder x and modify the Folder to point to Y and impor...

Answers: 4