Set Up a PostgreSQL Connection

Create a PostgreSQL connection using one of the PostgreSQL connectors to bring in data into Data Cloud.

User Permissions Needed 
To create a connection:System Admin profile or Data Cloud Architect permission set

Before you begin:

  • Review the IP addresses to make sure the PostgreSQL connection has the necessary access.

  1. In Data Cloud, click Setup, and select Data Cloud Setup.

  2. Under External Integrations, select Other Connectors.

  3. Click New.

  4. On the Source tab, select AWS RDS PostgreSQL, or AWS RDS Aurora PostgreSQL, or Azure PostgreSQL, and then click Next.

  5. Enter a connection name, connection API name, and provide the authentication and connection details.

  6. For Authentication Details, provide the username and password to authenticate the user.

  7. For Connection Details, enter Connection URL that uses one of the formats listed next.

    1. For AWS RDS PostgreSQL and AWS Aurora PostgreSQL, the URL format is {section1}.{section2}.{section3}.rds.amazonaws.com{:port}

      1. Section 1 is 1–63 lowercase letters (a–z), numbers (0–9), or hyphens (-).
      2. Section 2 is 1–20 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
      3. Section 3 is 1–100 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
      4. The port is optional. If included, the port is 4–5 numbers (0–9) and prefixed with a colon (:).

    2. For Azure PostgreSQL, the URL format is {hostname}.postgres.database.azure.com{:port}

      1. Hostnames are 1–63 lowercase letters (a–z), numbers (0–9), or hyphens (-). Hostnames can’t start or end with ‌a hyphen.
      2. The port is optional. If included, the port is 4–5 numbers (0–9) and prefixed with a colon (:).

  8. For Schema, enter the database schema the user’s access is limited to for this connection.

  9. For Database, enter the PostgreSQL database for which the user's credentials are authenticated.

  10. To review your configuration, click Test Connection.

  11. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors.

You can now create data streams.