12 Data Dictionary tools for Oracle

This is the list of all data dictionary Data dictionary is data about data - list of tables, columns and their relationships with a description of each element. This is a basic way to document a relational database. tools for Oracle. Simple documentation generators can be found on more complete Database Documentation Tools list.

Share

Dataedo

dataedo.com

Data dictionary and ER Diagram creator

Supports: SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, DB2, Azure SQL Database, Amazon Aurora, PostgreSQL, Amazon Redshift, Snowflake

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

more...

Export: HTML, PDF, MS Excel

Metadata stored in: Documentation repository/file

Type: Commercial

Free edition: yes, Pricing from: $999

Last release: Dec 2018 (7.2)

Last updated: 07 Dec 2018

dbdesc

dbdesc.com

Built-in extended property editor and documentation exporter.

Supports: SQL Server, Oracle, MySQL, Access, Firebird

more...

Metadata stored in: SQL Server extended properties

Type: Commercial

Pricing from: $99

Last release: Aug 2014 (4.1)

Last updated: 13 Dec 2016

Elasoft SqlSpec

elsasoft.com

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, SAP ASE, SAP SQL Anywhere, Informix, VistaDB, SQLite, ENEA Polyhedra, Raima RDM Server

Notable features: Documents also Analysis Services, Reporting Services, Integration Server

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Type: Commercial

Last updated: 21 May 2017

Doc xPress

pragmaticworks.com/Products/Doc-xPress

Supports: SQL Server, Oracle

Notable features: Lineage Analysis and Impact Analysis, include images

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Apache Hive, Excel

more...

Export: MS Word, HTML, CHM, RTF

Type: Commercial

Free edition: no, Pricing from: $395

Last updated: 18 Sep 2016

Leadum DBScribe

www.leadum.com/products.php?prod_type=DBScribe

Supports: SQL Server, Oracle, MySQL, PostreSQL, DB2

more...

Export: CHM, HTML, MS Word

Metadata stored in: SQL Server extended properties

Type: Commercial

Free edition: no, Pricing from: $39

Last release: Oct 2010

Last updated: 18 Sep 2016

DTM Schema Reporter

www.sqledit.com/sr/index.html

Supports: SQL Server, Oracle, DB2, MySQL, PostgreSQL, SQLite, SAP ASE, Interbase, Firebird

Notable features: Entity Relationship Diagrams

more...

Export: RTF/MS Word, HTML, CHM, PDF, XML, MS Excel, Plain text

Metadata stored in: Database metadata

Type: Commercial

Free edition: no, Pricing from: $159

Last updated: 16 Jan 2018

SchemaToDoc

www.schematodoc.com

Supports: SQL Server, Oracle

more...

Export: MS Word, HTML

Metadata stored in: SQL Server extended properties, Oracle comments

Type: Commercial

Free edition: no, Pricing from: $40

Last updated: 18 Sep 2016

xSQL Documenter

www.xsql.com/products/database_documenter/

Supports: SQL Server, Oracle, DB2, MySQL, SQLite, SAP ASE, SAP SQL Anywhere, Informix, PostgreSQL, Teradata, Access, VistaDB, ENEA Polyhedra, Raima RDM Server

Notable features: Dependency diagrams, Data model diagrams, Custom extended properties

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Type: Commercial

Free edition: no, Pricing from: $199

Last release: Jan 2014 (4.8)

Last updated: 18 Sep 2016

TechWriter for Databases

techwriter.me/techwriter-for-databases.aspx

Documentation tool for databases that automatically produces database reference documentation.

Supports: SQL Server, MySQL, Oracle, PostgreSQL, Access, SAS, DB2

Notable features: Ability to organize topics into a hierarchical table of contents

more...

Export: PDF, CHM, MS Word/RTF, HTML, XPS, XML

Type: Commercial

Last updated: 04 Nov 2016

Oracle SQL Developer

www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html

Free database IDE from Oracle.

Supports: Oracle

Notable features: Entity Relationship Diagrams

more...

Type: Free

Free edition: yes

Last updated: 22 Apr 2017

Semanta Encyclopaedia

www.semantacorp.com/data-dictionary/

Data governance platform with Data Dictionary feature

Supports: SQL Server, Oracle, Teradata

Notable features: Integration with modeling tools and ERP applications. Ability to comment data quality. ER and dependency diagrams. Online portal with collaboration features.

more...

Export: Online HTML

Type: Commercial

Free edition: no

Last updated: 18 Sep 2016

EZ Data Dictionary

iccinc.com/ezdd/

Supports: SQL Server, Oracle, Access

Notable features: Compare two schemas

more...

Metadata stored in: Documentation repository

Type: Commercial

Last updated: 03 Feb 2017

Share