iCEDQ Standard Edition

Complete data testing solution, with in-memory rules engine.

iCEDQ Standard Edition is the foundation of all the other editions we offer. It is an in-memory engine built in Java, and it connects to different data sources using JDBC. It supports Data Warehouse Testing, Data Migration Testing, BI Report Testing and Big Data Testing.This ETL Testing platform Standard Edition supports four types of Rules.

Checksum Rule
Validation Rule

Recon Rule
Script Rule

How does Standard Edition work?

In iCEDQ Standard Edition any process of a Rule or Regression Pack occupies one core on the server.

The Rules engine connects to the source and target data system. Based on the type of data source, it will either push down the sorting (database) or will do the sorting in memory (files).
The engine then reads the data as a micro-batch (e.g., 10k rows) in the server memory. First, it identifies missing and matching business keys, and for each matching business key, it validates the transformation checks using expressions. As the engine detects any data issues, it writes them to an exception report.
Once the engine tests one micro-batch, then it brings the next micro-batch into the server memory. This ability allows the Rules engine to compare millions of rows in-memory using a single core on the server. And at the end, the complete exception report is available to the user for analyzing the data issues.

Features

Advanced User Level Security

Apart from system level access, database user level security and LDAP security is also available. You can also limit access to data for specific users.

CI/CD pipeline integration

You can implement DevOps for your data centric project with iCEDQ Standard Edition. It supports Jenkins plugin and has an API for Jira, Bamboo and Git, which results in faster application delivery, enhanced innovation and gives a stable operating environment.

Custom Reporting and Dashboard

It has an embedded custom reporting and dashboarding solution, where you can create custom dashboards, create custom reports, share reports and dashboards. It has HTML-5 Reporting utility, Dashboard utility and is independent of any external tool for this functionality.