Data Dictionary

Get a detailed view of your data

Dataedo has been named a 2020 Gartner Peer Insights Customers' Choice for Metadata Management Solutions. Read our reviews here.

Provide meaning to enigmatic data structures

  • Decrypt table and column names with business friendly aliases
  • Provide meaning and purpose of data assets with descriptions
  • Describe data with up to 100 custom fields

Capture and document data relationships

Relationships between tables and data sets is crucial for any reporting and analytics. Those relationships are often unclear and can span across databases. Dataedo reads foreign keys from the database to the data dictionary, allows you to extend this information with manually defined relationships, and visualizes them with ER diagrams.

  • Extract foreign keys
  • Define additional table relationships
  • Visualize table relationships in ERDs
  • Define relationships across databases and data sets

Organize large databases with subject areas

Data sources in your organization can hold hundreds or thousands of tables and data structures. It might be hard or impossible to make sense of this. Dataedo helps you manage this complexity by allowing you to create subject areas and use them to organize large data sets.

Provide more context and meaning to assets with glossary terms

Dataedo allows you to map data dictionary elements to terms in integrated business glossary – a global list of terms and definitions in your organization. This allows you to provide more meaning and definitions to data, add a voice from the business to data assets and make the documentation of data structures easier for IT.

Capture tribal knowledge

Dataedo makes it easy to capture tribal knowledge from your team and share it across the organization with central metadata repository.

Scan your data sources and build enterprise data dictionary automatically

Dataedo allows you to connect and scan metadata from multiple sources and build data dictionary automatically in a couple of minutes.

  • Relational databases
  • Cloud databases
  • Data warehouses
  • Document databases Planned
  • JSON and XML documents Planned
  • CSV data sets Planned
  • Data Lakes Planned
  • Any data source with ODBC

Share documentation easily

It takes a couple of clicks to import data structures from your databases and share in convenient interactive HTML documentation.

Works with all your databases

Features

Easy import of schema changes

It’s easy to keep data dictionary up to date with data sources – just connect again and metadata will be synchronized.

Automation with command line

Automate and schedule metadata imports and documentation shares with command line.

Safe for databases

Dataedo does not impact data structures in your source databases. All documentation takes place in the repository.

On premises

Data is safe in your environment locked in SQL Server/Azure database. Your metadata is not stored on our servers

Benefits

Unlock data in your organization

Data dictionary decrypts data in your organization and often is necessary to be able to use it.

Democratize and promote use of data

With data easier to find and understand, business can work with data on their own, without help of from IT.

Get power of tribal knowledge

No single person knows it all. Get people that understand your data and allow them to collaboratively build documentation of your data in central repository.

Protect knowledge

Did you ever wonder what would happen to your data, analytics, BI, data warehouse if key people left? Would new people be able to take over, how long would that take, and how much would that cost? Data dictionary serves and documentation that protects your knowledge and allows to pass it easily to new people.

Be less dependent on suppliers and key people

Are some people or partners the only gateway to some of your data? Get independence and ask all your people and teams working with and building data assets to get them documented with Dataedo. With that you will decide who and how will make use of your data.

Improve quality of data and reporting

Understanding purpose of tables and columns and how to join tables reduces risk of bugs in SQL and getting incorrect, misleading results.

Remove the (IT) bottleneck of your analytics

With documentation of data, business and analyst community can find and use the data without the support of the IT.

Free up time from key people

When business can be self-reliant, those key data gurus can now spend less time answering questions and preparing simple queries, and can on high value-added work.

Improve performance of your analytics

Allow your people to spend less time looking for data and trying to make sense of it and, and spend more time getting insights and finding patterns.

Improve communication

Central reference documentation of data improves communication between all the parties involved - architects, developers, analysts, developers, business, and various teams and suppliers.

Grow your team hustle-free

Allow new hires get to speed, independently, with comprehensive documentation.

Avoid situations like these:

Use cases

Data Warehousing & BI

Describe the purpose of data warehouse tables, columns and show table relationships for better BI and self-service analytics and reporting.

Self-service Analytics

Share documentation of data sources - purpose of tables and columns and relationships between them to allow self-service analytics to business and analyst community.

Database Development

Document databases as you design them and share the design with every developer.

Legacy Databases

Gather and store knowledge about legacy databases as you discover and learn them.

Data Governance

Build and share metadata repository of data assets in your organization.

Data Migration

Document both, source and destination, databases so architects and developers can design and understand the logic for the migration.

Enterprise Architecture

Document complete data model of your organization data assets and explain relationships between databases.

Development Outsourcing

Whenever you are outsourcing development and there is a data component secure yourself with documentation so you can use the data in the future.

ERP, CRM / Applications

Packaged applications have large, complex and confusing databases. Vendor documentation only includes standard elements. Document customizations and use specific to your organization.

Our customers

Deborah Crane
Data Quality Manager

Charter Court Financial Services

"Dataedo is an easy to use facility for managing basic metadata centrally and producing enhanced data dictionaries. Initially we wanted to use it for a single set of system documentation, but we will now employ it for scheduled metadata updates along with multi-user maintenance. I would recommend Dataedo to anyone with similar requirements, and in fact already have."
Lenka Horanska
Business Intelligence Analyst

Accuro Health Insurance

"Dataedo has many features other tools are lacking - ability to document relations that are not set in the DB, rich text descriptions, tracking progress at a glance, grouping objects into topics and keeping track of decommissioned/renamed columns. I would definitely recommend Dataedo to others. It is a great tool."
Millie Kristiansen
Manager, Data Solutions

Healthy Directions, LLC

"Healthy Directions is a data driven organization and relies on my team to produce ETL'd data for reporting and analysis. Dataedo has been the perfect tool that has helped the team and organization in understanding the datasets with it's easy to use tool and database documentation. Even non-data users are able to understand the database structure. It's a great tool and have already recommended to others."
Etienne Fritsch
Head of Development

EPSILON Software Assistance SA

"We use Dataedo for documenting the database of our main software. It's a central reference for the developers and the analysts and we share Data Dictionary with third parties who develop BI system. What I like about it is that it's easy to find out what's not documented and a well-done Data-Dictionary in PDF. I would definitely recommend it to others."

Get results in minutes

1

Install

2

Set up a repository

3

Import database

4

Export & share

Resources

By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
Accept