---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Create a PostgreSQL connection

# Create a PostgreSQL connection {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read  
Create a zero-copy connection to PostgreSQL to access relational database data in Zero Copy Connector Hub without moving or duplicating data.

## Before you begin

Role required: df_connection_admin

## About this task

Table statistics are enabled by default for PostgreSQL connections.{#create-postgresql-connection-zcc__create-postgresql-connection-zcc-context-1}

After you create this connection, data stewards can use it to create data fabric tables that map to PostgreSQL data sources. For additional information about connecting, see [PostgreSQL connector documentation](https://trino.io/docs/current/connector/postgresql.html).{#create-postgresql-connection-zcc__create-postgresql-connection-zcc-context-2}

## Procedure

1. Navigate to the available primary connectors in Zero Copy Connector Hub in one of the following ways:
   * Navigate to AllZero Copy Connector HubAvailable connectorsPrimary connectors.
   * Navigate to AdminZero Copy Connector HubAvailable connectorsPrimary connectors.
   {#create-postgresql-connection-zcc__choices_n5p_vrt_k2c}
2. Locate the PostgreSQL connector and select Connect.
3. Complete the connection form.  
   {#create-postgresql-connection-zcc__table_kmx_fw1_2fc__entry__2}

   | Field | Description |
   |-|-|
   | Name and description ||
   | Connection label | Unique name for this connection. This helps in identifying the connection within your system. |
   | Connection name | System-generated name based on the Connection label. This field cannot be modified once the connection is established. |
   | Short description | Description of the connection explaining what it is about. |
   | Connection attributes ||
   | Connection URL | JDBC URL to establish the connection. For example: <kbd class="ph userinput">jdbc:postgresql://&lt;host&gt;:&lt;port&gt;/&lt;database&gt;?sslmode=require</kbd> The `sslmode` parameter in the URL is optional. Setting SSL mode in the Connection security configurations section is the recommended approach; if you specify `sslmode` in the URL, it takes precedence over that setting. |
   | SSL | Option to enable or disable SSL for the connection. When Enabled, additional fields appear based on the selected SSL mode, Server Certificate Source, and Store type. See [PostgreSQL connection security configuration fields](https://www.servicenow.com/docs/YVeRg3LZP3opge549DPSyA "Fields that appear under Connection security configurations on the New PostgreSQL Connection form when SSL is set to Enabled.") for the complete conditional field set. |
   [Table 1. PostgreSQL connection form]

   {#create-postgresql-connection-zcc__table_kmx_fw1_2fc}
4. Configure the authentication method that you want to use with PostgreSQL.

   | Option | Description |
   | Basic | Option to use a username and password. 1. Enter the username associated with the source. 2. Enter the password associated with the username. {#create-postgresql-connection-zcc__ol_pg_basic} |
   | AWS IAM | Option to authenticate using AWS RDS IAM (temporary STS token-based) authentication. See [PostgreSQL authentication method fields](https://www.servicenow.com/docs/LLZ6MleA_1D5csioGtqIGA "Fields that appear on the New PostgreSQL Connection form depending on the selected authentication type.") for the specific fields (Database user, AWS region, AWS access key ID, AWS secret access key). |
   | GCP IAM | Option to authenticate using GCP Cloud IAM token-based authentication, with either a service account or user credentials. See [PostgreSQL authentication method fields](https://www.servicenow.com/docs/LLZ6MleA_1D5csioGtqIGA "Fields that appear on the New PostgreSQL Connection form depending on the selected authentication type.") for the specific fields (Service account key (JSON), Database user, GCP token scope). |
   | OAuth | Option to authenticate using Azure AD / Entra ID OAuth 2.0 (Resource Owner Password Credentials flow). See [PostgreSQL authentication method fields](https://www.servicenow.com/docs/LLZ6MleA_1D5csioGtqIGA "Fields that appear on the New PostgreSQL Connection form depending on the selected authentication type.") for the specific fields (OAuth credential type, Database user, Azure tenant ID, Azure client ID, Azure client secret, Azure token scope). |
   |-|-|

   {#create-postgresql-connection-zcc__choicetable_pg_auth}
5. Select Connect.

## Result

A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

## What to do next

If the connection succeeds, configure data steward access on the Access Control tab. See [Manage access to an established connection using roles](https://www.servicenow.com/docs/kr8mlJMAdWNHxVz4wmb78w "Manage which data stewards can access an established connection and create data fabric tables.").

If the connection fails, verify the connection details with your data source administrator and try again.
**Related reference**   

* [PostgreSQL connection security configuration fields](https://www.servicenow.com/docs/YVeRg3LZP3opge549DPSyA "Fields that appear under Connection security configurations on the New PostgreSQL Connection form when SSL is set to Enabled.")
* [PostgreSQL authentication method fields](https://www.servicenow.com/docs/LLZ6MleA_1D5csioGtqIGA "Fields that appear on the New PostgreSQL Connection form depending on the selected authentication type.")

*[\>]: and then