Magento Business Intelligence Help Center

Connecting Heroku using the Postgres integration


Worried about the security of your data? Don’t be. Heroku encrypts data using SSL by default, so you can rest easy knowing your private data will stay private.

If you don't want to wait to have us help you connect your Heroku Postgres database, you can quickly do the setup yourself using the Postgres integration. This method doesn't require a lot of tech expertise - just access to your Heroku app - so you don't have to be a developer to get up and running. 

To connect your Heroku Postgres database to Magento BI, you’ll need to do a few things:

  1. Open the Postgres credentials page in Magento BI
  2. Retrieve your Heroku Postgres credentials
  3. Enter the connection info into Magento BI

To complete this process, you will need to open two browser windows or tabs - one for Magento BI, the other for your Heroku app.

Opening the Postgres credentials page in Magento BI

  1. Go to the Connections page under Manage Data > Connections.
  2. Click the Add a New Source button, located on the right side of the screen above the Data Sources table.
  3. Click the Postgres icon. This will open the Postgres credentials page.

Leave this open for now - we'll need it to complete the setup.

Retrieving your Heroku Postgres credentials

If you haven’t logged into your Heroku app yet, do so now. After you’re logged in, do the following to retrieve your Heroku Postgres database credentials:

  1. In the main dashboard section of the Heroku app, locate the Add-ons section. Add-ons will list any Postgres databases currently added to your Heroku account.
  2. Click the name of the database you want to connect to Magento BI.
  3. The credentials needed to connect to Magento BI will display in the Connection Settings section. To finish the setup, you’ll need the Host, Database, User, Port, and Password (click Show to display it).

Here’s a look at the credentials page:

Leave this open and switch back to the window with the Magento BI Postgres credentials page.

Entering the connection and user info into Magento BI

To wrap things up, we need to enter the connection and user info into Magento BI. Did you leave the Postgres credentials page open? If not, click Manage Data > Connections > Add a New Source, then click the Postgres icon.

Enter the information from the Heroku page into the appropriate fields to complete the setup:

  • Connection Nickname: Enter a name for the database connection. This is the name that will display on the dashboard next to the integration.
  • Host: The host address used by your Heroku instance
  • Username: The username associated with the database
  • Password: The password associated with the database
  • Port: The Heroku port (5432 by default)
  • Database Name: The database you want to connect to Magento BI. This is the Database field on the Heroku page.

Remember: Because Heroku Postgres uses SSL by default, you don’t need to take any further action to encrypt your data.

That's it! When you're finished, click the Save & Test button to complete the setup.


Was this article helpful?
0 out of 0 found this helpful


Powered by Zendesk