Introduction to Dataedo

Dataedo is a powerful database documentation tool for SQL Server, Oracle and MySQL. It enables you to create Data Dictionaries (description of all data elements), creates Entity Relationship Diagrams or documents stored procedures and functions in your databases.

It is a Windows application that connects to existing databases and imports schema, then enables users to provide descriptions and export documentation to PDF, HTML or Excel.

Architecture

• Documented databases - databases that you want to document
• Dataedo Editor - program that enables importing, describing and exporting
• Repository - this is where all documentation is stored (learn about Dataedo repository)
• Exports - exported documentation

Key process

Key process of documenting database with Dataedo looks like this:

1. Import schema from database
2. Describe database elements
3. Export documentation (to PDF or HTML) (optional:)
4. Update documentation when database schema changed
5. Go to 2