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 backups, anonymization, synthetic data generation, and restoration. It currently supports PostgreSQL, with MySQL, MongoDB, and other database support in development. Transformations can be deterministic or random, use dynamic parameters, mask data, or apply custom rules based on domains. Configuration validation can show warnings and data or schema differences, and transformation settings can be inherited across partitions of partitioned tables. Greenmask stores backups in local directories or S3-like remote storage. It supports parallel dumping and restoration, as well as parallel compression with pgzip. Its logical-dump approach does not require changes to the existing database schema, and dumps can be restored with pg_restore. CI/CD integration can automate anonymization and restoration. Greenmask runs on Linux and macOS and can be self-hosted on premises. Installation options include an install script, Docker, Homebrew, or building from source; the install script works on Linux and macOS, while Windows is not supported yet. A Docker Playground with sample databases provides a sandbox for trying the utility. The maker offers paid custom development for urgent or enterprise-specific feature requests.