Explore Curiosity's Platform Use Cases

Our innovative quality solutions help you deliver rigorously tested software earlier, and at less cost!

Test Modeller                    Use Cases

Explore a range of Test Modeller use cases and solutions!

Test Data Automation        Use Cases

Explore our range of Test Data Automation use cases and solutions!

Helpful Resources

Discover a range of helpful resources for getting started with our solutions!

Explore Curiosity's Resources

See how we empower customer success, watch our latest webinars, explore our newest eBooks, read our blogs, and more.

Latest Resources

Explore a wide range of the latest resources from the Curiosity team!

Customer Success Stories

Learn how our customers use our tools to achieve success!

Help & Support

Explore the helpful links below if you need any help.

Creating Quality Since 1995

Curiosity are your partners when designing, building and rigorously testing complex systems in short sprints!

Get To Know Curiosity

Explore our history, learn about our team and the latest Curiosity news!

Customer Success Stories

Learn how our customers use our tools to achieve success!

Connect With Us

Reach out to our team or keep up to date with our latest news!

Test Data Masking for SQL Server

Remove costly compliance risks 

Rapidly remove sensitive information from less-secure test environments, providing on demand data with the relationships needed in development. Test Data Automation combines automated data profiling with easy-to-configure masking, providing masked data on-the-fly during manual testing, automation, and CI/CD.

Speak with an expert



You can’t choose between delivery speed and test data compliance

Eye-watering fines and new legislation have introduced greater risks for testers who still depend on production data copies. The dangers of exposing potentially-sensitive information to less-secure non-production environments has led many organisations to forbid this outdated practice. Yet, testing and developing at speed requires constant data refreshes, while removing sensitive data can be slow and complex. Many organisations rely on a complex mix of scripts and manual masking routines, which struggle to retain intricate relationships across data sources. Masking can in turn introduce lengthy delays to data provisioning, while more time is lost as tests fail due to broken and inconsistent test data. For both CI/CD and compliance, a rapid and simplified approach is needed for test data anonymisation.

Free eBook - Test Data and AI


Intuitive data masking for testing, test automation and CI/CD

Test Data Automation provides automated data profiling and easy-to-configure data masking, rapidly anonymising data to support quick and compliant development. Data scanning automatically finds and tags potentially-sensitive information across tables, using customizable regular expressions, seed lists, and column names. The tags provide a visual map of where sensitive data resides across databases, quickly selecting from global rules to mask every piece of tagged data consistently. Each configured mask then becomes reusable from a central catalogue, from which it can be executed using self-service forms. Parallel testers and developers can self-service the compliant data they need using intuitive drop-downs and inputs, while automation frameworks and CI/CD pipelines can likewise run masks on-the-fly.

Test Data Masking for SQL Server

Test Data Automation’s masking jobs run using high-performance, parallelized masking, reducing compliance risks while providing on demand test data. Configuring masking rules is likewise quick and simple, using intuitive screens to define and apply masking rules consistently across tables. Generating an optional audit file during masking further supports compliance, verifying that data has been masked successfully. Maintaining a catalogue of reusable data scanning and masking rules further strengthens auditing and accelerates masking, while Test Data Automation additional maintains audit logs of previous masks. Ensuring mandatory test data compliance no longer becomes a blocker to rapid development, anonymising and tracking data on-the-fly during testing, test automation and CI/CD.

Speak with an expert


Mask your test databases and files at speed

Watch this demo of Test Data Automation masking a SQL Server database, to discover how:

  1. Test Data Automation scans databases to learn where personally and commercially sensitive information resides, using customizable regular expressions, seedlists and column names.

  2. The automated data profiling tags sensitive data in columns and tables, creating a visual map of information to mask when ensuring compliance with data privacy policies.

  3. Masking complex data does not create data provisioning bottlenecks, applying out-of-the-box and customizable data rules globally to mask all tagged data.

  4. Editing and applying masking rules is as quick and simple as using intuitive forms and drop-down menus, replacing the time lost working with hard-to-maintain scripts and routines.

  5. Each configured mask becomes reusable from a central catalogue, from which it can be triggered using self-service forms, automation frameworks, and CI/CD infrastructure.

  6. Parallelised masking ensures performance as data is anonymized, while retaining data relationships and referential integrity to avoid time-consuming test failures caused by data.

  7. An optional “before and after” masking report and in-tool reporting supports test data compliance, creating a clear audit trail and verifying that sensitive data has been removed.


Speak with an expert

Discover how you can create mainframe automation in minutes.

Schedule a Demo