DataCleaner – profiling, validating and comparing data

DataCleaner is an open source application for profiling, validating and comparing data. These activities help users administer and monitor data quality in order to ensure that your data is useful and applicable to a business situation.

DataCleaner is the free alternative to software for master data management (MDM) methodologies, data warehousing (DW) projects, statistical research, preparation for extract-transform-load (ETL) activities and more.

DataCleaner is also the flag-ship application of the eobjects.org open source community.

DataCleaner supports a number of different optimization techniques that can be combined in order to make your job execute as quick and efficient as possible.

The software has an attractive graphical user interface and also supports command-line execution using the runjob tool.

Features include:

• Data Profiling – used to calculate and analyse various important measures based on the values of data.
• Data matching.
• Data Validation – the validator will give you a result that can be interpreted as “good” or “bad”, since the validator validates your data.
• Data comparison.
• Dictionary management.
• Pattern analysis.
• Supports read-access to many types of datastores:
  • JDBC compliant databases (Officially tested and supported: Oracle, MySQL, Postgresql, Firebird, SQLite, Hsqldb, Derby/JavaDB).
  • Comma-separated values (.csv) files.
  • Excel (.xls) spreadsheets.
  • XML files.
  • OpenOffice Base (.odb) files.

Website: datacleaner.github.io
Support: Documentation
Developer: eobjects.org
License: GNU Lesser General Public License

DataCleaner is written in Java. Learn Java with our recommended free books and free tutorials.

Return to Data Warehouse Software

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.