SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data quality tools
Data quality tools measure how good and useful a data set is to serve its intended purpose. High quality data can lead to better decision-making and faster insights as well as reduce the costs of identifying and dealing with bad data in the system. It can also save time and allow companies to focus on more important tasks.
Dataedo
Dataedo is a data governance & data catalog tool that helps you ensure data quality while documenting data. It allows you to understand where your data is coming from through data lineage, peak into values itself to validate quality with data profiling, and gather invaluable feedback from the community.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Global IDs Data Quality Suite
Global IDs Data Quality Suite ensures the quality of the data by establishing control points and read-only quality controls at the database level. It continuously monitors quality metrics, while it also automates control generation for critical data elements across all kinds of data sources.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Datactics
Datactics is a data quality tool that provides a comprehensive set of data quality operations to profile, measure, clean, de-duplicate, and match multiple data types. It lets you gain deep insights into the quality of data through rich visualizations in off-the-shelf tools.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Trillium Quality
Trillium Quality rapidly transform high-volume, disconnected data into trusted and actionable business insights with scalable enterprise data quality. It has been designed to run natively in cloud or on-premises big data environments, ensuring your business information is integrated, fit-for-purpose, and accessible across the enterprise, regardless of volume.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
SAS Data Quality
SAS Data Quality is a comprehensive tool that meets all the data quality requirements of a business. It makes it easy to profile and identify problems, preview data, and set up repeatable processes to maintain a high level of data quality.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Oracle Data Profiling and Data Quality for Data Integrator
Oracle Data Quality for Data Integrator is a comprehensive award-winning data quality platform that meets even the most complex data quality requirements. Oracle Data Quality addresses the enterprise data quality needs of all projects, including data warehousing and business intelligence, master data management, data integration, migration, service-oriented integration processes.
| Commercial: | Free |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Innovative Systems Enlighten
Enlighten is an integrated data quality suite that offers customizable and comprehensive solutions for any size organization. It provides a wide range of capabilities including data profiling and standardization, cleansing, linking and deduplicating records, monitoring data quality over time, validating addresses, and geocoding.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Open Source Data Quality and Profiling
Open Source Data Quality and Profiling tool is an open source project dedicated to data quality and data preparation solutions. This tool is developing high performance integrated data management platform which will seamlessly do data integration, data profiling, data quality, data preparation, dummy data creation, meta data discovery, anomaly discovery, data cleansing, reporting, and analytic.
| Commercial: | Free |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Uniserv Data Cleansing
Data Cleansing is the Uniserv product that enables you to ensure data quality by performing highly-efficient cleansing during batch processing. The cleansing tool can, e.g., extract data required from source systems through connectors, cleanse postal data, enrich data with supplementary information, and identify duplicates (i.e., their complex consolidation).
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
IBM InfoSphere QualityStage
IBM InfoSphere QualityStage is designed to support your data quality and information governance initiatives. It enables you to investigate, cleanse and manage your data, helping you maintain consistent views of key entities. It provides capabilities including data profiling, standardization, probabilistic matching, and data enrichment.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Talend Data Quality
As an integral part of Talend Data Fabric, Talend Data Quality profiles, cleans, and masks data in real time. It lets you quickly identify data quality issues, discover hidden patterns, and spot anomalies through summary statistics and graphical representations.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
DataMatch Enterprise
Data Ladder’s DataMatch Enterprise is a full-fledged data quality solution that enables organizations to perform key data management operations – including, but not limited to: data profiling, data cleansing, data preparation, data standardization and most importantly, data matching.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
DQLabs
DQLabs.ai is an augmented data quality platform to manage your entire data quality life cycle. With ML and self-learning capabilities, organizations can measure, monitor, remediate and improve data quality across any type of data – all in one agile, innovative self-service platform.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Trifacta
Trifacta is an open and interactive cloud platform for data engineers and analysts to collaboratively profile, prepare, and pipeline data for analytics and machine learning. It presents automated visual representations of data based upon its content in the most compelling visual profile. In addition, every profile is completely interactive, allowing the user to simply select certain elements of the profile to prompt transformation suggestions.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
WinPure Clean & Match
WinPure Clean & Match is a complete data quality, cleansing, matching, and de-duplication software suite for your mailing lists, databases, spreadsheets, CRM's, etc. It lets you instantly fix data quality issues, as it scans each data list and provides over 30 different statistics ranging from % filled/empty cells to most common values & counts. It also features red & amber coloring to highlight potential data quality issues.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Data quality tools are the scripts that support the data quality processes and they heavily rely on identification, understanding, and correction of data errors. Data quality tool enhances the accuracy of the data and helps to ensure good data governance all across the data-driven cycle.
The common functions that each data quality tools must perform are:
• Data profiling
• Data monitoring
• Parsing
• Standardization
• Data enrichment
• Data cleansing
Choosing the right data quality tool is essential and impacts the final results. To help you with the right selection, we prepared a list of tools that will assist you with maintaining a high level of data quality.