To connect a Heroku instance to Chartio, you’ll need to retrieve the connection URL from your Heroku account.

  1. Log in to the Heroku Postgres interface.
  2. You should see a list of your Apps. Click on the App that corresponds to your database; it will likely have the same name as your database.
  3. Click the Settings tab.
  4. Click Reveal Config Vars, copy the value for DATABASE_URL, and paste it into a text editor. The URL is in the following format:

     postgres://username:password@hostname:port/database_name
    

    Click Reveal Config Vars

  5. Copy the individual values (username, password, hostname, etc.) from the DATABASE_URL and paste them into the data source connection form in Chartio.

    Config Variables

Security

Heroku wisely enables PostgreSQL SSL connections by default. Every data connection Chartio makes is encrypted this way.