JDBC database connection error from Pentaho (org.postgresql.Driver)

[Jacques Blaauw]

Good day,

I'm trying to connect to an Open-Source Greenplum database using Pentaho.

I'm getting the error below. 

1. I'm assuming this driver is not available in the Open-Source version; is this correct?
2. If point 1 is correct, is there an alternative driver I can use to connect to the database?

2024/01/23 09:27:56 - Get_Config_Parameters.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : An error occurred, processing will be stopped:
2024/01/23 09:27:56 - Get_Config_Parameters.0 - Error occurred while trying to connect to the database
2024/01/23 09:27:56 - Get_Config_Parameters.0 -
2024/01/23 09:27:56 - Get_Config_Parameters.0 - Error connecting to database: (using class org.postgresql.Driver)
2024/01/23 09:27:56 - Get_Config_Parameters.0 - No suitable driver found for jdbc:postgresql://${gp_db_server}:${gp_db_port}/${gp_db_name}

Kind regards,

Jacques

[Joe Manning]

Hi.

I would suspect that there is a version incompatibility between the Driver you are using and the version of Greenplum.

What version of Greenplum are you connecting to?

Joe Manning
Technical Support  |  Tanzu Support
Broadcom

Parnell House, Barrack Square, Ballincollig, Co. Cork | P31 TX92 |  Ireland

joe.m...@broadcom.com   |   broadcom.com

--
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-dev+u...@greenplum.org.

This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.

[Jacques Blaauw]

Thank you, Joe, you were correct.