Data Dictionary
Create and maintain a data dictionary of your databases - a description of all tables, columns and relationships so that every item of data is understood by everyone involved.
Reverse engineer and document your SQL Server, Oracle and MySQL databases
Download Free Tool Try ProEvery year amount of data and databases in organizations grows. There is an ever increasing need to access data and yet so many databases 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.
Preserve knowledge
Eliminate guesswork
Save time
Reduce bottlenecks
Be more independent of people
Improve communication
Improve onboarding
Avoid errors
Create and maintain a data dictionary of your databases - a description of all tables, columns and relationships so that every item of data is understood by everyone involved.
Visualize your databases schemas with Entity Relationship Diagrams so that everyone can quickly understand key tables and their relationships.
Document procedures, functions and triggers to make database development more controlled.
Even single databases consist of plenty database objects. To help you understand it split it into smaller comprehensible pieces.
Database structure changes all the time. With Dataedo you can update changes in your documentation with one click.
When as important information as tables relation or unique constraint is not defined in your database you can add it in your repository just as if it was.
Write your documentation using rich text and images. Powerful mixture of word processor and database manager.
You can track progress of documentation as a whole, by module, by type and for each single object. This will help you get the job done.
Enable your team work together on documentation. Dataedo can hold all data in global repository.
Generate meaningful printable PDF documents using rich text, images and your Entity Relationship Diagrams.
Generate interactive and intuitive data dictionary with rich text, images and Entity Relationship Diagrams.
Publish online and share with your team or community.
What makes us different from other data dictionary tools?
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.
Connect to your database and Dataedo will read your database schema - all tables, views, columns etc - and import it into your documentation repository.
Describe all data elements (tables, views, columns, relations etc.). Dataedo reads comments and descriptions from your database.
Export to meaningful documents or interactive HTML and publish them in your network or online.
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.Matthew Boler
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.Etienne Fritsch
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.Lenka Horanska
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.Jordi Casas
Health Insurance Provider
Software Developer
| Perpetual license | Price | Volume discount |
| Pro 5 | 399 | 60 |
|
||
| Annual license | Price | Volume discount |
| Pro - 1 year | 239 | 35 |
|
||
| Free | Standard | Pro | ||
|---|---|---|---|---|
| Limited functionality for simple documentations | Advanced Data Dictionary for Oracle, SQL Server and MySQL | Complete database documentation tool - Data Dictionary, ERD and Dependencies | ||
| Repository/file | ||||
| Documented databases per file/repository | 1 | Unlimited | Unlimited | |
| Supported databases | ||||
| SQL Server | ||||
| Oracle | ||||
| MySQL | ||||
| Database objects | ||||
| Tables, Views | ||||
| Functions, Procedures, Triggers | ||||
| Relations (FKs) | ||||
| Unique keys | ||||
| Dependencies | ||||
User-defined objects  |
||||
| Modules |
||||
| Table/view relations (FKs) |
||||
| Unique keys |
||||
| Documentation management | ||||
| Search | ||||
| Progress tracking | Limited |
Limited |
||
| Diagrams | ||||
| Entity Relationship Diagrams | ||||
| Documentation export | ||||
| HTML | ||||
| Excel | ||||
| Customize PDF | ||||
| Integration | ||||
| Run from command line | ||||
| Free | 299 per user Perpetual License for Dataedo 5 | 399 per user Perpetual License for Dataedo 5 | ||
| Download | Buy | Buy | ||
|
179
per user (1 year)
1 Year License for all versions (No automatic renewals) |
239
per user (1 year)
1 Year License for all versions (No automatic renewals) |
|||
| Buy | Buy | |||
|
Special June Promotion
59
per user (30 days)
30 Days License for all versions Promotion ends on June 30th |
||||
| Buy | ||||
|
Read more about pricing and discounts
or
Get free trial
|
||||
Databases: SQL Server, Oracle, MySQL
Documentations per repository: 1
Database objects: Tables, Views
User-defined objects: Modules
Documentation management: Limited progress tracking report
Diagrams: No
Export: PDF
Integration: No
Free Unlimited users
Download FreeDatabases: SQL Server, Oracle, MySQL
Documentations per repository: Unlimited
Database objects: Tables, Views, Functions, Procedures, Triggers, Relations (FKs), Unique keys
User-defined objects: Modules, Table/view relations (FKs), Unique keys
Documentation management: Limited progress tracking report
Diagrams: No
Export: PDF, HTML, Excel
Integration: No
299 per user Perpetual License for Dataedo Standard 5
179 per user (1 year) 1 Year License for all versions
Read more about pricint and discounts
All prices excluding tax
Databases: SQL Server, Oracle, MySQL
Documentations per repository: Unlimited
Database objects: Tables, Views, Functions, Procedures, Triggers, Relations (FKs), Unique keys, Dependencies
User-defined objects: Modules, Table/view relations (FKs), Unique keys
Documentation management: Full progress tracking report, Search
Diagrams: Enity Relationship Diagrams
Export: PDF, HTML, Excel, Customize PDF
Integration: Run from command line
399 per user Perpetual License for Dataedo Pro 5
239 per user (1 year) 1 Year License for all versions
Read more about pricint and discounts
All prices excluding tax
