DataVeil vs Greenmask

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.

Greenmask is a free, open-source utility for logical database dumps, anonymization, synthetic data generation, and restoration. PostgreSQL 11 and later is fully supported; MySQL support is in progress and beta. Its subsetting tools can produce smaller development databases while preserving referential integrity, including cyclic and polymorphic references. Transformations may be deterministic or random, use dynamic parameters and conditional rules, and inherit across partitions and foreign-key references. Users can make custom transformers that exchange data through standard input and output, or use predefined templates. Greenmask supports local directories, S3-compatible storage, Azure Blob Storage, and SSH/SFTP. It uses PostgreSQL's pg_dump and pg_restore utilities for schema dumping and restoration, and its dumps can be restored with pg_restore. The utility is designed for CI/CD automation of anonymization and restoration. Its stateless, in-flight approach can anonymize data before it is persisted without requiring persistent storage of unmasked datasets in its normal workflow. Installation scripts support Linux and macOS; Windows is not supported yet.