heroku / roadmap

This is the public roadmap for Salesforce Heroku services.
189 stars 11 forks source link

Support the PostgreSQL Anonymizer extension #47

Open JoshReedSchramm opened 1 year ago

JoshReedSchramm commented 1 year ago

Required Terms

What service(s) is this request for?

Postgres

Tell us about what you're trying to solve. What challenges are you facing?

In order to maintain data privacy in production environments, while also supporting a production-like configuration for testing and troubleshooting - it would be helpful to have support for the PostgreSQL Anonymizer extension.

The ideal workflow would be to create a follower of our production database which would house a restored backup of production, but with anonymization rules applied via this extension.

Once in place data integrity on production can be better protected by limiting developer access to the anonymized lesser environments.

jbrown-heroku commented 1 year ago

Hi @JoshReedSchramm, Thank you very much for your suggestion. We will look into this. I see the value in this enhancement especially when you must have the dev-prod parity for testing phase. Only if you are comfortable to share, how do you usually get around this limitation today?

Also, do you currently use (or planning to use) Heroku Connect to integrate/sync Heroku and Salesforce org data?