Frequently Asked Questions

Get more information about ETL Testing software

FAQ-iCEDQ

Introduction

What is iCEDQ?

iCEDQ is a DataOps testing and monitoring platform designed to identify data issues in or across any data source using our in-memory auditing rules engine.

What does the name iCEDQ stand for?

iCEDQ stands for Integrity Check Engine for Data Quality.

Where is iCEDQ Used?

Organizations use iCEDQ in the development phase for testing ETL, Data Warehouse, Data Migrations, and BI Reports. It is also used in production environments to proactively monitor data issues.

What is DataOps?

DataOps is the application of DevOps principals like CICD, Agile to data-centric projects. 

What are the editions of iCEDQ?

Currently, iCEDQ has three different editions; Standard Edition, High Throughput Edition and Spark Edition.

When was iCEDQ launched?

The first version of iCEDQ was made available in 2008. Since then, we have had multiple releases with newer functionalities and have acquired many enterprise customers. 

The current GA version is 15.x.

Who are your customers?

We are proud to have some of the big fortune 500 companies as our customers. Organizations from different verticals such as Finance, Healthcare, Retail, Manufacturing, Insurance, and Travel use iCEDQ in production and non-production environments.

What are the use cases for iCEDQ?

Below are some of the use cases of iCEDQ.

  1. Big Data Testing
  2. Data Migration Testing
  3. ETL Testing/Data Warehouse Testing
  4. BI Report Testing
  5. Production Monitoring
  6. Data Compliance

How does it scale for the big data?

For Big Data you can use iCEDQ’s Spark Edition where every Rule or Regression Pack is evaluated using Apache Spark cluster. User can scale the performance by scaling the Spark cluster.

How to schedule a demo for iCEDQ?

You can schedule a demo by registering here for the same.

Unique Selling Point

What makes iCEDQ different?

The key differentiator is our in-memory rules engine(s). iCEDQ validates data in the server memory allowing users to test a high volume of data efficiently. iCEDQ also offers an engine based on Apache Spark, which enables users to scale testing of billions of rows on their Spark cluster.

Customer support is also excellent. If you don’t believe it, then sign up for a trial.

What is the difference between iCEDQ vs. other ETL Testing Tools?

While there are many differences between iCEDQ and other ETL Testing Tools, given below are few of which that stand out the most.

  1. iCEDQ evaluates data in memory; it does not load it into any database.
  2. It supports four different types of rules, Recon, Validation, Checksum, and Script.
  3. Users can use SQL + Apache Groovy to create advanced transformation checks.
  4. Users can write Script rules using Apache Groovy or Java.
  5. Governance/ Compliance Users for Governing or Monitoring Production systems

You can also read our artice “iCEDQ Platform vs Data Quality Tools

Do you have Data Migration/ Rule Creation Wizard?

Yes, we do have a utility called Rule-X. It allows users to create rules, regression packs, parameters, and other entities using just an Excel file.

To see Rule-X in action schedule iCEDQ demo.

How does the script rule differ from other tools?

The Script Rule enables a user to automate the testing end to end. Users can write any custom Apache Groovy script or a Java class and execute it from iCEDQ. Below are some of the real-world use cases of Script Rule:

  1. Create tables and insert expected data for testing.
  2. Read a dynamic parameter from a database and pass it to a Rule.
  3. Take a backup of the table and compare it with the actual table post ETL.

Using iCEDQ

During which phase of the project can I used iCEDQ?

You can use iCEDQ in

  • Development phase for Quality Assurance/ Testing
  • Production phase for Data Monitoring/ Compliance

Who should be interested in iCEDQ?

Following groups of users should be interested in iCEDQ

  • Developers for UNIT Testing
  • QA Users for Functional Testing, Non-Functional Testing, Regression Testing
  • QA Managers for Release Management, Sign Off
  • Data Architects, DW Managers to monitor the progress of the project
  • Governance/ Compliance Users for Governing or Monitoring the Production system

What amount of data can be compared using iCEDQ?

You can compare millions of rows with iCEDQ. Depending upon the type of audit rule created, iCEDQ can process anywhere between 10k – 20k rows/ sec.

Can iCEDQ compare a File with a database?

Yes. iCEDQ can compare a Flat File (Delimited/ Fixed Width) or Excel Sheet with any database.

Architecture

Does iCEDQ run on my desktop or server?

The software runs on a server where all the data processing happens. Users can access it through the web app; no client installations needed.

Does it use a database to compare?

No, iCEDQ does not use a database to compare or validate data. It has an in-memory rules engine purely built in Java and Akka.

Does it need a lot of memory?

Not at all. The engine pulls data into memory, in chunks, evaluates it, and keeps on doing that till the complete data set is validated.

How can I scale iCEDQ?

