Database Application Interfaces
You may want to develop your own client applications that interface to WarehousePG. PostgreSQL provides a number of database drivers for the most commonly used database application programming interfaces (APIs), which can also be used with WarehousePG. 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 WarehousePG. The following drivers are available:
| API | PostgreSQL Driver | Download Link |
|---|---|---|
| ODBC | EDB ODBC Connector | EDB Connectors page |
| JDBC | EDB JDBC Connector | EDB Connectors page |
| Perl DBI | pgperl | https://metacpan.org/release/DBD-Pg |
| Python DBI | pygresql | http://www.pygresql.org/ |
| Python DBI | psycopg2 | https://www.psycopg.org/ |
| libpq C Library | libpq | https://www.postgresql.org/docs/12/libpq.html |
Note
While WarehousePG is compatible with community PostgreSQL drivers, EDB recommends using the EDB ODBC Connector or the EDB JDBC Connector for production environments. These drivers are specifically optimized for EDB-supported Postgres distributions, including WarehousePG, and ensure full compatibility with enterprise security and performance features.
General instructions for accessing a WarehousePG with an API are:
- 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.
- Write your client application according to the API specifications. When programming your application, be aware of the SQL support in WarehousePG so you do not include any unsupported SQL syntax.
Download the appropriate driver and configure connectivity to your WarehousePG coordinator instance.
Parent topic: Accessing the Database
Could this page be better? Report a problem or suggest an addition!