Latest Activity

code

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.

SQL

code

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 ...

SQL

code

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

code

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.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

SQL Server SQL

code

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

code

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

code

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...

Jmeter JDBC AWS SQL

code

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

code

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...

JDBC query JDBC SQL

code

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 ...

DENODO SQL