Understanding relationships between tables is crucial for querying of a database. Those relationships are often nonobvious as foreign keys are rarely defined in a database schema. Without this information you left with guess work, asking your colleagues, and exposed to errors in your queries.
But it does not have to be that way. Allow Dataedo to extract what foreign keys information is defined in a database and complete the rest in the same format so that you have a complete view of the relationships in your database. No more guessing.
Do you know what attribute1 column means? Is it in use? Or how is due_date calculated? Or what does ‘A’ value in status column mean?
Data structures can be confusing and sometimes misleading and Dataedo allows you to explain meaning and purpose of each data element in your database.
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.
Self-hosted web portal for self-service data & building data community. Create a place where all people in your organization can go to find, learn about, discuss and contribute their findings about data.Learn more
Easily export your documentation into lightweight and easily shareable interactive HTML documents. Self-host them on your drive or any web server.See live sample
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.
Allow every developer to grasp data models quickly without guesswork and unnecessary questions.
Provide useful documentation of your data warehouse and facilitate better use of it throughout the organization.
Remove friction of reporting and analytics by making data structures and data clear for everyone.
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.
Make complex and generic ERP databases manageable and meaningful for people in your organization.
Document and understand source and destination databases before the migration.
Communicate and secure work you outsourced with useful and accessible database documentation.
"We jump started all of our Data Governance efforts using the tool. We documented key databases quickly and easily and published the information to our analyst community."
"Dataedo is improving my work a lot. With documentation, the learning curve is smaller and I can have more time to work."
"Thanks to Dataedo I spent more time figuring out the connection string to the instance than I did running the report. It was a great experience."
"It helps us document the 'why' we built it the way we did. The tool is very intuitive to work with, and we use it continuously."
"Dataedo is an easy to use facility for managing basic metadata centrally and producing enhanced data dictionaries."
"Dataedo helps developers to find descriptions for data very quickly. Seeing documentation progress with every release is really helpful."