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.
As of 3/1/2020 the current GA version is 16.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.
Big Data Testing
Data Migration Testing
ETL Testing/Data Warehouse Testing
BI Report Testing
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.
What is the learning and implementation curve for iCEDQ?
It is very short. Once the users go through a one or two-day training program, it takes them two weeks to completely implement iCEDQ in their environment.
Do you support Cloudera for Spark Edition?
Yes, currently, we support Cloudera, Hortonworks, and soon will be releasing support for AWS EMR. We have plans to support Databricks too.
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.
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:
Create tables and insert expected data for testing.
Read a dynamic parameter from a database and pass it to a Rule.
Take a backup of the table and compare it with the actual table post ETL.
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.
What BI Reporting Tools does iCEDQ support for testing?
Currently, we support the SAP BO Webi and Tableau. Our roadmap for BI Report connectors is driven by customer request. Next, we are going to release the connector for Microstrategy.
What Big Data systems does iCEDQ support?
It can connect to Hive, Impala, Cassandra, and many other data sources in your ecosystem. You can find the complete list here.
Can I compare PDF files using iCEDQ?
There is no direct support for PDF files, but customers have converted it into XML and used our connector for XML to compare the data.
What cloud Data Warehouses can you connect too?
You can connect to Snowflake, Redshift, Azure Synapse, and a few others. You can find the complete list here.
Does iCEDQ have access to our data?
No. iCEDQ is a software that is entirely managed by the customer with the help of our support team. It does not communicate with external systems, and our teams do not have access to your instance of iCEDQ.
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 12.5 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.
Will I be able to integrate iCEDQ with a CI/CD tool?
Absolutely !!! Customers have integrated with Jenkins, Bamboo, and other CI/ CD tools using our APIs, CLI, or plugins.
What test case management tools can I integrate with iCEDQ?
You can integrate with HP ALM, X-Ray. And we are planning to release support for QTest, TFS, and a few other test case management tool.
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.
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.
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?
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.