Dataedo is a powerful tool for documenting database schemas / creating data dictionaries.
Dataedo is a team of software and database developers with 10+ years of experience with SQL Server and Oracle database design, development and maintenance. They’ve worked with transactional systems, ERP/CRM, web applications and data warehouses, both third party and their own. In many of those projects, they lacked proper documentation, communication and effective transfer of knowledge which led them to the development of Dataedo.
Add More Metadata – Add Value To Documentation
Users can define virtual relationships between tables and virtual unique keys – the ones that aren’t defined in the database but those rules should apply. They can define relationships even with views.
Large databases can be split into logical modules which makes them easier to analyze, understand and document.
Dataedo is like having word processor connected to your database. You can document your databases using rich text with images. You can write pages of formatted text and attach diagrams, charts or whatever describes your point best. And you can do that for each object.
You can describe any element of any object – relationship, trigger, parameter and many more.
Quick Schema Update
Once anything changes in your documented databases you can sync all the changes with couple clicks.
Useful And Aesthetic Export
What makes Dataedo different is that output documentation – printable PDF or interactive HTML is not full with meaningless details – anything that was found in DBMS metadata that but useful, clear and aesthetic manner. Something you would like to share with others and would recommend as the best reference.
Using many of the database tools isn’t the best of experiences, it can be frustrating. Dataedo has clean, simple and intuitive UI that will help you focus on what is most important – properly describing your databases.
All documentation is stored in global repository and all your team can work on it concurrently.