Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to create ETL parser in Java. Is there any opensource tool or framework available to build ETL parser for unstructured data.

I want to create a parser and need to define format in properties file and parser must able to parse according to format in properties file.

I am not asking for full code.Any suggestion would be appreciated.

share|improve this question
What do you mean by "ETL". ETL as in "Extract", "Transfer", "Load"? – Guido Leenders Apr 2 '14 at 10:02
Excatly, Extract Transfer Load..! – BlackPOP Apr 2 '14 at 10:29
up vote 4 down vote accepted

To build simple and complex Etl processes I recommend Kettle. Currently named Pentaho Data Integration. Written in Java with nice GUI and easy to integrate in Java software. Source available. See website.

share|improve this answer
I asked in opensource..itseems kettle is not open source..! – BlackPOP Apr 2 '14 at 12:08
See and In my vision the Apache License v2 is open source. What do you need it for or do you have a specific license form required for your project such as GPL, LGPL or BSD? – Guido Leenders Apr 2 '14 at 12:15
Thanks for help..! 1+ – BlackPOP Apr 2 '14 at 12:17
You are welcome! If you think one of the answers is answer please approve that one to help community. Good luck! – Guido Leenders Apr 2 '14 at 12:20
Don't forget to include a link in the answer ;) – Nick Wilde Apr 2 '14 at 14:05

The only open source framework I know(and used) for ETL processing in java is Spring-Batch and it's the only implementation(AFAIK) of the jsr-352.
I'm not sure if it suits you because in a simple google search I found some pure ETL frameworks like CloverETL but I haven't tried them yet so I can not have an opinion. So far I've been using Spring-Batch for ETL and Batch processing for almost 6 months and I'm quite happy with it :)
Hope I helped a little!

share|improve this answer
thank you for answering am letting this question open for some more suggestion.. +1.. – BlackPOP Apr 2 '14 at 9:03
Spring-Batch is a batch processor. While in theory it can be used to build an ETL tool, it does not add much value, and does not provide components to help with ETL. You should concentrate your answer on CloverETL, which a thousand time more suitable as an ETL framework :-) Thanks! – Nicolas Raoul Apr 4 '14 at 9:18
@NicolasRaoul allow me to disagree,by saying that SB is only a batch processor is like saying that vehicles shouldn't carry objects because they are made to carry people. SB is really popular for ETL processing(that's why I answered) if the user has a basic knowledge of java and a google search can prove that :) . On the other hand I can not focus on CloverETL because I never used it and I do not intend too, I do ETL jobs with SB. To tell you the truth I believe SB is more appropriate than Clover for this question because it's a JAVA-FRAMEWORK as the question suggests – dimzak Apr 4 '14 at 10:21
Interesting! Adding this information to the answer would be great :-) – Nicolas Raoul Apr 4 '14 at 10:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.