CloverETL is now CloverDX - Learn Why

CloverETL Data Validation

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Posts: 1
Joined: Mon Sep 10, 2018 11:26 am

CloverETL Data Validation

Postby jaipal » Mon Sep 10, 2018 11:58 am

Can Anyone suggest best Tools for Data Validation in CloverETl.
Like for SSIS Packages we use SSIS Tester and Querysurge for other ETL .

Posts: 142
Joined: Mon Feb 29, 2016 5:33 pm

Re: CloverETL Data Validation

Postby vazquezrosariop » Fri Sep 14, 2018 3:19 pm

Hi jaipal,

I would highly recommend the following validation tools we offer.

Data Reader policy—All our data readers work with selectable data policy which affects how errors in the input data are treated. Different policies allow different reactions to data errors from strict reject over to controlled logging or completely lenient behavior.

Validator—Validator allows you to specify a set of rules using a powerful drag&drop visual designer and check the validity of incoming data based on these rules. Validation rules can check various criteria like date format, numeric value, interval match, phone number validity and format, etc.

Data Profiler—Let's you discover potential issues in your data. Calculates statistics such as ranges, averages or histograms for data profiling overview. Also offers trend analysis for TDQM setups.

Address Validation & Cleansing—Using Address Doctor to provide parsing of address details, verification and enrichment including geo coding.

Email Address Validation—Reads from input and parses e-mail addresses from specified fields.

You can also check out more information on how each one of these tools work in our documentation.
Pedro X. Vazquez Rosario
CloverCARE Support

Visit us online at