Database documentation tool

Do you really understand your databases?

You can connect to a database and see its structure (tables, columns, etc.), but can you understand it? Add human readable descriptions to this cryptic language in a convenient documentation.

Understand, document and visualize table relationships

Understanding relationships between tables is crucial for any querying and development of any database. Those relationships are often less than obvious and foreign key (FK) constraints are rarely defined (for a number of reasons). You are often left with guesswork or help from someone “who knows”.

But it doesn’t have to be that way. Let Dataedo extract what FK constraints there are in your database and capture all the other relationships only known to people in your team. So that no one needs to be guessing.

  • Extract foreign keys
  • Define additional table relationships
  • Visualize table relationships in ERDs

Describe data elements

Data structures in real databases are often confusing. There’s a number of reasons for this. Dataedo provides your team with a place to capture descriptions of each data element so that you do not need to guess what ‘A’ value in status field means, is order.date the date order was entered in the system or placed by customer and what the heck does attribute1 mean...

  • Provide descriptions for tables, columns, functions, procedures and more
  • Provide meaningful aliases
  • Add additional custom fields

Organize large database with subject areas

Real databases have hundreds or even thousands of tables. It is really hard to find a table with data you need or figure out what is this particular table used for. Dataedo helps you manage this complexity with so called “modules”, which you can think of as folders organizing objects in your database.

Generate and share complete database documentation in minutes

Share complete documentation of your database ecosystem, including data dictionary, diagrams, code, dependencies and more, in searchable and interactive HTML that does not require dedicated server.

Capture tribal knowledge in metadata repository

There is no single person in your team or organization that knows it all. Dataedo’s shared metadata repository allows your entire team to collectively capture and preserve what you know about your databases.

More capabilities

All databases in one repository

Define cross database table relationships

Description suggestions

Track progress

Automate and integrate with your development process

Easy to keep documentation up to date with database changes

Easy and smart import of changes from database

Document different environments - UAT/DEV

Local in your network

Now, everyone can understand your databases

Use cases

Application Development

Allow every developer to grasp data models quickly without guesswork and unnecessary questions.

Data Warehousing

Provide useful documentation of your data warehouse and facilitate better use of it throughout the organization.

BI & Analytics

Remove friction of reporting and analytics by making data structures and data clear for everyone.

Legacy Databases

Discover structure of your legacy databases and document them as you learn, so that the other people do not have to learn the same things over and over again.

ERP/CRM

Make complex and generic ERP databases manageable and meaningful for people in your organization.

Data Migration

Document and understand source and destination databases before the migration.

Development Outsourcing

Communicate and secure work you outsourced with useful and accessible database documentation.

Works with all your databases

Resources

By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.
Accept