Clover ETL is a data transformation and data integration tool (ETL) distributed as a Commercial Open Source software. As the Clover ETL framework is Java based, it is independent and resource- efficient.
CloverETL is used to cleanse, standardize, transform and distribute data to applications, database and warehouses. It is a Java based program and thanks to its component based structure customization and embeddabilty are possible. It can be used standalone as well as a command- line application or server application or can be even embedded in other applications such as Java library.
Clover ETL has been used not only on the most wide spread Windows platform but also on Linux, HP-UX, AIX, AS/400, Solaris and OSX. It can be both used on low-cost PC as on high- end multi processors servers.
Clover ETL components
Clover ETL pack includes Clover ETL Engine, Clover ETL Designer and CloverETL Server.
The first, Clover ETL Engine combines two functions, is both a data transformation run- time and library simultaneously. It can be a data transformer also while embedded in other applications. It is capable of pushing data back into an application.
The second one, Clover ETL Designer, enhances Clover ETL, with the visual design of data transformations. Functionality of standard components can be improved by an experienced programmer who can complement visual design with classic program sections. What is more, such a code created by a programmer could be still fully and directly transferred to any kind of supported platform.
Last, but not least, part of Clover ETL pack is Clover ETL Server. It has a rich web- based administrative interface that includes: parallel executions of transformations, clustering, support for multi- user interactions and many others.
Clover ETL presents flexibility that allows easy design and implementation of the data as well as data transformation applications and consolidation of data sources. Those sources can be dissimilar and heterogeneous systems. Moreover, it will work with structured data of any kind. It does not matter if it is stored in text files or kept in binary format. Clover ETL should allow users to combine, transform and move all data from any source.