There are multiple ways to scale iCEDQ based on the requirement. Different options are available:

  1. Adding more CPU will allow you to run more Rules in parallel
  2. Using a High Throughput Edition will allow you to install the engine and app on multiple servers. This will make the app Highly available and also include option 1.
  3. Using High Throughput Edition will allow a user to run a Rule on multiple cores, in turn, increasing the performance of an individual Rule
  4. Spark Edition will enable the user to scale the performance of an Individual Rule based on the size of the cluster.

Do you expose any iCEDQ API?

We do expose an API to execute Rules from any external tool for integration. Users can override connections and parameters on runtime using the API allowing them to reuse the Rules.

Can Rules be migrated to across instances of iCEDQ?

Yes. Users can export an individual Rule, a batch of Rules, or a complete project into an export file. And then import it in any instance of iCEDQ.

iCEDQ Installation

What is the installation requirement?

Below are the requirements for installing iCEDQ.

  • Windows or Linux Server
  • Java JDK 1.8 or above
  • Database Schema (Oracle/ MSSQL/ Postgres)

You can take a look at the pre-installation checklist here.

How much memory should I allocate to the iCEDQ server?

We recommend a minimum of 16 GB. You can increase it based on your workload and usage.

How much time does it take to install iCEDQ?

It takes 30-45 mins to install and get iCEDQ up and running.

How complicated is the iCEDQ upgrade?

It is a straightforward, in-place upgrade. We recommend taking a backup of the database repository before the update.

Cloud

Can I install iCEDQ on a cloud?

Yes, you can install iCEDQ on any cloud platform. Customers have installed this on AWS, Azure, and GCP.

Can I connect on-prem data sources from cloud and via-a-vis?

Yes, as long as your VPN allows you to do so. We do not put any restrictions on where you can install and what you can connect too.

What cloud data sources can I connect using iCEDQ?

You can connect to Snowflake, Redshift, S3, and many others. Fnd the complete list here.

Connectivity

How does iCEDQ connect to a data source?

It uses JDBC or JDBC-ODBC bridge to connect to various data sources. Sometimes we built custom connectors using the data source SDK in Java. 

What are the databases iCEDQ can connect too?

It can connect to any JDBC compliant database like SQL Server, Oracle, Postgres SQL, etc. You can look at the complete list of database connectors here.

What are the different file formats supported by iCEDQ?

Users can read data from flat files (delimited or fixed-width), XML, JSON, Excel. You can check out the complete list of supported file types here.

Does iCEDQ support XML?

Yes, iCEDQ allows the user to write SQL against an XML file. 

Does iCEDQ support JSON?

Yes, iCEDQ allows the user to write SQL against a JSON file. 

What if the connector I want is not available in iCEDQ?

You can raise a feature request on our support portal or reach out to our sales team to get more information. 

Integration

We have HPQC and want to see all the results in iCEDQ. Can we do that with iCEDQ?

Yes, iCEDQ comes with an outbox integration with HP ALM 11 or above. You can import the Requirement and Test Cases from HP ALM and associate the audit rules. After the execution results will be posted back in HP ALM.

I want to integrate iCEDQ with Informatica. Is it possible?

Yes, it can be integrated with ETL Tool out there in the market through command line or web services.

Can it also be integrated with Control-M or Autosys?

Definitely, you can achieve that using the command line or web service interface of iCEDQ.

What are some of the out of box integrations?

We have Rest API’s and a CLI which customers use to trigger test from any external Scheduling, ETL, Workflow, or Scripting tool.

Currently, we have out of the box integrations with HP ALM, JIRA, and Jenkins. Customers can also build their own integrations with tools like Service Now, Slack, Elastic Search through our Integration Hub module.

Can I call iCEDQ API from other tools?

Yes, you can. We have Rest API to trigger Rules and Regression packs from any external tool.

Collaboration

Do I receive certain kind of alert or notification if a test fails?

Yes, iCEDQ will send email alerts on success or failure of rule depending upon how it is configured.

iCEDQ Security

Do you support RBAC?

Yes, we do. Customers can create users, groups, and give different types of grants on connections, projects, and other entities. 

Can iCEDQ integrate with LDAP?

Yes. Customers can support LDAP users as well as local application users at the same time. 

How does iCEDQ ensure database access security?

iCEDQ supports two types of connections, generic connections that can use service accounts and user connections in which each user has to provide their credentials. User connection offers an added level of security as other users are not using credentials.

iCEDQ Reporting & Dashboard

Does iCEDQ have any built-in reports?

Yes, iCEDQ provides a few pre-packaged dashboards in its reporting and dashboard module.

Can I create custom reports and dashboards?

Yes, you can. We have reporting and dashboard module which allows users to generate any report and dashboards using available templates.

How does iCEDQ report test failures?

It sends email alerts on the success and failures of the Rules. The email includes execution details as well as the ability to download the data issues in an excel format.

