You may want to develop your own client applications that interface to Greenplum Database. PostgreSQL provides a number of database drivers for the most commonly used database application programming interfaces (APIs), which can also be used with Greenplum Database. These drivers are available as a separate download. Each driver (except libpq, which comes with PostgreSQL) is an independent PostgreSQL development project and must be downloaded, installed and configured to connect to Greenplum Database. The following drivers are available:
API | PostgreSQL Driver | Download Link |
---|---|---|
ODBC | Greenplum DataDirect ODBC Driver | https://support.broadcom.com/group/ecx/productdownloads?subfamily=VMware%20Tanzu%20Greenplum%C2%AE. |
ODBC | psqlODBC | https://odbc.postgresql.org/ |
JDBC | Greenplum DataDirect JDBC Driver | https://support.broadcom.com/group/ecx/productdownloads?subfamily=VMware%20Tanzu%20Greenplum%C2%AE |
JDBC | pgjdbc | https://jdbc.postgresql.org/ |
Perl DBI | pgperl | https://metacpan.org/release/DBD-Pg |
Python DBI | pygresql | http://www.pygresql.org/ |
libpq C Library | libpq | https://www.postgresql.org/docs/9.4/libpq.html |
General instructions for accessing a Greenplum Database with an API are:
Download the appropriate driver and configure connectivity to your Greenplum Database master instance.
Parent topic: Accessing the Database