Latest Activity


Joining CTE using a LEFT JOIN in Postgres throw error

When using a left join to join a CTE in Postgres, we receive a column "does not exist" error. This error occurs when one or several of the columns in the CTE are not used in the joined query. When inspecting the Execution Trace and reviewing the Postgr...

CTE PostgreSQL left join


Why there are different ports assigned for JDBC (9999) and ODBC(9996)?

Generally there will be single port to which an application can connect from both jdbc as well as odbc. Why denodo is providing different ports for both?

PostgreSQL JDBC Denodo 7 ODBC Denodo 8 ODBC Denodo vdp jdbc driver


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


postgresql connecting C# application dotnet framework 4.5,npgsql 4.0.4

I have used postgresql to connect the denodo, And these are the connection properties ; Name : test DB adapter : PostgreSQL 10 Driver class path: PostgreSQL-10 Driver class : org.postgresql.Driver Databae URI: jdbc:postgresql://localhost:5432/test Tra...

C# PostgreSQL dotnet framework visual studio


How do I connect postgres DB in denodo?

How do I connect postgres DB in denodo? Could you please help on this,?



Unable to connect to Postgres server

Hi, Our team has been attempting to connect to our Postgres server on Denodo for awhile now, but it's still not budging at the moment. Our databases might be a bit more complicated in the sense that it needs to be accessed via a SSH tunnel. We've adju...



Denodo JDBC connector for PostgreSQL 11

Hi, I am trying to connect to a PostgreSQL 11 from Denodo 7.0, but the latest available JDBC driver seems to be for PostgreSQL 10. Does any of you know if there exists a JDBC connector for PostgreSQL 11 available in Denodo 7.0? If not, is it safe to us...

Denodo 7.0 PostgreSQL


Postgres ADDDAY translates, but other ADD datetime functions do not

We recently started using a Postgres connection in Denodo. We've noticed that on larger datasets (particularly in joins) that performance is impacted when using the ADDMONTH function. ADDMONTH can't be delegated to the data source since it's not a Post...

datetime PostgreSQL Date time function


PostgreSQL v 13.2 Database connector/JDBC drivers - When?

Hi there, I know it is very early on to be asking this question, but does anyone know by when the JDBC drivers for v13.2 of PostgreSQL will be available, or if they are already available, where to get them? At the moment the highest version in the se...

Denodo 8.0 Connector PostgreSQL JDBC Remote Tables


Connecting to Postgresql on EC2 Instance

Hi, I am trying to connect to a database "user" on a PostgresQL I set up on an EC2 instance. I believe I have allowed port 5432 on the inbound rules and I have modified the two config files. But I received this error message. Unable to establish c...

PostgreSQL EC2 instance AWS