Anonymization / Data masking for Azure Database for PostgreSQL

Question

Is there any tools working with Azure Database for PostgreSQL doing Anonymization and/or doing Data Masking ?

Is there a better way that this workflow :

1- Copy production DB (from Azure Database for PostgreSQL) via pg_dump,

2- Create Docker image with postgresql,use pg_restore to restore DB, use postgresql-anonymizer (apply Data Masking Rules) and create anonymized dump.

The goal is to have a production database dump anonymized for DEV/QA.

Thanks for your help

Answer 1

There are a number of tools out there that do exactly what you're looking for. My favorite is Tonic (full disclosure, I work there)