Complete data testing solution, with in-memory rules engine.
iCEDQ Standard Edition
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.
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.
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 Standard Edition supports creation of regression testing packs by combining multiple rules. You can also store batches for future use.
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.