Introduction to Dataedo

Applies to: 9.x (current) versions, Article available also for: 8.x, 7.x, 6.x, 5.x

Intro

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.

Key features

Database Documentation

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 Dictionary

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.

Business Glossary

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.

ER Diagrams

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.

More capabilities

We also offer:

  • 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.

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.