Xplenty can read data from your Heroku Postgres databases or write data to them. This article discusses providing Xplenty access on your Heroku Postgres database and then details creating the Heroku Postgres database connection in Xplenty.
You must provide Xplenty access to your Heroku Postgres database. If it is behind a firewall:
- Create a user and grant it minimum permissions required for Xplenty to read or write data from the database.
- Allow access from Xplenty's IP addresses to your Heroku Postgres database port (Refer to this article if you'd prefer to create an SSH tunnel or reverse SSH tunnel.)
To create a Heroku Postgres database connection in Xplenty
- Click the Connections icon (lightning bolt) on the top left menu.
- To create a connection, click New connection.
- Choose Heroku Postgres and name the connection.
- Select your access type (direct connection if you've whitelisted Xplenty's IP addresses.)
- Enter your Heroku Postgres database host name or IP address.
- Enter the database name.
- Enter the username
- Enter the user's password.
- Click Test Connection to make sure the connection details are correct.
- Click Create connection to create the connection.