Solution architecture

The process

1.

Import database schema

First step is to connect to your database and import schema to Dataedo metadata repository.

Supported databases
2.

Describe schema and enhance data model

Now to the documentation part. You can provide a description (and additional metadata) for each schema object and element (table, column, key, stored procedure, etc.). You can also complete data model by with missing foreign or unique keys. This information will be stored in the repository.

Learn more: Data Dictionary, Document table realtions, Document procedures
3.

Define modules and group objects

For better understanding of large databases you can spit them into smaller subject areas called modules. Define list of modules, and for each provide a description and assign database objects.

Learn more
4.

Create ER diagrams

For each module you can visualize physical data model with an ER diagram by dragging & dropping tables and views to the pane.

Learn more
5.

Export and share in PDF, HTML or Excel

You can share your documentation in interactive HTML, nicely formatted PDF or Excel.

Learn more
Sample documentations:
HTML PDF Excel
6.

Import schema changes

Whenever schema of your database changes just click Update button (or schedule automated task) to import them to your documentation without fear of loosing any of your descriptions.

Repeat

Development and documentation of databases is a continuous process and Dataedo is designed to support that with features like importing changes, automation with command line or tracking documentation progress.
Learn more: Progress tracking

"We use Dataedo to document multiple databases and our data warehouse. Dataedo helped us save a lot of precious time."

Anthony Goudemez
IT Development Manager

Learn more about Dataedo