Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Can we use the PostgreSQL database for the domain, Repository Service, and Model Repository Service?
Answer
Yes. Starting from Informatica 10.4.0 version, you can use the PostgreSQL database for the domain configuration repository, the Model repository, and the PowerCenter repository. 

For Enterprise Data Preparation, you can use the PostgreSQL database only on the additional Model Repository Service.

You can also install psql client application version 10.6 for PostgreSQL to work on Linux or Windows.
  • Like any other database, we support JDBC connectivity through datadirect drivers.
  • We use the below JDBC Connect string to connect to the PostgreSQL database:
jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=<database_name>​


More Information

Applies To
Product: PowerCenter; Data Quality
Problem Type: Installation
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:5/5/2020 2:31 AMID:609167
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)