Please recommend a powerful Java based ETL framework...

Question

Looking for the enterprise level, open source :) Java ETL framework. Came across Clover.ETL but want to hear what people think of it...

Answer 1

http://www.manageability.org/blog/stuff/open-source-etl

Answer 2

Kettle from Pentaho

Answer 3

Your own?

Answer 4

Scriptella ETL - An open source (Apache licensed!) fast, powerful and simple ETL written in Java with an easy-to-use one line of code Java integration, also supports Spring.

Usage examples

Answer 5

I would support Pentaho Data Integrator as well (formally know as K.E.T.T.L.E.)

Its fast, fully custamisable and easy to set up. The support on it is good as well. Last but not least it's cheap!

Answer 6

I'll go ahead and add a third vote for Pentaho's Data Integration tool. The Spoon GUI is very intuitive and supported by a robust back-end (but it still allows for custom SQL and JS scripting). It's slowly becoming a first-class ETL tool; perhaps one day it will challenge expensive high-end ETL solutions, a la MYSQL vs expensive-as-hell databases. It has an expansive wiki, excellent forums, and a solid base of example transformations are included.

Answer 7

Try CloverETL (www.cloveretl.com) - Eclipse based GUI, very fast run-time engine and also server with scheduling, watch dogs, events, ... It is engine based, requires only Java 1.5. Transformations/mappings can be coded in internal scripting language or directly in Java

Answer 8

I use scriptella to copy data out to a report database daily. It works wonderfully and it is so simple to use. No need to recompile code and redeploy if there is schema change. All I have to do is change my property file and rerun. Done in a flash!