Please note that our Postgres destination is currently in open beta. The information in this article is subject to change.
In this tutorial, we'll walk you through connecting your Heroku Postgres destination to Stitch. Because Heroku is a cloud-based managed database service, spinning up an instance to connect to Stitch only takes a few minutes. No tech expertise required.
Note that the Heroku database you connect to Stitch must be an existing database. Stitch won’t create one for you. We’ll walk you through how to do this in this tutorial.
Connecting a Heroku Postgres destination is a three-step process:
In this first step, you’ll create a database in Heroku and wait for it to provision.
Don’t have a Heroku account?
Signing up for Heroku only takes a minute. Heroku has a variety of plans to choose from, including a Free option. Check out Heroku’s Choosing the Right Heroku Postgres Plan article if you need some help selecting a plan.
You can create an account here if you don’t have one already. Please contact Heroku if you have questions about their pricing, product features, or support.
Heroku will begin the database provisioning process, which can take a few minutes. The status of your database will change to Available in the Database Dashboard page when things are complete:
Next, you’ll locate the database settings in Heroku. This info will be used in the last section to connect Stitch to your Heroku Postgres destination.
Leave this page open for now - you’ll need it to wrap things up.
Stitch will perform a connection test to the Heroku Postgres database; if successful, a Success! message will display at the top of the screen. Note that this test may take a few minutes to complete.
If you receive an error message, we recommend:
If the errors persist, please reach out to support.
Now that your Heroku Postgres destination is up and running, we recommend learning about how Stitch will load and store your data in your data warehouse.
The Postgres Destination Overview doc is a good jumping-off point for learning about how Stitch handles nested data structures, certain data types, and more.