Private Connect for Heroku Postgres
This topic covers setup information specific to the data provider. General information on setting up a private connection is in Private Connection Set Up: Overview, and information on setting up the Tableau Cloud endpoint is in Private Connection Set Up: Tableau Cloud.
Note: There isn't a dedicated web authoring connector for Heroku Postgres. To connect to Heroku Postgres, end users use the connection address from the private connection with the standard Postgres connector.
Prerequisites
- A Heroku app running in a Private Space or Shield Private Space with an attached Heroku Postgres database.
- Your Tableau Cloud site and Heroku Postgres database must be in the same AWS region. For a table that includes Tableau Cloud pods and associated regions, see IP Addresses for Tableau Cloud(Link opens in a new window).
- The Heroku Postgres endpoint has been provisioned. See steps 1-3 of Provision the Heroku Postgres endpoint(Link opens in a new window).
Tableau Cloud Information for the Data Provider
To get the account number that's required to provision the Heroku Postgres endpoint:
- Log in to Tableau Cloud Manager (TCM).
- Go to Settings.
- Select the Private Connect tab.
- Expand IAM Regions and ARNs.
- Find the region for your Tableau Cloud site.
- From the IAM ARN column, copy only the account number and resource information in the ARN. For example, if the complete ARN is
arn:aws:iam::012345678910:role/tab-private-connect, copy012345678910:role/tab-private-connect.
Data Provider Information for Tableau Cloud
See Step 4: Obtain Your Endpoint’s Service Name(Link opens in a new window) (in Heroku's "Connecting to Heroku Postgres in a Private or Shield Space via PrivateLink" help topic) to get the endpoint service name needed for the Tableau Cloud Create Private Connection dialog.
