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 Microsoft SQL Server Analysis Services (SSAS)
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: |
|
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: |
|
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.