Data quality tools for Apache Hive

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 Profiling
Dataedo Data Community
Dataedo Data Lineage

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

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

Informatica Data Quality

Informatica Data Quality ensures end-to-end support for growing data quality needs across users and data types with AI-driven automation. It uses AI-driven insights to automate the most critical tasks and streamline data discovery to increase productivity and effectiveness. It ensures the delivery of high-quality information with data standardization, validation, enrichment, de-duplication, and consolidation capabilities.

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

Aperture Data Studio

Aperture Data Studio combines self-service data quality with globally curated data sets into a single data quality platform. This empowers modern data practitioners to build a consistent, accurate, and holistic view of their consumer data quickly and effortlessly. It lets you set custom workflows for data profiling, cleansing, validation, transformation, enrichment, and deduplication.

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

RightData

RightData is a self-service suite of applications that helps you achieve Data Quality Assurance, Data Integrity Audit and Continuous Data Quality Control with automated validation and reconciliation capabilities.

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

Atlan

Atlan uses DataOps to create a new paradigm for building trust in your data. It auto-generates data quality profiles which make detecting bad data dead easy. From automatic variable type detection & frequency distribution to missing values and outlier detection, Atlan offers everything.

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

Collibra Data Quality

Collibra Data Quality lets you use predictive data quality to improve trust in your data. With predictive, continuous, and self-service data quality, you can centralize and automate data quality workflows to gain better control over your organization's end-to-end data pipelines and streamline analytics processes across the enterprise.

Commercial: Commercial
Data cleansing: Yes
Data Discovery & Search: Yes
Data Profiling: No
Data standarization: No
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.