Clover.ETL

Infobox_Software
name = clover.ETL

latest_release_version = 2.5.0
latest_release_date = September 2008
operating_system = Cross-platform
genre =
license = LGPL
website = http://www.cloveretl.org/

clover.ETL is an Open Source, Java based ETL framework. [cite web | title = Open Source ETL Written in Java | url = http://www.manageability.org/blog/stuff/open-source-etl/view | accessdate = 2007-06-28 | publisher = Manageability] [citenews|title=JasperSoft Unveils Open Source BI Architecture|publisher= ComputerWire |date= 2006-04-25 |url=http://w3.nexis.com/partnerfeed/getdoc.aspx?id=13660195&mtid=1&ws=9j0hDk1UboE=&ws_pub=ComputerWire&ws_date=April%2025,%202006&ws_len=1115&ws_lni=4JTG-0560-TX7B-531J-00000-00&ws_title=JasperSoft%20Unveils%20Open%20Source%20BI|quote= Doscher said the company is working with Open Source ETL projects like Clover ETL and KETTLE, which is being developed by Kinetic Networks Inc.] It can be used standalone - as an command-line application or server application or can be easily embedded in other application (as a Java library). clover.ETL is accompanied by clover.GUI graphical user interface developed as Eclipse plugin. [Howard, Phil: " [http://www.regdeveloper.co.uk/2005/12/29/open_source_etl/ The case for open source ETL] ", [http://www.regdeveloper.co.uk/ Reg Developer] ] [citenews|title=Homsys Group Yves Cointrelle|publisher=Journal du Net |date=2006-12-04|url= http://solutions.journaldunet.com/chat/retrans/060410-homsys-yves-cointrelle.shtml] [ [http://linux.softpedia.com/get/Programming/Libraries/Clover-framework-7533.shtml Linux Softpedia] ] Data transformation is described by transformation graph that is represented by Java class. However, description of graphs can be stored also in XML format. Graph consists of nodes (perform various simple transformations) and edges (connect nodes and pass data around). Each node is run as separate thread which helps utilize more CPUs (cores). The Clover ETL engine can also be used in transaction mode - i.e. transformation graphs are executed repetitively as a step in transaction.
clover.ETL can be easily extended by creating new [http://wiki.cloveretl.org/doku.php?id=component_building custom components] in Java. Such components can be registered within the GUI and used as any other component delivered in the standard pack.
[http://www.cloveretl.org/clover-server/ Server version] of clover.ETL allows execution in application containers.

clover.ETL currently contains connectors for following data sources:

* text file delimited, fix-length & combined
* XML
* XLS (MS Excel)
* any RDBMS through JDBC
* JMS
* LDAP
* dBase/FoxBase/FoxPro
* bulk-loaders for Oracle, DB2, MS SQL, Informix, MySQL and PostgreSQL

Other open-source Java ETL frameworks

* Talend Open Studio
* [http://www.enhydra.org/tech/octopus/index.html Enhydra Octopus] (launches from web browser via Java Web Start)
* Pentaho Data Integration

References

External links

* [http://www.cloveretl.org/ Clover website]
* [http://wiki.clovergui.net/ Clover Wiki]
* [http://www.javlin.eu/ Clover's creator - Javlin Consulting]
* [http://www.opensys.eu/ Clover's provider of professional services - OpenSys]