DataVeil vs PostgreSQL Anonymizer

DataVeil masks sensitive SQL database data with fictitious values for testing, development, training, analytics and support. It supports Microsoft SQL Server 2014 or later, Azure SQL DB and MI, MySQL 5.7 or later, Oracle 12c or later, and PostgreSQL 14 or later. Choose random masking or deterministic masking, which can keep values consistent across databases and separate runs. Masks can retain value formats and partial content to help preserve statistical distributions. Discovery algorithms check suspected identifiers and account numbers, and users can add regular-expression patterns. DataVeil maintains referential integrity for defined foreign keys and supports user-defined dependencies. Before writing masked values, users can compare originals and results side by side. Projects run from the GUI, command line or batch files. The Community license includes generated PDF reports and automatically multi-threaded masking. It runs as a Java client with an embedded JDK 21 and uses JDBC. The free Community License never expires and covers databases up to 10GB. The Team license is $5,690 a year for an example configuration; its price depends on connectivity options and source-data size.

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.