Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

SQL Data Mask: Masking Configurations and Reports

DZone's Guide to

SQL Data Mask: Masking Configurations and Reports

Check out the latest update in SQL Data Mask, a prototype that you can use to mask your databases for free with anonymized personal data.

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

SQL Data Mask is the latest prototype to come out of the Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge.

In our last update, we shipped the first on-premises version of the app, previous versions only work in Azure in our foundry labs page.

We’re working closely with a select group of people who are helping us test and iterate this solution; our goal is to make sure SQL Data Mask is able to satisfy your masking requirements.

What Is New

Based on the feedback you’ve given us, SQL Data Mask now has the ability to import/export masking configuration files, and we provide a masking report once a masking job is completed.

Masking Configuration Files

There are three reasons for masking configuration files:

  1. To incrementally mask your database as you discover sensitive data.
  2. To source control your work and easily share it with your colleagues.
  3. For automation.

This is the first effort towards that. You can now import and exporta masking configuration file that you can re-use, share and source control.

Here is an example of how the [Person.Address] table has been updated to mask the address lines.You can see this change from a source control system once you export the masking configuration file.

Masking Reports

With GDPR around the corner and companies trying to keep audit trails, many of you have raised the importance of reports for auditing reasons. This is why we decided to provide a report capability very early in the development process in order to work with users and enhance this report.

Once you complete a masking job we give you the ability to view the masking report as well as being able to export it to disk.

Here is an example of a masking report for AdventureWorks:

Image title

Join the EAP

Here are some other things we’ve done to make SQL Data Mask better.

  • Masking configuration page changes:
    • Added the ability to filter tables.
    • Tables are now ordered by schema and table name.
    • The list of tables is now scrollable.
  • Created destination database changes:
    • Login objects are now ignored.
    • Mappings from database users to logins are now ignored.
  • Miscellaneous:
    • Added support for authenticated proxies.

What Is Next?

The two main things we want to work on and investigate are more flexible masking features and the ability to automate SQL Data Mask.

In the meantime, head over to Redgate Foundry and try SQL Data Mask now — we’d love to hear how well it masks your database for you.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:
database ,sql data mask ,anonymized data

Published at DZone with permission of Santiago Arias. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}