SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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: |
|
| Data validation: |
|
| Free edition: |
|
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.