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|
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.”
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