Released nxs-data-anonymizer 1.9.0 — a tool for anonymizing dumps of PostgreSQL and MySQL/MariaDB/Percona databases. The tool is written in Go and is released under the Apache License 2.0.
The program supports data anonymization based on templates and functions from the Sprig library. Nxs-data-anonymizer can be used via unnamed pipes in the command line to redirect dumps from the source database directly to the target database with necessary transformations. The anonymization process can be indexed — progress information about the operation is output at specified intervals. By using external commands with the column value set to "type: command", field values can be specified.
Depending on the entity types in the security settings, the tool anonymizes columns for tables with rules described in the filters section. If a table contains no rules, the data will still be reliably protected, as the anonymizer will not include them in the resulting dump.
In the new version, a 'Link' block has been added to the column filter, which allows linking the anonymization of database entities across different tables. This block holds the rules that the tool uses to anonymize related columns in the specified configuration tables throughout the database. As a result, cells in certain columns that had the same values before anonymization will have the same values after anonymization.
Additionally, the capability to work with one-off generated data using global variables has been introduced through a specially developed module, which ensures generation with the possibility of use in filters.
Source: opennet.ru
