Data Dictionary

Get a detailed view of your data

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

Add Meaning to Your Data

Data dictionary

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

Image shows table relationships in database.

Capture and Document 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 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 Meaning with Business Glossary

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 in Central Repository

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

Build Data Dictionary in Minutes

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
  • JSON and XML documents
  • CSV data sets
  • Data Lakes
  • Any data source with ODBC

Easily share your data dictionary

Dataedo Web Catalog
Dataedo Web Catalog
Interactive web data portal

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
Dataedo Web Catalog
Dataedo HTML Export
Interactive HTML exports

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
Dataedo Web Catalog
PDF & Excel Exports
Export metadata to PDF & Excel

Additionally, you can quickly export your documentation to PDF and Excel files.

See live sample

Features

Easy import of schema changes icon
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 icon
Automation with command line

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

Safe for databases icon
Safe for databases

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

History of changes icon
History of changes

Dataedo stors information about who, when, and how changed the values of descriptions, titles, and custom fields.

On premises icon
On premises

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

Benefits

check
Unlock data in your organization

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

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

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

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

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

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

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

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

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

check
Improve communication

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

check
Grow your team hustle-free

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

Avoid situations like these:

Use cases

Data Warehousing & BI icon
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  icon
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  icon
Database Development

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

Legacy Databases  icon
Legacy Databases

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

Data Governance  icon
Data Governance

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

Data Migration  icon
Data Migration

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

Enterprise Architecture  icon
Enterprise Architecture

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

Development Outsourcing  icon
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  icon
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

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

Deborah Crane
- Data Quality Manager
Charter Court Financial Services
Lenka Horanska

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

Lenka Horanska
- Business Intelligence Analyst
Accuro Health Insurance
Millie Kristiansen

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

Millie Kristiansen
- Manager, Data Solutions
Healthy Directions, LLC
Etienne Fritsch

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

Etienne Fritsch
- Head of Development
EPSILON Software Assistance SA

Get results in minutes

Install

Set up a repository

Import database

Export & share

Why our customers love Dataedo?

Trusted by:

Add meaning to your data with Data Dictionary

Get a detailed view of your data in minutes

products/solutions/er-diagram-web-catalog.png image

Try Dataedo Book a demo