Complete data testing solution, with in-memory rules engine.
iCEDQ - ETL Test Automation Platform for Data Lakes & Data Warehouses
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.
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 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.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.