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.

Dataedo

Dataedo enables you to catalog, document and understand your data with Data Dictionary, Business Glossary and ERDs. It enables to document your relational databases and share documentation in interactive HTML.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Excel,PDF
Metadata stored in: Documentation repository/file
Commercial: Commercial
Free edition: No
Notable features: ER diagrams, metadata repository, schema change tracking, organizing with modules, documenting missing FKs, custom fields, description suggestions, documentation progress tracking, rich text with images
Runs on: (for desktop): Mac OS,Windows
Database Web Table Diagram
Dataedo Web Table Columns
Database Web Business Glossary

dbdesc

dbdesc is a powerful tool to help you document your databases. It can produce detailed documents describing your databases. It has a built-in extended property editor and documentation exporter.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML,MS Word,PDF,RTF
Metadata stored in: SQL Server extended properties
Commercial: Commercial
Free edition: Yes
Notable features: Extended property editor, Documentation exporter
Runs on: (for desktop): Windows

Elasoft SqlSpec

SqlSpec is a database documentation tool that generates documentation about all the objects (tables, views, stored procedures, triggers, indexes, constraints, functions, etc) in your database. It has both GUI and command-line interface. It enables you to generate entity-relation diagrams.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Documents also Analysis Services, Reporting Services, Integration Server
Runs on: (for desktop): Windows

SentryOne Document

SentryOne Document offers complete documentation for SQL Server databases and BI tools, including SSIS, SSRS, SSAS, Oracle, Hive, Tableau, Informatica, and Excel. In addition, it allows object description editing and documentation can be customized for different audiences, so users only see the most relevant information for their role.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML,MS Word,RTF
Metadata stored in: Documentation repository/file
Commercial: Commercial
Free edition: No
Notable features: Lineage Analysis and Impact Analysis, include images
Runs on: (for desktop): Windows

Leadum DBScribe

DBScribe is a SQL documentation tool that automatically creates comprehensive technical documentation of every detail of your database schema. It provides description editor for tables (table, columns, indexes, foreign keys, triggers), views (view, columns), stored procedures (stored procedure, parameters), functions (function, parameters, columns), defaults, rules. Description data is saved using SQL Server extended properties.

Desktop/Cloud: Desktop
ER Diagram: No
Export: CHM,HTML,MS Word
Metadata stored in: SQL Server extended properties
Commercial: Commercial
Free edition: No
Notable features: Wizard and command line interfaces with highly customizable templates for professional-looking documentation styles.
Runs on: (for desktop): Windows

DTM Schema Reporter

DTM Schema Reporter is a documenting tool for database schema. With DTM Schema Reporter, you can analyze and audit database structure, create schema documentation, create a hard copy of the structure snapshots, etc.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML,MS Excel,MS Word,PDF,Plain text,RTF,XML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagrams
Runs on: (for desktop): Windows

xSQL Documenter

xSQL Documenter provides comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format. It can run as a console application, useful for automating the process of generating documentation for your databases on a schedule, or for integrating xSQL Documenter into your development process.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Dependency diagrams, Data model diagrams, Custom extended properties
Runs on: (for desktop): Windows

TechWriter for Databases

TechWriter for Databases is a documentation tool for databases that leverages the information locked inside your database to automatically produce database reference documentation.

Desktop/Cloud: Desktop
ER Diagram: No
Export: CHM,HTML,MS Word,PDF,RTF,XML,XPS
Metadata stored in: SQL Server extended properties
Commercial: Commercial
Free edition: -
Notable features: Ability to organize topics into a hierarchical table of contents
Runs on: (for desktop): Windows

EZ Data Dictionary

EZ Data Dictionary is a user-friendly data dictionary tool for business and technical end users. Documenting database through EZ Data Dictionary provides better results as compared with Excel. It allows users to review database elements and definitions in a friendly environment and provides better communication between systems professionals and end-users.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML,PDF
Metadata stored in: Documentation repository
Commercial: Commercial
Free edition: -
Notable features: Compare two schemas
Runs on: (for desktop): Windows

Oracle SQL Developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. Besides database development, it is a handy-tool for database documentation and data dictionary.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Program repository
Commercial: Free
Free edition: Yes
Notable features: Entity relationship diagrams
Runs on: (for desktop): Linux,Mac OS,Windows

Ataccama Metadata Management & Data Catalog

Ataccama Data Catalog & Business Glossary tool provides automatic mapping of terms to real data sources in the Data Catalog during profiling, ensuring the Data Catalog is always up-to-date and synced with the Business Glossary.

Desktop/Cloud: Desktop
ER Diagram: No
Export: CSV
Metadata stored in: Program respository
Commercial: Commercial
Free edition: Yes
Notable features: Automated Mapping of Business Terms, Up-to-date Business Glossary, Data Discovery on Multiple Sources
Runs on: (for desktop): Windows

Vertabelo

Vertabelo is a database modeler that gives you the power of visual design of databases online. It allows the user to generate metadata of the database and write comments for the database objects.

Desktop/Cloud: Cloud
ER Diagram: Yes
Export: HTML,MS Word,PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Cloud database design, reverse engineering, document sharing
Runs on: (for desktop): -

Visual Paradigm

Visual Paradigm provides a tool to create and communicate visual database design with professional ERD tool. It allows the user to create customize template to generate a data dictionary for the class models and its attributes in your project.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Word,PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagram, Reverse engineering, SQL script
Runs on: (for desktop): Linux,Mac OS,Windows

Toad Data Modeler

Toad Data Modeler enables developers, DBAs, and designers to create, edit, maintain, and document quality database designs and structures across various database platforms.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagram, Model customization, Easy migration
Runs on: (for desktop): Windows

erwin Data Modeler

erwin Data Modeler (erwin DM) is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It helps to create & maintain sound relational database designs and data dictionary of those models.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Data modeling, Entity relation diagram, Forward & Reverse Engineering
Runs on: (for desktop): Linux,Mac OS,Windows

Key functionality of Data Dictionary tools is to give users the ability to document data. Moreover, very important is the possibility to create a collection of multiple repositories, based on different system engines. For a better understanding of the data, some tools allow visualization of the data structure using ERD (Entity-Relationship Diagrams).

From the organization's point of view, a community module within a data dictionary tool proves to be useful. It facilitates the proper information flow, as well as provides sharing opinions on specific objects among the members of an organization.

Nowadays, data discovery and understanding becomes crucial for proper organization performance. There are many benefits to using Data Dictionaries, such as:
• helps avoid data inconsistencies problems,
• it allows introducing unified nomenclature used in the project,
• Make data searchable, and understandable,
• Create a single source of truth about the data from different repositories,

The prepared list includes simple, open-source data dictionaries as well as more advanced software.