Discover and classify sensitive data

Protecting and preserving data starts with a clear view of your SQL server estate

  • Discover – Gain a clear picture of SQL Server data in your estate
  • Classify – Speed up data classification with automatic suggestions and advanced filtering
  • Automate – API-first design and PowerShell functions for bulk operations and interoperability
  • Align – Create a taxonomy aligned to your business needs or data privacy regulation
  • Comply – Underpin and evidence your technical policy for regulatory compliance

Request a demo

By classifying data across your SQL Server estate you can ensure that the correct data is protected – in the correct way – allowing you to focus investment on the most critical areas.

And with domain knowledge centralized, and a shared understanding across your organization – data risks can be exposed, avoided, and regulatory compliance met.

“SQL Data Catalog enables us to prove that we know where our PCI and GDPR data is – essential for audits.”

Steve Hall, DBA, GBG GBG

Key features

Discover – Gain a clear picture of SQL Server data in your estate

SQL Data Catalog connects directly to a SQL inventory to provide an up-to-date view of instances and databases, included those managed by 3rd-party vendors. Automatic scanning of databases and schemas catches any changes to the estate without the need to reregister instances, to ensure the latest information is captured.

Classify – Speed up data classification with automatic suggestions and advanced filtering

Automated classification suggestions enable a picture of the estate to be generated quickly. Advanced searching and filtering assist in fine-tuning classification by identifying patterns in the data. Columns with data of matching sensitivity can be grouped so that classification labels can be applied in bulk.

The option to store classification data in a separate database means labels can be changed and copied independently of the schema, and facilitates the classification of 3rd-party vendor databases. Applying classification labels to the schema is also possible via extended properties.

Automate – API-first design and PowerShell functions for bulk operations and interoperability

Classification labels can be applied to columns and schemas in bulk programmatically via the API, supported by a library of PowerShell worked examples.

The API also enables classification metadata to be integrated with other compliance tools and reporting solutions to automatically demonstrate compliance.

Align – Create a taxonomy aligned to your business needs or data privacy regulation

SQL Data Catalog uses a flexible and extensible taxonomy which can be customised to meet business needs or data privacy regulation. The default Microsoft taxonomy can be used as a starting point from which to develop more accurate classification labels for particular legislation or use cases. Multiple tags can be used to group and categorize data for better organization.

User permissions control who can edit the taxonomy, providing peace of mind that once defined, classification labels remain fit for purpose and avoid unauthorised adjustment.

Comply – Underpin and evidence your technical policy for regulatory compliance

SQL Data Catalog provides a reliable record of where sensitive data is located and its precise classification, so that adequate measures for data protection can be put in place, such as data masking.

SQL Data Catalog automatically generates a history of changes, providing an audit trail of where classification labels were applied, when and by who. This helps to guard against misuse as well as supplying evidence to satisfy auditors and internal governance.

Report - Create PowerBI, Tableau, and SSRS reports or export data as a CSV

Classification data can be exported as a CSV or automatically via the API to provide up-to-date reports for sharing across the organization or with external partners and auditors. Connect to popular reporting tools such as PowerBI, Tableau, and SSRS for analysis and visualization of classification data.

“SQL Data Catalog gives us a single tool to fully spotlight, audit, and speak confidently about all our sensitive data.”

Patrick Harrell, Database Administration Manager, Tennessee Housing Development Agency

Request a demo

91% of the Fortune 100 companies use Redgate products

Flexible subscription pricing

Pricing is based on the number of production servers, based on tiers, and the length of your subscription. The lowest tier covers up to 5 production servers.

You can classify and catalog multiple databases on multiple instances. You will require one license per server, regardless of how many instances are on that server.

Examples

5 x Azure SQL Databases

One SQL Data Catalog license allows you to classify and catalog up to 5 Azure SQL Databases. You can also connect to 1 x Azure Elastic Pool or 1 x Azure Managed Instance with one SQL Data Catalog license.

3 x production servers, 3 UAT servers, 2 development servers

1 x 5-server license

5 x production servers on-premise, 8 production databases in Azure SQL DB

1 x 10-server license (equivalent 7 licenses are required).

Catalog up to 5 production servers

Buy now Request a demo

Catalog up to 10 production servers

Buy now Request a demo

For 11 or more servers,
contact us for a personalized quote.

0800 169 7433 sales@red-gate.com

Further resources

Article

Practical steps for end-to-end data protection

If you plan to make production data available for development and test purposes, you'll need to understand which columns contain personal or sensitive data, create a data catalog to record those decisions, devise and implement a data masking, and then provision the sanitized database copies. Richard Macaskill show how to automate as much of this process as possible.

Read the article

Get started

Get started with short videos and documentation

Watch this course and learn how to use SQL Data Catalog to classify data across your SQL Server estate, ensuring that the correct data is protected - in the correct way - allowing you to focus investment on the more critical areas.

Get started

We're here to help 01223437921

Whether you want more details about SQL Data Catalog, a demo, or to know about best practice – get in touch.

The industry standard tools for 20 years

Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.