Discover and document table relationships
Do you know table relationships in your databases?
We did a research and it turned out that 75% of databases don't have foreign keys. This is also the case for major applications from leading vendors. Chance is your databases are also missing foreign keys and without them it is often difficult to understand data model and table relationships. And without that it is very hard and risky to do any reporting, BI or database development.
Import existing keys and define the missing ones
Dataedo reads foreign keys form database schema to the repository and saves this information in its repository. Users are able to add missing foreign keys for documentation purposes directly in the repository without interfering with the database. This gives consistent definition of relationships between tables in your database.
Document views relationships too
You can define relationships not only between tables but views too.
Graphical and tabular view
Dataedo keeps one consistent data model for table relationships for diagrams and data dictionary and allows you to access the same information in multiple views.
Table of columns:
Table of relations:
What makes Dataedo stand out from other tools is the ability to define cross-database table relationships which are not supported by many DBMS platforms.