Published NXS-Data-Anonymizer 1.6.0, a tool for dumping databases in PostgreSQL and MySQL/MariaDB/Percona. The tool, written in Go, is released under the Apache License 2.0.
The utility allows for data anonymization based on templates and functions from the Sprig library. NXS-Data-Anonymizer can be used via non-interactive channels (PIPE) on the command line to redirect dumps from the original database directly to the target database with necessary transformations. It also supports working with “null” values through filters. The command -l/-log -emat is available to choose the log format (JSON or plain text). Progress intervals can be indexed during the anonymization process, showing data on the operation’s progress. External commands can be incorporated by adding a “Type: Command” column to set field values.
The new version includes a feature to activate safe operation on NXS-Data-Anonymizer, excluding any data not clearly described in the resulting dump. Depending on entity type in the security settings, the tool anonymizes columns for tables outlined in the Filters section. If a table does not have any rules, data will still be protected as the anonymizer will not include it in the dump.
Original data in columns will only appear in the output if the secrets.tables specify the table name. This ensures that dynamically evolving projects with variable database structures are safeguarded even if developers forget to adjust the anonymizer configuration file.