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.
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.
NOTE: Heroku PostgreSQL does not support logical replication, so we must use the XMIN system column or Fivetran Teleport Sync for incremental updates. Because of this, for Heroku PostgreSQL connector, we don't recognize deleted rows in tables without a primary key. If you would like Heroku PostgreSQL to support logical replication, reach out to Heroku Support to let them know.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration