Create database documentation

Create Data Dictionary

Dataedo helps your team and organization to create and maintain Data Dictionary for existing databases.

Discover and document table relationships

Dataedo reads foreign keys form database schema to the repository and enables users to add missing relationships to the same model enabling complete and consistent view of data model.

Document stored procedures and functions

Dataedo reads stored procedures, functions and triggers and enables you to describe procedure body, each parameter and returned value separately and add custom metadata fields. It includes this documentation and script in exported documents.

Discover and document dependencies

Dataedo imports dependencies from the database and lets you browse and navigate dependent objects in user interface or exported documents.

Document cross-database dependencies

What makes Dataedo stand out from other tools is the ability to document cross-database dependencies and define cross-database table relationships.

Create meaningful ER Diagrams

Create database diagrams

You can easily create database relational diagrams for existing databases simply dragging & dropping tables and views from the list.

Automatic and manual relationships

Table relationships are imported from database schema (foreign keys) and user is also able to add his own relationships only in the repository without impacting the database.

Cross database diagrams and relationships

Dataedo enables documenting cross-database table relationships and mix objects from different databases on one diagram.

Consistency across Data Dictionary and ERDs

Dataedo keeps one consistent data model for data dictionary and ERDs and keeps it up to date with physical database schema.

Share in beautiful documents

Dataedo exports documentation to beautiful HTML, PDF and Excel documents.

Learn more

Easy to keep documentation up to date

Dataedo is designed for documentation in agile environments. We understand that many databases are being developed constantly.

Import schema changes automatically

Dataedo enables you to easily import changes in the source database to make sure you are documenting the most up to date state of your database.

Documentation progress tracking

Within Dataedo interface you can browse progress of documentation and see which objects still need to be described.

Rich description capabilities

Modules

Dataedo enables you to define modules that can represent subject areas or topics and split large databases into smaller, more comprehensible pieces.

Rich text and images

Describe objects and modules using Word-like rich text editors. Paste existing documentation, diagrams and images.

Custom metadata fields

You can add custom plain text fields to almost any data element and document who data owner is, whether column holds sensitive data, what the source of the data is or what is the expected format and so on.

Aliases

Names of physical database objects can often be misleading and confusing. You can provide aliases for data elements (e.g. table or column) making it more comprehensible.

Enterprise class solution

Repository

Dataedo keeps all its data in open repository that is a plain documented SQL database. This repository can be used to keep documentation for all your databases. Use SQL to read and write metadata.

Search

Search feature enables you to documentation for keywords.

Automation

You automate documentation process and incorporate it into your development and maintenance procedures. Run import and export from command line or run custom scritps triggered with events.

Extended properties

Dataedo reads and writes descriptions and extended properties to your database. You can read and save documentation you create.

Import from external sources Planned

Dataedo will have database interface that allows you to import metadata from other external sources like unsupported databases, metadata repositories or data modeling tools.

Multiple environments

Set up different repositories for different environments - Dev/UAT/Live or various versions of your system and copy metadata across them.

Manage permissions Planned

Define access permissions to each database in the repository.

No data in cloud

All data kept secure in your network on your servers.

Work offline

Documentation can be performed offline, without access to live databases.

Intuitive UI

Modern, intuitive desktop user interface.

Learn more about Dataedo