Heroku Setup Guide
Heroku is a fully managed container-based cloud platform, with integrated data services and a powerful ecosystem, for deploying and running apps. The Heroku developer experience is based on an app-centric approach to software delivery, and integrates with today's most popular developer tools and workflows.
Setup instructions
Find host and port
- Log in to your Heroku app.
- In the dashboard, go to Add-ons.
- Click on the PostgreSQL database to which you have connected Heroku.
- In the Connection Settings section, find the Host and Port and make a note of them. You will need them to configure Fivetran.
Configure client certificate (optional)
Fivetran supports connecting with a client certificate if you connect through either private networking or connecting directly.
Heroku PostgreSQL supports client certificate authentication for Private or Shield instances.
Follow the instructions in the Heroku PostgreSQL docs to create a client certificate.
Finish setup
Heroku is built on PostgreSQL. To integrate Heroku with Fivetran, follow either our Generic PostgreSQL setup guide or our Amazon RDS for PostgreSQL setup guide.
Heroku PostgreSQL doesn't support the Logical replication method, so you must use the Query-Based method for incremental updates. You can contact Heroku Support to request logical replication support in Heroku PostgreSQL.