What is the best FREE solution to implement one ETL project in MySql [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.开发者_StackOverflow中文版

Improve this question

What is the best FREE solution to implement one ETL project in MySql?

I need to extract for analisys big amount of data, and put the results in other tables.

Regards,

Pedro

---

Pentaho Kettle (PDI) is open source and it has a community version here, which works quite good.

---

Talend also does an excellent job for ETL and ELT. You can take a look at this page on my website: http://www.hiregion.com/2010/01/data-loading-through-talend-etl-studio.html and related articles. I have also loaded hundreds of thousands of rows to millions through MySQL bulk loading (LOAD DATA INFILE syntax - dev.mysql.com/doc/refman/5.1/en/load-data.html ) and then doing some transformations in MySQL. You can do most of transformations before the load (ETL) or after load (ELT) or use hybrid technique.