To connect a Heroku instance to Chartio, you’ll need to retrieve the connection URL from your Heroku account.
- Log in to the Heroku Postgres interface.
- 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.
- Click the Settings tab.
Click Reveal Config Vars, copy the value for DATABASE_URL, and paste it into a text editor. The URL is in the following format:
Copy the individual values (username, password, hostname, etc.) from the DATABASE_URL and paste them into the data source connection form in Chartio.
Heroku wisely enables PostgreSQL SSL connections by default. Every data connection Chartio makes is encrypted this way.