I was asked to prototype two ETL frameworks. The requirements are as follows:
The raw file can be anything (excel, csv, html page etc..) The target database is MySQL.
Dont just drop names, please indicate the advantages/disadvantages based from your experience.
Thanks!
One of the most popular Java based ETL would be Talend.
Jaspersoft ETL is another one extended from Talend and has a nice eclipse based UI.