Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I encountered problem finding tool or software for data validation or ETL testing. I found only 2 solutions: QuerySurge and Informatica.

Advise, suggest any other tool or share experience.

Im sure, given post will further contribute to those who will try to establish validation process like me.

share|improve this question
What are you looking for in a tool that isn't met with the two tools you've found already? – jruberto Jan 18 '14 at 16:37
Everything is ok with those two, but I want to choose more than out of two tools. Are those tools are the only option? – user6731 Jan 20 '14 at 3:05

If the goal includes test data sets you need to vet ETL operations (across DBs and packages), I would be looking at IRI RowGen. It uses the CoSort data manipulation language, which also supports data validation and transformation within test data generations. Compare the outputs of those (consolidated) job scripts to verify your mappings produced the same results against that safe, referentially correct data.

share|improve this answer

Informatica DVO only works if you have PowerCenter as your ETL tool. QuerySurge works with any ETL tool. Try the free download.

share|improve this answer
Could you give a bit more information about your experience with these tools? It would help the original poster to know more about both. – Kate Paulk Jan 21 '14 at 12:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.