Documentation

Note: Heroku PostgreSQL is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Heroku PostgreSQL.

Description

‍Heroku PostgreSQL is an advanced open-source relational database management system. It offers ACID compliance, support for complex queries, and a thriving community contributing to its continuous development.

Follow our setup guide to connect Heroku PostgreSQL to Improvado.

Permissions

You should have write access to the database and the following permissions:

• CREATE
• ALTER TABLE
• SELECT
• INSERT
• DELETE

Complete configuration

On the Heroku PostgreSQL connection page, fill in the following fields:

1. 1Enter a name for your Destination connection in the Title.
2. 2Enter the Host.
3. 3Enter the Port.
4. 4Enter the User Name. Show more

5. 5Enter the Password.
6. 6Enter the Database Name.
7. 7Specify the Schema of your database.
8. 8(Optional) Upload your SSL Certificate to connect to Heroku PostgreSQL. Show more

9. 9Select the necessary Use static IP option from the dropdown. Show more

Table partitioning

A table loaded into the Heroku PostgreSQL database consists of data blocks called partitions, making it easier to manage and query your data. All these partitions form a Partitioned table that aggregates all data.

Learn more about table partitioning in Heroku PostgreSQL.