iCEDQ Standard Edition

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

Play
Play
previous arrownext arrow
Slider

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
Standard Editions - iCEDQ

How does Standard Edition work?

iCEDQ Engine-iCEDQ

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

Alerts and Notifications-iCEDQ

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 with Jira and Jenkins-iCEDQ

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-iCEDQ

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.

Built-in Scheduler-iCEDQ

Built-in Scheduler

Now schedule all your tests in advance, iCEDQ standard edition supports daily, weekly and monthly job scheduling. You can run jobs offline also.

Regression Testing Suite-iCEDQ

Regression Testing Suite

iCEDQ Standard Edition supports creation of regression testing packs by combining multiple rules. You can also store batches for future use.

Alerts and Notifications-iCEDQ

Alerts and Notifications

It connects with users via email notifications and notifies them about success or failure of a job. It also notifies for scheduling tool alerts.

Getting started is easy

Be up and running in minutes.