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.

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.

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.

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.

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.

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.