In this chapter we will examine several third party tools you may find useful when creating OpenRPT report definitions. The tools can also be helpful to system administrators responsible for maintaining xTuple databases and/or other PostgreSQL databases.

The first tool we will look at is pgAdmin III, an open source database administration utility for PostgreSQL. Next we will look at the ODBC driver available for PostgreSQL. We will show you how to install and configure an ODBC connection from a Windows client to a PostgreSQL database. Finally, we will examine how a query tool can be used to generate SQL that can then be copied and pasted into an xTuple report definition query source to accelerate the development of a new report.