From Wikipedia, the free encyclopedia
clover.ETL is an Open Source, Java based ETL framework.[1][2] 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.[3][4][5] 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 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 clover.ETL allows execution in application containers.
[edit] 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
[edit] Other open-source Java ETL frameworks
[edit] References
[edit] External links
