Data Dictionary & ERD creator
and Word Processor in one tool

Have a database? Document it with Dataedo!

Every year amount of data and databases in organizations grows. There is an ever increasing need to access data and yet so many database aren't documented.
Software developers, support consultants, data warehouse developers and data analysts waste time trying to figure out where to find and how to query data. And even worse, they make mistakes.

There is a solution to this problem - comprehensive, useful database documentation. Document your databases and avoid guesswork and save time and money.

Export to elegant documents or interactive HTML

How are we better?

Complete solution
Data dictionary, Entity Relationship Diagrams and rich text descriptions with images in one tool. No need to copy and merge.

We support all major databases
Most of the tools support only a single database engine (usually SQL Server). With our tool you can document SQL Server, Oracle and MySQL databases in one repository.

Teamwork by design
Dataedo has been designed with teamwork in mind - gather your knowledge across your organization. Or beyond.

More descriptive metadata available
Ability to document missing foreign keys, unique keys and describe almost anything.

Focused on usefulness, not on data
Many tools out there just extracts metadata from the database. We asked what would bring most value to your documentation.

Elegant exports
PDF documents are ready to be sent to customers, HTML export can be published as is on the Internet.

Don't interfere with your databases
Metadata is not saved in the database itself. It is saved in a file or repository. There is no write back to the database. Documentation writer doesn't even need to have access to the documented database at all.

Works with all your databases

Software Development

Whether you are developing web, desktop or mobile application, as long as you use database you should document it.

ERP, CRM

Packaged applications like ERP, CRM, SCM or similar have huge databases with plenty of large tables. And they are full of key data. Data Dictionary can help you make use of that data.

Reporting

When you are reporting from databases, regardless of whether they are designed by you or not, you should document database schema to ease creating reports and avoid mistakes.

Data Warehousing

Data warehouses are all about querying and analyzing data. And no matter what BI or reporting tool you use you need to provide a comprehensive documentation of the data structures. This is where documentation is a deliverable in its own rights.

Agile Development

Agile development is about constant change. Dataedo can help your team constantly develop databases and make communication and documentation easier.

Data Migration

Moving data from one database to another is a challenge. You really need to understand data and its structure, both - the source and the destination. This is where data dictionary is a must have. Use Dataedo to document both schemas.

Reverse Engineering Legacy Databases

Often there are in your organization databases you need to report from or integrate with and there's no one from original development team anymore. This is where you have to discover and learn the database yourself. Don't lose this precious information. Document as you do.

System Maintenance

Whenever you maintain a system that has a database you are faced with requests and issues where you need to look directly into database. But do you know where to look? Do you know how to query data? Have databases you maintain documented and update it as you learn. This will save you time in the future.

Database Owners

Whether your organization develops or maintains your databases itself or with a third party it is in your best interest to have them documented. Get the right people do it now till they are available. We have the tool.

Download

What customers say about us

I use Dataedo to assist me in documenting a complex enterprise application database. It has saved me a lot of time and proved to be great value for the amount of time it saved me. Dataedo is very easy to use but powerful, works well with SQL Server and produces nice output in all formats. Ideally I would like our team to use Dataedo for all database documentation.

We use Dataedo for documenting the database of our main software. It’s a central reference for the developers and the analysts and we share Data Dictionary with third parties who develop BI system. What I like about it is that it's easy to find out what’s not documented and a well-done Data-Dictionary in PDF. I would definitely recommend it to others.

Dataedo has many features other tools are lacking – ability to document relations that are not set in the DB, rich text descriptions, tracking progress at a glance, grouping objects into topics and keeping track of decommissioned/renamed columns. I would definitely recommend Dataedo to others. It is a great tool and they are very responsive which counts for a lot.

Dataedo is an easy tool to make a functional and elegant documentation. I like the fact that it stores documentation in a Dataedo repository, outside the documented database. I would recommend it to others.