Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

PostgreSQL Database Requirements

PostgreSQL Database Requirements

Use the following guidelines when you set up the repository on PostgreSQL:
  • Use a JDBC connection to connect to the PostgreSQL database.
    Informatica installs a DataDirect JDBC driver for PostgreSQL that you can use to connect to the database. Find the driver in the
    clients/DeveloperClient/infacmd
    installation directory, and copy the driver to the
    clients/externaljdbcjars
    directory .
  • Specify the database schema name. Do not leave the schema name blank.
    If the database uses the default PostgreSQL schema name of
    public
    , you can specify
    public
    as the schema name.
  • Verify that the database user has the CONNECT and CREATE TABLE privileges.