Reference Data Management tools for Excel

Reference data management tools help manage and bring consistency to your data. They enable business users to aggregate data quickly and understand the overall condition of the business. Reference data tends to be overlooked in many enterprises but although its amount in most organizations is relatively small, it can cause a major difference in data management.

Dataedo

Dataedo is an on-premises data catalog & metadata management tool. With Dataedo you can catalog, document, and understand your data. It also allows you to keep all your reference data in one place to easily access, distribute, and update it across different data sources.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: No
Reference Data Management

Ataccama Reference Data Management

Ataccama Reference Data managment is an intuitive, feature-rich web app for your reference data. It lets you maintain valid reference data in a centrally managed solution and provide valid reference data to systems and users. Some of its key features include data governance, data quality management, error-free authoring & editing, data integration & warehousing, etc.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: Yes

Informatica Reference 360

Informatica Reference 360 is a cloud-based reference data management solution. It offers easy to use and configurable dashboard for managing the complete lifecycle of reference data. It lets you manage simple and complex hierarchies, while offers flexibility to model simple and complex reference codes and relationships.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: No

Software AG’s webMethods OneData

Software AG’s webMethods OneData master data management solutions provide “one version of the truth” when it comes to data, right out of the box. In addition to multi-domain master data management, webMethods OneData enables you to manage customer, reference, and hierarchy data. It provides a rich feature set that includes tools for analysis, reporting, modeling, acquisition and deployment, repository, and management of data.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: No

Collibra Data Governance

Collibra Data Governance is a comprehensive data governance solution that also serves effectively in reference data management. With a common understanding of how data is organized, classified, and connected, Collibra empowers users to reconcile data between systems for more accurate reporting and analysis.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: No

ibi (Information Builders)

ibi (Information Builders) is an all-in-one data platform for integration, quality, management, governance. Sophisticated governed data enables flexible management of reference data across the organization. It makes you effective stewards of your own data by putting in place centralized data collaboration, data lineage support, and a formalized glossary of accepted terms.

Commercial: Commercial
Data Quality Management: Yes
Data validation: No
Free edition: No

erwin Data Catalog

The erwin Data Catalog Suite efficiently integrates and activates data in a single, unified catalog in accordance with business requirements. One of its key components is erwin Reference Data Manager, which manages reference data of all types to provide visibility, control and consistency, reduce costs, and ensure accurate and consistent use across enterprise systems.

Commercial: Commercial
Data Quality Management: Yes
Data validation: Yes
Free edition: No

Teradata Master Data Management (MDM)

Teradata Master Data Management (MDM) drives significant ROI using consistent reference data to establish an accurate analytical data foundation. It is a single solution that supports multiple domains, eliminating the need to buy multiple solutions, product, and reference data. It provides a central framework with complete support of a workflow and process-driven data governance environment.

Commercial: Commercial
Data Quality Management: No
Data validation: Yes
Free edition: No

Reference data is the most shared class of data in an entire organization. It impacts daily operations and contains valuable insights. In order to deliver its value, reference data management tools allow access and distribution of reference data across multiple systems and help data stewards populate and manage it over time.

Reference data management tools are not only automating workflows but also:

Minimizing errors and inefficiencies,

Reducing data and operational management cost,

Mapping data,

Comparing data from various parts of the organization.

Presented above is the list of paid solutions for reference data management that can also take care of data quality management and data validation.