Set Up a Heroku PostgreSQL Connection

Set up the Heroku PostgreSQL connection to start the flow of data into Data Cloud.

User Permissions Needed 
To create a connection:System Administrator

Before you begin:

  • Verify your admin has enabled firewalls on the system you want Data Cloud to connect to by including these IP addresses to your allowlists.

  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 Heroku PostgreSQL and click Next.

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

    Learn more about the configuration details in the Heroku Postgres documentation.

  6. For the Authentication Method, username and password is the default. Enter these details to authenticate the user. In the dropdown, if you select mutual TLS based authentication, enter these fields.

    1. For SSL Root Certificate, provide the root certificate or the CA certificate file that authenticates the server.

    2. For SSL Client Certificate, provide the client's SSL certificate file that validates the client.

    3. For SSL Key, provide the client private key file.

  7. For Connection Details, enter these fields.

    1. For Connection URL, provide the PostgreSQL hostname and port.

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

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

  8. To review your configuration, click Test Connection.

  9. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.