Heroku PostgreSQL

Prerequisites

  • An active Heroku account with an active PostgreSQL database instance.

Obtaining PostgreSQL Database Credentials

  1. Log in to your Heroku account.
  2. Select the app containing the PostgreSQL database and open the databases dashboard.
  3. Access the DATA tab and click on the PostgreSQL database you want to use.

    Heroku db

  4. Click Settings, and then, View Credentials.

  5. Use the credentials provided below while setting up your Heroku PostgreSQL Source in Hevo.

Limitations

  • Heroku does not support log-based replications. Hence, all modifications to records, including inserts, updates, and deletes, must be explicitly mentioned to be captured.

  • Hevo supports only Table and Custom SQL Pipeline modes for Heroku PostgreSQL.

Last updated on 26 Oct 2020