Generate Data Dictionary for your SQL Server, Oracle and MySQL database

How it works?

Dataedo lets you generate and maintain a data dictionary for SQL Server, Oracle and MySQL databases and export it to friendly HTML and PDF documents.

Connect to your database and create new documentation

To generate a data dictionary all you need is to connect to your database - provide address, user and password. Definition of all tables, views, columns and other objects is imported to Dataedo repository as new documentation (data is not read). You are now ready to complete documentation or export data dictionary to HTML, PDF or Excel.

Documentation

Import existing descriptions

Most database systems enable describing objects directly in a database - SQL Server has extended properties, Oracle and MySQL have comments. Dataedo reads existing comments from tables, columns etc. and adds them automatically to your documentation. It doesn't overwrite them later (unless they are empty), so you won't lose your work.

Example below shows City column attributes in SQL Server Management Studio and description imported to Dataedo repository:

Import comments
Import comments

Describe tables and columns

Once you imported database schema you can describe every element. Key element of each data dictionary is a detailed description of all tables. Dataedo lets you edit descriptions of every data element in simple UI:

Dataedo editor - table
Dataedo editor - table columns
Dataedo data dictionary - table
Dataedo data dictionary - table

Same goes for views

Views are not always regarded as a part of data dictionary, but Dataedo lets you to describe them the same way as tables.

Describe relations

Another important element of data dictionary is a relations between tables - how are they linked together and how you can join them while querying with SQL. Dataedo reads foreign keys - relations between tables defined in database. It also enables you to define your own relations in repository when a database is missing foreign keys, as it is quite often the case. You can also document links with views, which is impossible in relational databases. Read more about defining user-defined relations.

Dataedo Editor - table relations
Dataedo PDF documentation - table relations
Dataedo PDF documentation - table relations
Dataedo PDF documentation - table relations

Describe unique keys

Another important aspect of data specification in data dictionary are unique keys - constraints set on data in table. It specifies that values in column or set of columns must be unique. This is an important aspect of data while joining tables (to avoid duplication of rows, a dangerous effect in querying and reporting) and inserting data. Again, those constraints are quite often not defined in databases. Dataedo lets you define missing unique keys for both, tables and views. Read more about defining user-defined relations.

Dataedo editor - unique keys
Dataedo PDF - unique keys
Dataedo PDF - unique keys