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 Administrator |
Before you begin:
- Review the IP addresses to make sure the PostgreSQL connection has the necessary access.
-
In Data Cloud, click Setup, and select Data Cloud Setup.
-
Under External Integrations, select Other Connectors.
-
Click New.
-
On the Source tab, select AWS RDS PostgreSQL, or AWS RDS Aurora PostgreSQL, or Azure PostgreSQL, and then click Next.
-
Enter a connection name, connection API name, and provide the authentication and connection details.
-
For Authentication Details, provide the username and password to authenticate the user.
-
For Connection Details, enter Connection URL that uses one of the formats listed next.
-
For AWS RDS PostgreSQL and AWS Aurora PostgreSQL, the URL format is
{section1}.{section2}.{section3}.rds.amazonaws.com{:port}
- Section 1 is 1–63 lowercase letters (a–z), numbers (0–9), or hyphens (-).
- Section 2 is 1–20 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
- Section 3 is 1–100 characters, including uppercase (A–Z) or lowercase letters (a–z), numbers (0–9), underscores (_), or hyphens (-).
- The port is optional. If included, the port is 4–5 numbers (0–9) and prefixed with a colon (:).
-
For Azure PostgreSQL, the URL format is
{hostname}.postgres.database.azure.com{:port}
- Hostnames are 1–63 lowercase letters (a–z), numbers (0–9), or hyphens (-). Hostnames can’t start or end with a hyphen.
- The port is optional. If included, the port is 4–5 numbers (0–9) and prefixed with a colon (:).
-
-
For Schema, enter the database schema the user’s access is limited to for this connection.
-
For Database, enter the PostgreSQL database for which the user's credentials are authenticated.
-
To review your configuration, click Test Connection.
-
Click Save.
After the connector details are accepted, the connection is created and listed under Connectors.
You can now create data streams.