Redgate Releases SQL Data Catalog V2
May 26, 2022

The latest release of Redgate Software’s SQL Data Catalog now provides a simple, policy-driven approach to data protection.

As well as automatically scanning columns within databases and using intelligent rules to make recommendations about how they should be classified, it auto-generates static data masking sets from the classification metadata that can be used to protect the databases.

This is a timely move because many organizations, like those in the Financial Services and Healthcare sectors, are now obliged by law to ensure that all sensitive or personal data is identified and removed or protected before databases are made available for use in development, testing, analysis, training or other activities.

This is not a one-off exercise, but an ongoing effort that requires a continuous approach to data protection, typically involving three steps. First, organizations need a data protection plan to identify and classify which databases hold data that needs protecting and how. They then need to implement the plan in a way that guarantees sensitive and personal data is always removed or obfuscated by a method like masking database copies that are used outside secure production environments. And thirdly, the plan has to be maintained on a rolling basis as databases and their data expand and change.

As Bloor states in its Sensitive Data Management Spotlight paper: “This must all be done continuously. When new data enters your system, you should be automatically determining if it is sensitive, anonymising it if it is, and applying access rules as appropriate. This is most easily done via (automated) policy management, thus allowing you to manage incoming sensitive data indefinitely and thereby make sure that your organisation doesn’t relapse into noncompliance.”

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

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

An extensive set of built-in classification rules, which can be customized to align to particular regulatory requirements, then speed up data classification with automatic suggestions and intelligent rules based on automated data scanning. This identifies which columns need to be masked, either manually, or by using a tool like Redgate Data Masker which can sanitize the data using the auto-generated data masking sets provided.

Importantly, as databases are added, and existing databases modified, the data classifications are automatically maintained in SQL Data Catalog, and the data masking sets it creates can be updated on demand.

This policy-driven approach enables organizations to ease and streamline their data management processes by automating and maintaining their security posture. This protects their sensitive data, puts in place an auditable workflow, and ensures they stay compliant with regulatory agencies.

Share this

Industry News

June 27, 2022

Delinea announced the latest release of DevOps Secrets Vault.

June 27, 2022

Jit announced a $38.5 million seed funding round and launched a free beta version which automates product security.

June 27, 2022

Platform.sh raised $140 million in Series D funding.

June 23, 2022

Akana by Perforce now offers BlazeMeter to customers, previously a solution with Broadcom Layer7.

June 23, 2022

Coder announced the release of a new open source project that gives developers and data scientists a consistent, secure, yet flexible way to create cloud workspaces in minutes.

June 23, 2022

GitGuardian is announcing a series of new features to address developer experience in securing the software development lifecycle.

June 22, 2022

OctoML released a major platform expansion to accelerate the development of AI-powered applications by eliminating bottlenecks in machine learning deployment.

June 22, 2022

Snow Software announced new functionality and integrations for Snow Atlas, a purpose-built platform that provides a framework to accelerate data-driven technology decision-making.

June 22, 2022

Traefik Labs launched Traefik Hub, a new cloud service that eliminates the complexity of management and automation of Kubernetes and Docker networking at scale.

June 21, 2022

The Linux Foundation, the nonprofit organization enabling mass innovation through open source, announced the new Open Programmable Infrastructure (OPI) Project.

June 21, 2022

Docker announced the acquisition of Atomist, a company founded to improve developer productivity and keep cloud native applications safe.

June 21, 2022

SmartBear released BitBar, an all-in-one web and native mobile app testing solution.

June 16, 2022

Armory announced general availability of Armory Continuous Deployment-as-a-Service.

June 16, 2022

Infragistics announced the launch of App Builder On-Prem.

June 16, 2022

LambdaTest launched Test-at-Scale (TAS), a test intelligence and observability platform, to help development teams with shift-left testing.