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 these fields.
-
For Connection URL, provide the PostgreSQL hostname and port.
-
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.