How do I use Dataclips with Shield Heroku Postgres?

Issue

You cannot use Dataclips with Heroku Postgres instances running Shield plans.

Resolution

Shield database instances are designed specifically to only allow connections from your applications running in your Shield Private Space. That is why you cannot connect to them with Dataclips.

The one exception is the Mutual TLS (mtls) feature of Heroku Postgres. Dataclips does not support this, but you may be able to find another vendor that provides similar functionality and offers mtls support:
https://devcenter.heroku.com/articles/heroku-postgres-via-mtls

Just to clarify, you can use Dataclips for Private Heroku Postgres instances that are hosted in Private Spaces. Private-tier databases in Private Spaces also have additional protections compared to those in the Common Runtime. This article has a good overview of the features and differences between Private and Shield databases:
https://devcenter.heroku.com/articles/heroku-postgres-and-private-spaces

If you choose to use a Shield instance you also have the option of create an app inside your Space to provide Dataclips-like functionality. Unfortunately we don't have an official recommendation for what tool could do that. We recommend reviewing the Postgres wiki client list and seeing which options meet your needs and that you could install inside a Space:
https://wiki.postgresql.org/wiki/PostgreSQL_Clients

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2020 Salesforce.com