PostgreSQL

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2026

Follow the step-by-step instructions for configuring a data connection to PostgreSQL.

Data Connection Configuration

To connect to PostgreSQL, configure the following fields in your data connection setup:

Field Description
Name Specifies the name of the data connection. This is a mandatory field. Example: PostgreSQL DataConnection
Description Describes the purpose of this data connection. Example: Connection to PostgreSQL database for financial reporting.
Agent to access data Select the agent from the dropdown that connects to the database. This agent securely accesses data from your network.
Host name Specifies the host name (IP address or domain name) where the server is hosted. This is a mandatory field. Example: johndoe.company.com
Port number Enter the port number to access the database server. The default value is 5432. This is a mandatory field. Example: 5031
Database Specifies the name of the PostgreSQL database to which you want to connect. Example: sales_reporting_db
Authorization

There are two types of authorization available:

  • Regular: Provide the username and password.

  • Key Vault: Provide the username, select or add a key vault for secure storage, and password to secret path.
Encryption Type If you enable SSL/TLS encryption, then provide the host name in the certificate. You can also use the certificate provided by the server without verification.
Advanced options Available for cataloging purposes.

Replication Options

Field Description
Replication Engine Choose the replication engine.
Continuous Replication

  • Runtime engine name: Name of the data connection.

  • Description: Additional information about this data connection.

  • Agent: Choose between Continuous or Mainframe replication.

  • Hostname or IP address: Specify the host or IP address for replication.

  • Port number: Specify the port number for replication.

  • Alternate replication IP address: Provide an alternate IP address for replication, if required.

  • Data port number: Specify the data port number for replication.