Data quality tools for MySQL

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: No
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: No
Free edition: No
Dataedo Data Community
Dataedo Data Lineage
Dataedo Data Profiling

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: No
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: Yes
Free edition: No

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: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: No

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: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: No

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: Yes
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: Yes
Free edition: Yes

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: Yes
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: Yes
Free edition: Yes

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: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: No

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: Yes
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: No
Free edition: No

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: Yes
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: Yes
Free edition: No

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: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: Yes

DataCleaner

DataCleaner is a premier open source data quality solution. The heart of DataCleaner is a strong data profiling engine for discovering and analyzing the quality of your data. Find the patterns, missing values, character sets, and other characteristics of your data values.

Commercial: Free
Data cleansing: Yes
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: No
Free edition: Yes

BigID

BigID offers actionable data intelligence by empowering you to find, classify, catalog, profile and get context for all your data in the cloud or data-center, at-rest or in-motion, structured or unstructured at petabyte scale. It lets you identify sensitive data using hundreds of pre-built NLP, Deep Learning, and pattern classifiers.

Commercial: Commercial
Data cleansing: No
Data Discovery & Search: Yes
Data Profiling: Yes
Data standarization: No
Free edition: No

StarDQ

StarDQ is a powerful enterprise solution for profiling, cleansing, augmenting and standardizing the data to significantly improve returns on corporate intelligence initiatives. It can transform and combine disparate data, remove inaccuracies, standardize on common values, parse values and cleanse unclean data to create a strategic, trustworthy, valuable asset that enhances decision making power.

Commercial: Commercial
Data cleansing: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: No

Infogix Data360 DQ+

Infogix Data360 DQ+ is an enterprise data quality solution that automates data quality checks across the entire data supply chain from the time information enters your organization throughout its whole journey. You can score the likelihood of possible inaccuracies based on historical data characteristics and issue reconciliations by leveraging machine learning algorithms.

Commercial: Commercial
Data cleansing: No
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: No
Free edition: No

SAP Master Data Governance

SAP Master Data Governance improves the quality and consistency of information across your organization by consolidating and centrally governing the master data lifecycle. It empowers you to collaboratively describe, catalog, and implement rules for data quality evaluation. Initiate and schedule quality evaluations and manage evaluation results. In addition, you can overview current data quality status and KPIs. In short, it lets you define, monitor, improve data quality.

Commercial: Commercial
Data cleansing: Yes
Data Discovery & Search: No
Data Profiling: Yes
Data standarization: Yes
Free edition: No


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.