CASE STUDY

ICEDQ

Unlocking Robust Data Warehouse Testing for Non-Standard Endpoints





ICEDQ has a powerful vision to transform the process of data-centric testing through their ETL DataOps testing and monitoring platform. Designed to easily identify data inconsistencies between source and target data source, ICEDQ helps companies automate & scale testing to accelerate development of data-centric systems, resulting in vastly reduced project risk and increased data quality. Today, companies across the world leverage ICEDQ’s automated data testing platform for ETL, Data Warehouse, Data migration, and BI Testing.

The Challenge: Providing Customers with Broad-Spectrum ETL Quality Testing

Enterprises use ICEDQ to quickly test and ensure that data in reports matches data in their data warehouses, in a non-production phase, allowing system updates while ensuring data validation and accuracy.

The more data sources ICEDQ connects to, the more data their customers can verify and test. And as customers requested to test data against more and more data sources, ICEDQ found they needed to enhance their platform with broad-spectrum testing.

The challenge became especially evident when iCEDQ customers wanted to test data from non-standard endpoints, such as XML, JSON or a REST API. Those cases would typically require custom development or a workaround in which customers worked on replicated data and not live data, slowing down the entire testing process for their customers.

“We would always face this challenge. We definitely had to look for a platform-agnostic solution that would introduce our customers, and us, to a richer experience,” said Shrikant Patil, Customer Success Manager for iCEDQ.

ICEDQ searched for a solution enabling standardized access to "non-relational" endpoints like XML, JSON or a REST API. They looked to provide their customers the ability to test live data, instead of replicated data from applications, and connect directly to a broad range of popular cloud & SaaS application data through the ICEDQ API.

ICEDQ needed a solution that would save time, allow them to onboard more customers without requiring custom development, and speed the testing process.

The Solution: A Platform-Agnostic Solution

Through an OEM partnership with CData, ICEDQ embedded our full suite of drivers for 130+ data sources directly into their ETL testing solution.

“Essentially, building drivers is not our expertise, and that’s not our focus too, so it made good sense to partner with an organization like CData, which focused on driver development,” Patil said.

CData Drivers are designed to simplify processes and instantly provide rich connectivity, as they embed natively into the ICEDQ platform.

The CData Drivers offer key technical advantages:

  • ANSI-92 SQL Support: CData Drivers support a rich ANSI-92 SQL syntax across all drivers, deeply nested queries, and an extensive set of SQL filters and formulas
  • Full CRUD SQL-92 Support: Rich ANSI-92 SQL syntax supporting deeply nested queries and an extensive set of SQL filters and formulas.

Results: Automated Testing processes and Reliable, Accurate Data

Now, iCEDQ has the broadest data connectivity available in the market while enabling its customers to quickly conduct ETL testing of 130+ additional data sources, including many popular data warehouses.

“With CData, we don’t have to worry about anything when it comes to connecting to data sources, different authentication mechanisms or platforms,” Patil said.l

Through its partnership with CData and the embedded CData Drivers, ICEDQ now delivers faster ETL testing to more data sources than ever, empowering customers with its rigorous data quality testing platform.







Connectivity is our Core: Any source, Any technology, Any platform.

CData Software (www.cdata.com) is a leading provider of data access and connectivity solutions. We offer a straightforward approach to integration, with easy-to-use, data providers, drivers, and tools available from any technology capable of interacting with major data standards.


Learn More »






* All product names, trademarks and registered trademarks are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names,trademarks and brands does not imply endorsement.