When people hear about iCEDQ, the first reaction is… “Hey, I already have a data quality tool! Why do I need iCEDQ?” In this article let’s contrast iCEDQ with any other data quality tools available in the market.

What is iCEDQ?

iCEDQ is a Quality Assurance and Test Automation platform for data-centric projects and processes such as data warehouse, CRM, data migration & conversion, ETL. It certifies the ETL processes or migration by effective ETL testing and data migration testing. The product can be further used for monitoring the data processes in production. The product emphasizes mainly on process quality.

The major difference between iCEDQ & other Data Quality tools is the purpose they serve. iCEDQ is a test automation platform for process quality whereas other Data Quality tools are a combination of data profiling & fixing/ correction tool used in production.  A breakdown of all the features is given below:

icedq platform vs data quality tools

 Items

iCEDQ 

Data Quality Tools 

 Type of ToolQuality Assurance Tool iCEDQ is a QA tool, purpose built for testing data-centric projects and systems such as ETL.

Other QA tool: HP Quality Center, QTP, selenium, etc.

Data Quality Tool It is a data profiling & data correction tool.

Other tools in the class: Trillium, Informatica

Environment/Phase in which the tool is used Non-production environment (Dev/QA Phase) to test, validate and reconcile the data between/ across files and databases. Production phase to fix the data on day to day basis in conjunction with the ETL tool.
Use cases of the tool1. ETL Development/Testing

2. Data Migration & System Conversion Testing

3. Production Data Monitoring & Compliance

1. Data profiling in early stages of the project.

2. Data fixing in a production environment.

Features

 Items

iCEDQ 

Data Quality Tools 

Requirements and Test Case ManagementYes.

The platform supports requirements and test cases management as well as linking them to physical rules (tests) to define the success or the failure of the ETL Process

No
Data ProfilingNoYes.

The tool discovers the patterns in data, their values, and relationships and reports any data anomalies. Used for analysis and understanding of data.

ETL process TestingYes.

The tool support creation of rules (tests) that can validate/ test an ETL process. This is based on the principle “Incoming data + Transformation rule = Output Data”

No
Data Correction and Standardization NoYes.

The tool is used to run “cleanup” task against last data sets. It uses different rules to recognize data issues and apply the correct rules based on context to change/ update/ delete the actual data.

Data Match and Merge NoYes.

The tool allows to identify matching records and optionally link them or merge matched records based on survivor ship rules

Data Validation TestingYes.

The tool allows to identify matching records and optionally link them or merge matched records based on survivor ship rules

 No
Data Migration TestingYes.

The tool allows to identify matching records and optionally link them or merge matched records based on survivor ship rules

 No