This section provides you the details on various fields required to configure PostgreSQL server in Data Integrity Suite.
| Field | Description |
|---|---|
| Name | Specifies the name of data connection. This is a mandatory field. Example: SQLServerDataConnection |
| Description | Allows you to describe the purpose of this data connection. Example: Connection to the PostgreSQL Server database for financial reporting. |
| Agent to access data | Select the agent from the dropdown that connects to the database. It helps securely access data from your network. |
| Host name | Specifies the host name that can be Cloud Azure or on-premise server. This is a mandatory field. Example: sqlserver.company.com |
| Port number | Mention the port number to access the database server. The default value is 5432. This is a mandatory field. Example: 5432 |
| Database | Specifies the name of database to connect to on the designated host server. This is a mandatory field. Example: finance_db |
|
Advanced Options |
Allows you to configure the connector log level and specify additional connection parameters. The default value for Spatial is set to false, which disables the cataloging of spatial data. To use spatial data, set it to true. |