Reference Data Management Tool

Data Catalog with Reference Data

A central catalog and documentation of your data including Reference Data so that everyone can understand your data.

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

What is Reference Data?

Reference data is data that helps categorize/classify/label other data. It’s sounds abstract but it’s really simple. Think about that every time you have seen a dropdown, checkbox or a radio button. This is usually used for simple classification. Reference data is commonly known by other names - codes, lookups, lists of values, enums or domains. It’s a subset of Master Data and should also be managed for better data quality, integration and analytics.

Examples of reference data:

Countries icon

Countries

Accounts icon

Accounts

Currencies icon

Currencies

Units of measure icon

Units of measure

Departments icon

Departments

Types (e.g. document) icon

Types (e.g. document)

Statuses (e.g. order) icon

Statuses (e.g. order)

Calendar (e.g. quarters) icon

Calendar (e.g. quarters)

and many more… icon

and many more…

Understand reference data (lookups, codes) with simple documentation

dataedo
Define lookups and their values

Lookup is a collection of values/codes. Every database is full of lookups. Examples: currencies, country codes, document getTypes, order statuses and many more. Dataedo allows you to define those lookups and document their allowed values.

dataedo
Explain codes/values

Allow everyone in your organization to understand reference data/lookup by explaining values with titles, descriptions and custom fields.

dataedo
Extract values from database or define manually

Create a list of values manually or build lookups automatically from your data sources.

dataedo
Link lookups to multiple columns

Define multiple instances of columns containing a particular lookup (think currency for example).

dataedo
See value row count in each table/column

See popularity of particular values in specific columns to better understand your data and its data quality.

dataedo
Load new values from the source

Dataedo allows you to load new values from the source database into a “For review” section.

dataedo
Workflow for loaded values

Approve or reject values imported from the source.

dataedo
Provide cleansing rules for rejected values

You can provide cleansing rules for rejected values that were imported from the sources (by mapping incorrect values to the correct ones). Use this metadata for data cleansing.

dataedo
Link lookups glossary terms

Expand documentation of business terms by documenting it’s domain of values.

Improve data quality & reporting

All Reference data in one central repository

Document reference data from different columns, tables and data sources in a single place. Share complete data documentation with your team.

Dataedo
Dataedo

Understand data quality and define cleansing rules

Easily identify duplicates, wrong values and define cleasing rules for your source data.

Better reporting & analytics

Know what values are allowed for different columns. Identify mistakes in reports easily. 

Dataedo

Why our customers love Dataedo?

Trusted by:

Start documenting your reference data today

Create a central documentation of reference data from all your data sources and distribute it across teams working with data in your organization.

products/reference-data-management/reference_data_management_web.png image

Try Dataedo Book a demo