How to Mask a Database using Test Data Automation

A simple process for masking complex test data

Watch this short data masking tutorial, masking an E-Commerce SQLServer database, and understand how:

1. Easy-to-configure configurations provide an intuitive, fill-in-the-gaps approach to masking complex data consistently.

2. Automated data scanning identifies sensitive data that needs masking, providing recommended masking functions for potentially problematic columns.

3. Masking sensitive data is as quick as picking from a complete set of data functions, using hashing algorithms to retain the referential integrity needed in testing.

4. High performance, parallelized masking can be run from a collaborative web portal and from the command line, or as part of automated test execution and within DevOps toolchains.

5. Optional auditing tracks differences made to data, validating that defined masks anonymize data reliably and accurately.

6. Masking can be performed in flight or in place, incorporating custom functions if needed.

7. Data masking can be integrated seamlessly with a full range of TDM utilities, including synthetic test data generation, subsetting, and data allocation.