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: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

PostgreSQL Requirements (Ref Data Database)

PostgreSQL Requirements (Ref Data Database)

Use the following guidelines when you set up the database on PostgreSQL:
  • Use a JDBC connection to connect to the PostgreSQL database.
    JDBC V2 connection is not applicable.
    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 .
  • By default, PostgreSQL uses
    public
    as the schema. If you intend to use a schema other than public, ensure to set the new schema as the default schema of the database.
  • Verify that the database user has the CONNECT and CREATE TABLE privileges.


0 COMMENTS

We’d like to hear from you!