ARX Data Anonymization Tool vs PostgreSQL Anonymizer

ARX Data Anonymization Tool is open-source software for anonymizing sensitive personal data and examining privacy risk and data utility. Its graphical application supports data import and cleansing, transformation-rule setup, tailoring anonymized datasets, and analysis of utility and residual re-identification risk. It imports CSV, MS Excel, and relational database data, including MS SQL, DB2, MySQL, and PostgreSQL. Listed methods include k-anonymity, l-diversity, t-closeness, δ-presence, risk-based criteria, and semantic models such as differential privacy. ARX exports displayed tables to CSV and compares input with transformed data using information-loss models, descriptive statistics, and application-specific analyses. Its risk analysis reports prosecutor, journalist, and marketer attack risks, estimates population uniqueness, and can identify HIPAA Safe Harbor identifiers and further quasi-identifiers. A Java library and API can add anonymization capabilities to Java programs. The tool is free under Apache License 2.0 and supports Linux, macOS, Windows, API, and self-hosted options. The maker provides PGP/GPG-signed checksums for download integrity and states the software is provided without warranties or conditions.

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.