Data catalogs

List of data catalogs tools

Data catalog is a structured collection of data used by an organization. It is a kind of data library where data is indexed, well-organized, and securely stored. Most data catalog tools contain information about the source, data usage, relationships between entities as well as data lineage. This provides a description of the origin of the data and tracks changes in the data to its final form.

Data dictionary tools

List of tools that enable design and building of data dictionaries.

Data Dictionary is a set of important information about data used within an organization (metadata). This information includes names, definitions, and attributes about data, owners, and creators of assets. Data Dictionary tools provide insights into meaning and purposes of data elements. They add useful aliases about the scope and characteristics of data elements, as well as the rules for their usage and application.

Business Glossary tools

List of tools that help build, maintain an share business glossaries.

Business Glossary is a collection of definitions and terms used within a business unitorganization. It is not used to define data, but rather to define what a particular term means from a business perspective. The definitions are mapped and logically linked to entities in the database. This enables structured communication between teams and allows them to reveal potential errors resulting from incorrect nomenclature.

Data Governance tools

List of data governance tools

Data governance is a strategy of handling data within an organization. It is a set of rules, policies, standards, practices etc. which main purpose is to ensure data has a high quality and integrity, is safely stored and there are no ambiguities in meaning of common terms. Applying this strategy is a long process, engaging whole organization, especially IT and data consuming departments. There are certain data governance tools which helps applying these theoretical plans in real life.

Data lineage tools

Data profiling tools

Data quality tools

Database diagram / Reverse Engineering tools

List of database ER diagram (ERD) / schema visualization / reverse engineering tools for popular databases.

Database documentation generators

List of tools that automatically generate documentation for your database. For more advanced capabilities see Database Documentation Tools

Database documentation tools

List of tools that allow the documentation (e.g. with descriptions) of schema of your databases.

Database documentation is a set of descriptions of the data, that facilitate management, maintenance, and retrieval of resources. Documentation can take many forms, however, it usually acts as a data catalog that holds detailed information about the table schema, all relationships, data types, etc. Description of datasets as well as single data objects also is referred to as metadata (data about the data).

Extended properties editors

List of tools that allow editing of SQL Server extended properties.
Direct - read and save extended properties from SQL Server database.
Repository - edit metadata in separate repository and enable synchronization.
Custom fields - whether tool enables editing custom extended properties, apart MS_Description.

GDPR compliance software

List of GDPR compliance tools

Collecting, storing, and processing data of the EU citizens have changed on May 25, 2018, when European Parliament decided to replace Data Protection Directive 95/46/EC with General Data Protection Regulation (GDPR). This new law has placed more emphasis on consumer data protection and gave consumers greater control over their personal information. Complying with these rules gets complex as more customers’ data is collected and processed. Following GDPR Compliance software can help to simplify and speed up this tedious process.

GUI tools

Metadata Management tools

List of metadata management tools

Metadata management tool is a solution that supplements the data stored by the enterprise environment with useful information. Proper metadata management is a crucial factor to make information searchable, easy to locate and understand. Such tools add meaningful context to raw data, making it convenient to discover even by non-IT members of an organization.

Reference Data Management tools

Sensitive data discovery tools

List of sensitive data discovery tools

In recent years many international organizations, countries, states etc. have introduced strict regulations regarding sensitive data storing and processing (GDPR in EU, CCPA in California state or PDBP in India just to name a few) to ensure that companies and organizations handle personal information correctly. This should motivate organizations to revise their data protection policies and identify all private data they collect and process. Invaluable help with this tedious task are sensitive data discovery tools.