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.
Note: The integration platform connects to PostgreSQL tables using ODBC 3.x. For the procedure, and information about the property options, limitations, and source and target schemas, see
ODBC 3.x.
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
Connector Parts
Connector parts are the fields you configure to connect with a data source or target. The fields that are available depend on the connector you select.
For a list of all parts for source connectors, see
Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see
Specifying Target Connector, Parts, and Properties.
Last modified date: 10/22/2024