User Guide : Map Connectors : Source and Target Map Connectors : PostgreSQL (ODBC 3.x)
 
Share this page                  
PostgreSQL (ODBC 3.x)
PostgreSQL is an open source object-relational database management system (DBMS). It has been derived from the original POSTGRES database management system, a DBMS research prototype. PostgreSQL retains the powerful data model and rich data types of POSTGRES and replaces the PostQuel query language with an extended subset of SQL. The PostgreSQL Global Development Group website includes PostgreSQL documentation, FAQ, news, and a user forum.
The integration platform reads and writes PostgreSQL (ODBC 3.x) data.
PostgreSQL ODBC Driver Download
Go to the PostgreSQL web site and click the Downloads link to download the appropriate ODBC driver. After the download is complete, go back to the web site and click the Documentation link for instructions on configuring the driver. (In addition to the expected documentation on their product, PostgreSQL also posts notes from users of PostgreSQL that are invaluable.)
Installing Drivers and Troubleshooting Connections
Installing an ODBC Driver
Oracle Connectivity Guidelines
Note:  The integration platform connects to PostgreSQL tables with ODBC 3.x. For the procedure, and information about the property options, limitations, and source and target schemas, see ODBC 3.x.