DataCleaner vs Infosys Data Workbench

DataCleaner is an open-source data quality application for profiling, validating, and cleansing data. Its profiling engine identifies patterns, missing values, character sets, and other traits in data values. It works with CSV files, Excel spreadsheets, relational databases, and NoSQL databases. Users can create cleansing rules with search and replace, regular expressions, pattern matching, or custom transformations, and use internal or external reference data to check values. DataCleaner supports batch processing, visual workflows, standardization, validation, enrichment, scheduled runs, and desktop deployment on Linux, macOS, and Windows. Named integrations and connectivity options include Apache Hadoop, Apache Spark, Pentaho Data Integration, and Apache MetaModel. Developers can embed it in other applications or build plugins; the project also describes community extensions, integrations, and shared content. The code is licensed under LGPL. The community edition is free at free. The downloads page lists 5.9.0 as the latest release; release news says version 5.8.1 runs on Java 9 through 17 and is dated February 9, 2022.

Infosys Data Workbench (iDW) combines large-scale data quality operations with lightweight analytical master data management. Its AI-powered core supports data-quality processing, while an Apache Spark core supports high-speed analysis at scale. Users can profile data with machine-learning models, review interactive reports, and validate complex business rules. Cleansing and standardization tools include machine-learning-based enrichment, outlier detection, clustering, and filtering. Master-data functions cover de-duplication, linking, grouping, golden-record generation, and identity resolution.

The product works with JDBC-compliant databases and files, including fixed-width, delimited, and Excel formats. Deployment options include standalone or cluster execution, a web interface, and cloud-ready installation; the listed environments include Windows, Linux/Unix, Azure, and AWS. Jobs can run once or recur, with results in dashboards or downloadable PDF and Excel reports. Infosys lists LDAP authentication, single sign-on, and role-based authorization. Pricing is on request, and Infosys directs interested organizations to its request-for-services form.