Data dictionary tools for Oracle

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.

Document! X

Document! X provides automatic documentation of SQL Server, Access, Oracle and other OLE DB databases. The generated database documentation is an accurate and comprehensive documentation set covering Schemas, Tables, Columns, Indexes, Relationships, Views, Stored Procedures, Triggers, etc. Besides that, you can extend the source descriptions using the rich authoring environment provided by the Document! X Content File Editor.

Desktop/Cloud: Desktop
ER Diagram: No
Export: XML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: Yes
Notable features: Automated accurate and comprehensive documentation
Runs on: (for desktop): Windows

DbSchema

DbSchema facilitates to design, document and manage SQL and NoSQL databases. It is an intuitive designer for complex databases. It allows editing tables or columns directly in the layout, by double-clicking them.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagram, Reverse engineer schema from database, Relational data browse, SQL editor
Runs on: (for desktop): Linux,Mac OS,Windows

DatabaseSpy

Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool that even generates elegant charts directly from query results. The tool lets you can examine tables and relationships in an existing database, edit tables to better suit your needs, or even can add entire tables and specify all their column attributes and relationships to other tables from scratch.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Word,PDF,RTF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Graphical database design, Complete DDL scripts for database schemas, Data visualization and charting, Advanced database reporting with charts, Database content editor
Runs on: (for desktop): Windows

DBDesigner 4

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation, maintenance, and documentation into a single, seamless environment.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,XML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: Yes
Notable features: Design Mode / Query Mode, Userdefined schema-generation, All MySQL datatypes with all options, SQL Command storage within model
Runs on: (for desktop): Linux,Windows

ERDesigner NG

Mogwai ERDesigner is an entity relationship modeling/design tool (ERD). It handles tables, relations, views, domains, custom types, indexes, and comments and can generate schema documentation.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Program metadata
Commercial: Free
Free edition: Yes
Notable features: 2D & 3D editing mode, Schema compare, Entity relationship diagram, Central repository for all models
Runs on: (for desktop): Windows

Tree Schema

The Tree Schema data dictionary provides a single place to define all of the key terms and lingo that drive your business. The Tree Schema dictionary is automatically synced with the tags within Tree Schema, making it easy to define the labels that are important to your business and leverage them to tag your data assets.

Desktop/Cloud: Cloud
ER Diagram: No
Export: -
Metadata stored in: -
Commercial: Commercial
Free edition: Yes
Notable features: Automatically syncs tags with business glossay
Runs on: (for desktop): -
Data dictionary overview
Edit a keyword

Atlan

Atlan's data dictionary allows you to document databases, data warehouses, data lakes and BI tools in one easy interface. It uses automation to generate pre-configured critical data quality metrics and automation to help propogate column descriptions through your data ecosystem. Using Atlan's interface, you can easily update table descriptions, column descriptions, assigns owners and stewards and attach a powerful readme to every object. Atlan also allows you to capture relationships such as primary key, foreign key relationships, lineage and more.

Desktop/Cloud: Cloud
ER Diagram: No
Export: -
Metadata stored in: Graph Database
Commercial: Commercial
Free edition: No
Notable features: Automated data dictionary, column level search, visual frequency, versioned data dictionary
Runs on: (for desktop): -

Alation Data Catalog

Alation data dictionary defines and describes technical data terms. Data terms could be database schemas, tables, or columns. Once connected to data sources, Alation automatically indexes data and populates catalog pages. For example, a column catalog page shows the technical column name, a business title name, the data type, and popularity. Additional context can be added to the data dictionary, for shared understanding across the organization.

Desktop/Cloud: Cloud
ER Diagram: Yes
Export: MS Excel
Metadata stored in: -
Commercial: Commercial
Free edition: No
Notable features: ML auto-suggested business glossary terms
Runs on: (for desktop): -

GenMyModel

With GenMyModel’s data modeling capabilities, data architects not only keep glossaries and data models under control, but they can design and reverse engineer data models and link them to other IT and business models, such as UML, Archimate and BPMN.The resulting data dictionary stores metadata such as table, column and field descriptions,
in a format that is independent of the underlying database system so generation can be generic.

Desktop/Cloud: Cloud
ER Diagram: Yes
Export: HTML,MS Word,Online HTML,PDF,Plain text,XML
Metadata stored in: Online repository
Commercial: Commercial
Free edition: Yes
Notable features: -
Runs on: (for desktop): -

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.