Redgate Software Takes Policy-Based Approach to Data Protection with New Data Catalog Release

Cambridge United Kingdom, Thursday May 26 – To help organizations simplify their data management practices by automating business-critical decisions, the latest version of Redgate Software’s SQL Data Catalog now offers a simple, policy-driven approach to data protection. In addition to automatically analyzing columns in databases and using smart rules to make recommendations on how they should be classified, it automatically generates static data masking sets from classification metadata that can be used to protect databases.

This is a timely move as many organisations, such as those in the financial services and healthcare industries, are now required by law to ensure that all sensitive or personal data is identified and deleted or protected before that the databases are made available for use in development, testing, analysis, training or other activities.

This is not a one-time exercise, but an ongoing effort that requires an ongoing approach to data protection, typically involving three steps. First, organizations need a data protection plan to identify and categorize which databases contain data that needs to be protected and how. They should then implement the plan in a way that ensures that sensitive and personal data is always deleted or masked by a method such as masking copies of databases used outside of secure production environments. And third, the plan must be maintained on an ongoing basis as databases and their data grow and change.

As Bloor points out in his Document on the management of sensitive data“All of this has to be done continuously. When new data enters your system, you should automatically determine if it is sensitive, anonymize it if it is, and apply access rules where appropriate. This is most easily done through (automated) policy management, allowing you to manage incoming sensitive data indefinitely and ensure your organization does not fall back into non-compliance.

This is a big challenge for many organizations, reflected in the magnitude of research, resources, planning and time required. It’s a difficult process to get right the first time and impossible, without automation, to do it every time data is created or refreshed in a non-production system.

SQL Data Catalog v2 marks a step change in this process by dramatically reducing the time it takes to go from identification and classification to protection, and dramatically simplifying maintenance. When connected to a SQL Server instance, it automatically examines each database’s schema and data to determine where personal or sensitive data is stored.

A comprehensive set of built-in classification rules, which can be customized to align with particular regulatory requirements, then accelerate data classification with automatic suggestions and smart rules based on automated data analysis. This identifies columns that need to be masked, either manually or using a tool such as Redgate Data Masker which can sanitize the data using the automatically generated data masking sets provided.

It is important to note that as databases are added and existing databases are modified, data classifications are automatically persisted in SQL Data Catalog and the data masking sets it creates may be updated on demand.

This policy-based approach enables organizations to simplify and streamline their data management processes by automating and maintaining their security posture. This protects their sensitive data, sets up an auditable workflow, and ensures they remain compliant with regulators.

About Redgate Software
Redgate makes ingeniously simple software used by more than 800,000 IT professionals worldwide and is the leading provider of Database DevOps solutions. Redgate’s philosophy is to design highly usable and reliable tools that elegantly solve the problems that developers and DBAs face every day and help teams get the most out of any database, on any number. growing platforms, everywhere. In addition to streamlining database development and preventing the database from being a bottleneck, it helps organizations introduce data protection by design and by default. As a result, more than 200,000 companies use Redgate tools, including 91% of those in the Fortune 100.

Media Contacts
Meghana Shendrikar
Allison+Redgate Software Partners
[email protected]