The Rules are configured to send email alerts to users, groups, or distribution lists.

iCEDQ Trial

Do you offer a free iCEDQ trial?

Yes, we give a free 30-day trial, where you will have access to the complete iCEDQ software and support. First we will schedule a demo of the product and answer any questions you have. This ensures that your requirements can be satisfied by iCEDQ.
Request for 30 Day Free Trial.

Do you provide training during the trial period?

As part of the trial/ POC, we do a 1.5-hour training session at no cost. We also schedule a weekly standing call to help you with any questions.

We also provide access to our support portal.

What do I need to install iCEDQ?

Download iCEDQ pre-installation checklist here.

What are the features disabled in the iCEDQ trial?

We provide a most recent GA full version iCEDQ software for a trial. Nothing is disabled.

Where can I install iCEDQ?

You can install it on-prem or in your private cloud (AWS/ Azure/ GCP).

If I have any questions or issues during my trial, what is the best way to get an answer?

You can raise a ticket on the iCEDQ support portal. We will also assign a customer success manager to you as part of the trial, who will be responsible for coordinating everything.

Support

What support channels do you offer?

We provide email, phone, and WebEx support. In some instances, we offer onsite support too.

Do you provide 24x7 support?

Yes, we provide 24×7 support via email, phone, or WebEx.

How can I open a ticket?

As part of onboarding, we provide access to our support portal. Users can raise tickets there or send an email to support.

Do you have an online knowledgebase?

Yes, we do. Once you get access to our support portal, you will get access to the KB too.

Training

Do you have any iCEDQ training programs?

Yes, we provide instructor-led training classes that are either online or in person.

Do you offer a formal certification for iCEDQ?

Yes, you will receive a certificate as an “iCEDQ Certified Developer” upon the completion of your training program. It is valid for a calendar year, and a refresher course will be required if there are changes in the software.

Do you have an online course?

Yes, we offer an instructor-led online training program. Each class is interactive and offers hands-on exercises. We will soon be launching a self-paced online training program.

Do you provide a group discount for the iCEDQ training?

Yes, we do. Please contact us for more details.

iCEDQ Licensing

How does iCEDQ's licensing work?

We offer different licensing options, and customers can choose any of them based on their requirements.

  • Server license (Perpetual)
    There is a onetime cost for a Server and CPU. And an ongoing annual support cost of 20%.
  • User license (Perpetual)
    There is a onetime cost for a User. And an ongoing annual support cost of 20%.
  • Server Subscription license (Yearly)
    There is an annual cost, which includes support costs too.
  • Enterprise license (Unlimited deployments)
    Customers can deploy unlimited instances of iCEDQ across the organization.

Is there any limit on the number of users in the Server license?

No, Unlimited users can log in and use iCEDQ.

Do you offer subscription licensing?

Yes, we do offer a subscription license for iCEDQ.

Are there any additional licensing costs?

We offer customer connector add-on for certain types of files and cloud systems and also load balancer add-on. Every add-on is charged separately on a la carte basis.

Contact us for more information.

Services

Do you offer any services to get us started quickly?

Yes, we offer a Jumpstart program, Data Testing as a Service (DTaaS), Data Migration Testing Service, and also resources who are experts in Data Testing and iCEDQ.

What does the Jumpstart program entail?

Along with the installation, configuration, and training, additional work of actually implementing test rules and mentoring for live projects.

iCEDQ resources will be collecting requirements and implementing audit rules and sharing experience with client resources. Eventually, the customer takes over the activities as they will have a complete grasp of the usage because of ongoing mentoring.

What is Data Testing as a Service?

Many organizations want to focus on their core activities and would like someone else manages their data testing and monitoring needs. In such cases, simply hiring an external resource does not work. Because the external resource is responsible for tasks but not the failure or success of the project, that risk is still with the customer.

iCEDQ specializes in data related testing and monitoring and offers “Data Testing as a Service” wherein the iCEDQ team ultimately manages the resources and testing activities.

The number of resources and their locations will be planned together with the client. Based on contract resource could be onsite, Nearshore/Offsite or Offshore depending on the options selected by the customer.

Timeframe: Annual /Project

What is Data Migration Testing Service?

A lot of organizations are moving to cloud platforms like Snowflake, Redshift, Azure DW, and many other similar platforms. These Data Migration projects have short project timelines, and that is why customers need help with accelerating the testing of it.

This is where the iCEDQ team comes in and offers its expertise on how to do Data Migration testing. We can completely manage the Data Migration Testing or provide resources that are experts in iCEDQ and testing.

We have successfully helped customers migrate their on-prem databases to Redshift and Snowflake.

Please reach out to us for further details.

Do you have short or long term services?

Yes, we do. We offer services around Data Testing, ETL, Data Modeling, BI Analytics.