- CloverETL
-
CloverETL 
Developer(s) Javlin Initial release 2002 Stable release 3.1.0 / June 2011 Operating system Cross-platform Type ETL tools License dual LGPL, commercial Website http://www.cloveretl.com/ CloverETL is a Java-based data integration framework used to transform, cleanse, standardize and distribute data to applications, databases or warehouses. Its component-based structure allows easy customization and embeddability.
Contents
CloverETL suite
- CloverETL Community - free-of-charge data integration tool with GUI
- CloverETL Designer - the graphical user interface to create and modify data transformations for CloverETL Server and Engine.
- CloverETL Engine - executes the transformations (run-time); can be embedded as a library. Available under LGPL.
- CloverETL Server - full-fledged server application with a rich WEB-based administrative interface, which leverages the existing CloverETL Engine.
- CloverETL Cluster/Cloud - server extension allowing multiple instances to form data transformation cluster capable of running in-house or in cloud environment with dynamic load-balancing & nodes provisioning.
Main Features
Platform, Application and Database independent
- utilizing industry standards of Java (SE/EE) and Eclipse
Embeddable
- both engine and the server can be embedded as a transformation library/service
Scalable & Efficient
- Data transformation is performed by independent components, each running as an independent thread – allows utilization of multiple CPUs or cores
- Compact size, very small memory footprint
- High speed – Clover outperforms custom scripts by 45% and is the fastest Java Open Source ETL tool[1]
- Clustering extension is available for CloverETL Server which allows both pipeline & data parallelism
Stable & Mature
- CloverETL was founded in 2002 and is continuously developed by stable team of programmers
- Project is self-funded - no venture capital involved
Customizable
- Can be quickly and easily extended by custom components
More details
CloverETL is a Java based ETL tool with Open Source components.[2][3] It can be used standalone - as a command-line application or server application or can be easily embedded in other application (as a Java library). CloverETL is accompanied by CloverGUI graphical user interface developed as Eclipse plugin.[4][5][6] 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.
CloverETL can be easily extended by creating new custom components in Java. Such components can be registered within the GUI and used as any other component delivered in the standard pack.
Server version of CloverETL allows parallel execution of transformations and also supports execution of transformations in transaction mode. The server runs inside application container.CloverETL currently contains connectors for following data sources
- text file delimited*, fix-length* & combined*
- XML* supports very large XML data files - GBs
- XLS (MS Excel)*
- any RDBMS through JDBC
- WebServices through REST/SOAP protocols
- JMS
- LDAP
- dBase/FoxBase/FoxPro
- bulk-loaders for Oracle, DB2, MS SQL, Informix, MySQL and PostgreSQL
- QuickBase (by Intuit)
*remote reading/writing through FTP/SFTP/HTTP/HTTPS protocols and also from ZIP/GZIP/TAR archives supported
CloverETL has been successfully deployed on following OS platforms
- Linux (both 32&64 bits)
- Windows (both 32&64 bits)
- HP-UX
- AIX
- AS/400 (IBM System I)
- Solaris
- Mac OS X
Other open-source Java ETL frameworks
- Apatar
- Talend Open Studio
- expressor
- Enhydra Octopus (launches from web browser via Java Web Start)
- Pentaho Data Integration
References
- ^ "Performance Benchmark of CloverETL, Talend & Pentaho ETL tools". OpenSys. http://www.cloveretl.org/_upload/clover-etl/Comparison%20CloverETL%20vs%20Talend%20and%20Pentaho.pdf. Retrieved 2009-02-20.
- ^ "Open Source ETL Written in Java". Manageability. http://www.manageability.org/blog/stuff/open-source-etl/view. Retrieved 2007-06-28.
- ^ "JasperSoft Unveils Open Source BI Architecture". ComputerWire. 2006-04-25. 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. "Doscher said the company is working with Open Source ETL projects like Clover ETL and KETTLE, which is being developed by Kinetic Networks Inc."
- ^ Howard, Phil: The case for open source ETL, Reg Developer
- ^ "Homsys Group Yves Cointrelle". Journal du Net. 2006-12-04. http://solutions.journaldunet.com/chat/retrans/060410-homsys-yves-cointrelle.shtml.
- ^ Linux Softpedia
External links
Categories:- ETL tools
Wikimedia Foundation. 2010.
