Which masking techniques are available in Navicat?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat for Snowflake, Navicat Premium

Navicat offers five masking techniques:

1. Substitution

• What it does: Replaces data with realistic fake values from a pre-defined library.
• Use Cases: Names, emails, phone numbers, addresses, card numbers

2. Variance

• What it does: Adjust numeric or date values by a specified percentage or range to maintain distribution.
• Use Cases: Salaries, transaction amounts, birth dates

3. Hashing

• What it does: Transform data into a unique, fixed-length string using cryptographic algorithms.
• Use Cases: IDs that must stay consistent but unreadable

4. Nulling

• What it does: Replace sensitive data with NULL or empty values.
• Use Cases: Fields not needed at all for testing

5. Shuffling

• What it does: Randomly rearrange values within the same column across different rows.
• Use Cases: Keeping totals and averages correct while breaking the link to each record