Latest Activity


Connect to SQL Server Stored Procedures in Denodo

Need help on connecting to SQL Server Stored Procedures in Denodo and then access it in PowerBI Desktop.



Intermittent Failure of Base View with Timeout

We have a view that works sometime, retrieves the selected sql table and delivers, then, at random times, takes over 5min and times out with a failure. The name of the view that fails to complete contains the phrase: perf_updown_capture_chart_5yr. The ...



Oracle SQL Developer Data Modeler to Denodo

Hi All I need to export a file from Oracle SQL Developer Data Modeler and import on Denodo VDP. Is this possible? And if it is possible how can i do it? It would be great help if some one could help us on this. Thanks

Oracle SQL


Connecting MS SQL Server through Denodo Testing tool throws error.

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.jdbcUrl=jdbc:sqlserver://sqlsrv-;databaseName...

SQL Server SQL


How do i connect the sql /postgres database with this c# application?

How do i connect the sql /postgres database with this c# application? Could you please help me on this? I couldn't find the way to connect postgres and denodo. I used microsoft sql server management studio 2014 to connect the denodo, and I connecti...

C# PostgreSQL SQL


LIMIT not working in a subquery .

I'm trying to execute the following query : SELECT * FROM (SELECT * FROM Connections LIMIT 1000) AS T LIMIT 1; But its giving the following error : Exception parsing query near 'LIMIT' . Can someone help ? OR suggest any alternative working way of ...

JDBC Query limit SQL


No suitable driver exception when trying to connect using Jmeter

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to se...



The following fields are obligatory in the view 'view_name' : field_name

Hi Denodo Team, When I am trying to run a select query from java (through jdbc connectivity) on one of my view in denodo, I am having an issue in getting result. It is throwing the error : SQL state [HY000]; error code [31002]; No search methods ready...

Base view DENODO SQL


Unable to Query views with individual columns in select query

Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...



Mismatch in arithmetic operation result

Hi all, I am facing an issue for which i can't come up with an explanation. Hopefully I can find some help here in the community. I am pulling up data from SQL server, using multiple tables to create a new field in denodo. I am doing the same in SQL ...