Hello,

in the context of free software, 2 ETL works well:

-Pentaho (Pentaho data integration or geokettle) 

-Talend

If you work with Data Warehouse such as Oracle, you will find an integrated ETL.

best regards

Ludovic

Thanks Mr. Ludovic...

With pleasure!

Hi there,

Just take a look at this in addition to what Ludovic has proposed:

http://www.predictiveanalyticstoday.com/top-free-extract-transform-load-etl-software/

Regards,

Rizwan

Hello 

I would recommend Talend. it's a open source platform. 

Pentaho is free just for 30 days !

Regards

IBM Modeler is platform agnostic and supports archive of stored procedures. Depending on how robust your machine is, how vast the restructued array can become is limited only by contiguous memory. As long as you do not change any of the data plumbing nomenclature, it is quite possible to automate a steady production stream that not only extracts data from a relatively dirty source, transforms it into a normalized format, and then loads the transformed extract into a repository where the second phase of scientific data mining operations can occur through discovery, analysis, and dissemenation of findings. The apex difficulty is building the ideal model, of course. To do that, you have to spend a lot of time shredding electrons with silicon, through a human's brain that is fully immersed in the informatics stream. ETL is just the initial phase of the Data Mining process and is more data engineering and data plumbing, but wtihout it, data scientists would have a much more difficult task of discovering new knowledge from existing data.

In ORACLE built in tool for ETL is Warehouse builder. But it is not user friendly and flexible. Much more user friendly is dedicated for ORACLE (but not only) is ORACLE Data Integrator (downloaded from ORACLE Web site) free for scientific and  educational use.

In MS SQL it is Integration Services, part of MS Data Tools (later MS Business Intelligence). It is very flexible, fast and useful tool for ETL process. It can be download from DrimSpark MS store (later MSDN). If You have not experience in this platform please choose 2012 platform (newest version 2014 is more difficult to install).

It is a pity that Penatho is no longer free. It is really very good tool.

ETL is not only first step for Data Mining. Wider it is beginning of analytical processing - Data Warehousing and Data Mining

Thanks Mr.  Mohammed Rizwan and Mr. Imade Benelallam....I will try these options

Thank you Mr. Richard...

Thanks Mr. Adam Pelikant for giving details of ETL providers..

I am using Pentaho Data Integration (Community Edition) for more than 5 years. It is currently at version 5.3.

thanks Mr. Roberto..

Thanks Mr. Alaa Khalaf for answer....I will try it.....