Database Application Interfaces

Database Application Interfaces

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 is an independent PostgreSQL development project and must be downloaded, installed and configured to connect to Greenplum Database. The following drivers are available:

Table 1. Greenplum Database Interfaces
API PostgreSQL Driver Download Link
ODBC psqlODBC Available in the Greenplum Database Connectivity package, which can be downloaded from https://network.pivotal.io.
JDBC pgjdbc https://jdbc.postgresql.org/. Also available in the Pivotal Greenplum Database connectivity package.
Perl DBI pgperl http://search.cpan.org/dist/DBD-Pg/
Python DBI pygresql http://www.pygresql.org/

General instructions for accessing a Greenplum Database with an API are:

  1. Download your programming language platform and respective API from the appropriate source. For example, you can get the Java Development Kit (JDK) and JDBC API from Oracle.
  2. Write your client application according to the API specifications. When programming your application, be aware of the SQL support in Greenplum Database so you do not include any unsupported SQL syntax.

    See the Greenplum Database Reference Guide for more information.

Download the appropriate PostgreSQL driver and configure connectivity to your Greenplum Database master instance. Greenplum Database provides a client tools package that contains the supported database drivers for Greenplum Database. Download the client tools package from Pivotal Network.