DATPROF vs PostgreSQL Anonymizer

DATPROF is a test data management platform for creating, protecting, automating and delivering data for development, testing and QA. Its modules cover privacy, subsetting, runtime, analysis and virtualization. Privacy masks test data and creates synthetic data while retaining representative characteristics, with more than 50 built-in generators supporting different languages. Subset extracts selected production data for test environments while preserving relationships. Runtime supports self-service provisioning, scheduling, monitoring and REST API automation. DATPROF can be deployed on premise or in the cloud, and says data stays in its database domains during masking. Native database support includes Oracle, Microsoft SQL Server, DB2 iSeries, DB2 LUW, PostgreSQL, EDB, MySQL and MariaDB. Supported flat file formats include CSV, Fixed Length, Recursive Fixed Length and XML. DATPROF says its masking can support GDPR, PCI and HIPAA requirements. Its security program aligns with ISO 27001 principles and includes SAST, dependency scanning and DAST in development. Support is available through a service desk portal, email and a documentation knowledge base. Pricing is available on request, and a free trial is listed.

PostgreSQL Anonymizer is an extension for masking or replacing personally identifiable and commercially sensitive data in PostgreSQL databases. Masking rules can be written in SQL with PostgreSQL DDL and kept in the database schema. Its documented approaches include anonymous dumps, static and dynamic masking, replica masking, masking views, and data wrappers. Functions can randomize, fake, partially scramble, shuffle, add noise, generalize, or apply custom transformations. A masked role can export anonymized data through pg_dump; masking rules should then be removed from the dump. Identifier detection searches common names in English and French, but may flag non-identifiers or miss identifiers. Installation instructions cover Linux and self-hosted PostgreSQL. The extension can be built from source on macOS, without community support there; Windows use is described through PostgreSQL on WSL2, as there is no native build. Installation requires superuser privileges, so a cloud database provider must offer the extension in its catalog. The plan is free. Commercial support is available separately.