Have Geek Brain

What's the best FREE solution to implement one ETL project in MySql

What's the best FREE solution to implement a single ETL project in MySql?

I need to extract a large amount of data for analysis and place the results in other tables.

Regards,
Pedro

+2


a source to share


2 answers


Pentaho Kettle (PDI) is open source and there is a community version here that works pretty well.



+4


a source


Talend also works great for ETL and ELT. You can take a look at this page on my site: http://www.hiregion.com/2010/01/data-loading-through-talend-etl-studio.html and related articles. I also loaded hundreds of thousands of rows into millions using MySQL bulk load (LOAD DATA INFILE syntax - dev.mysql.com/doc/refman/5.1/en/load-data.html) and then did some conversions in MySQL. You can do most of the pre-load (ETL) or post-load (ELT) transformations, or use hybrid techniques.



+1


a source






More articles:


All Articles