Database Application Interfaces
You may want to develop your own client applications that interface to HAWQ. PostgreSQL provides a number of database drivers for the most commonly used database application programming interfaces (APIs), which can also be used with HAWQ. 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 HAWQ. The following drivers are available:
|API||PostgreSQL Driver||Download Link|
|ODBC||pgodbc||Available on Pivotal Network.|
|JDBC||pgjdbc||Available on Pivotal Network.|
General instructions for accessing a HAWQ 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 Sun.
- Write your client application according to the API specifications. When programming your application, be aware of the SQL support in HAWQ so you do not include any unsupported SQL syntax.