Dataedo is a powerful database documentation tool. It allows you to create data dictionaries (description of all tables, columns and relationships), create ER diagrams, document server scripts (stored procedures, functions and triggers).
It is a desktop application that connects to existing databases and imports schema, then enables users to provide descriptions and export documentation to PDF, HTML or Excel.
Understand your data and share it with others
The main idea behind the creation of Dataedo was the intention to help in understanding the processed data. For this purpose, Dataedo provides features that allows you to import a schema from different database, create documentation with the data, export the documentation to convenient formats and share it with team members.
Correct interpretation is crucial when working with data. Data structures can be confusing and sometimes misleading and Dataedo allows you to explain meaning and purpose of each data element in your database.
Dataedo allows you to annotate data elements, provide significant aliases as well as add extra information to the data structure using custom fileds.
Data dictionaries are a detailed, well-defined set of data (tables) and their fields (columns). The informations contained in them are primarily data type, allowed and default values, constraints, size, relations to other data elements and meaning/purpose of data set and field.
Dataedo has built-in business glossary module - glossary of business terms, their definitions, relationships between each other and mapping to data assets elements. It defines business concepts for an organization or industry and is independent from any specific database or vendor.
In order to work effectively with data, it is very important to understand and correctly interpret it.
A common lack of foreign keys in a database schema only makes it difficult to understand the links between entities.
Dataedo allows you to discover foreign keys from database constraints as well as manually define additional relationships and visualize them with convenient ER Diagrams.
ERDs sample can be found here.
Sensitive Data Discovery and Classification
Data searching is one of the most painstaking processes of working with databases. Without the right tool this task can lead to a waste of a lot of time.
Dataedo has built-in data discovery and classification functions, such as: PII - finds columns PII (Personally Identifiable Information)
GDPR - finds columns potentially holding personal data as defined by European GDPR
More inforamction about Automated Data Discovery and Classification can be found here.
We also offer:
All databases in one repository
Define cross database table relationships
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.