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 Amazon Aurora
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
Every database is full of lookups: currencies, country codes, order statuses and more. Dataedo allows you to define those lookups and document their allowed values.
| 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: |
|
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: |
|
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: |
|
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.