ETL Validator
The Most Comprehensive Data Testing Automation Platform.
Flat File Testing, Data Migration Testing, Data Warehouse Testing, Master Data Management (MDM) Testing
The Most Comprehensive Data Testing Automation Platform.
Automate Testing of ETL, Relational, Flat Files, XML, NoSQL, Cloud, and Big Data Sources.
Comes with an inbuilt ETL engine capable of extracting and comparing millions of records from multiple data sources while executing test cases in parallel.
Define rules for automatically validating data in each column in the incoming file. Has a builtin File Watcher that automatically detects new files and kicks off tests.
Provides a Data Model driven interface for defining data rules to verify that the data conforms to standards and range of values.
Compare aggregate data such as counts, sum, distinct counts between source and target instead of comparing large volumes of data.
Helps audit changes to the database metadata - data types, lengths, indexes. Simplifies comparison of database schema across environments.
This powerful feature can be used for testing of incremental ETL, slowly changing dimensions and ETL regression testing.
Capability to assemble and schedule test plans. Email notification, web reporting and ALM integration enables sharing of test results.
Has an unique Visual Test Case Builder with drag & drop capabilities and a Query Builder that enables defining tests without manually typing in queries.
Supports comparison of data across heterogeneous platforms including the most popular relational databases, Hadoop, BI (OBIEE), XML and Flat Files.
ETL Validator makes use of Datagaps’ patented ELV Architecture to automate ETL Testing. It supports extraction of test data from multiple sources such as relational databases, XML, Flat Files, BI and Hadoop. The test data is loaded into a workschema (Oracle or PostgreSQL database) so that validations can be run on it. ELV (Extract, Load, Validate) Architecture consists of the following three steps:
ETL Validator connects to a wide variety of data sources. From time to time, we are constantly adding support for many modern data sources. If you don’t see a data source of yours, please send an email to us with your question.
ETL Validator makes it easy to test most common ETL testing scenarios by providing out-of-the-box support. Comes with an in-built Query Builder.
Component test case supports testing of ETL transformations by providing a visual test case builder that supports extracting test data from multiple sources in a single test case