What are ETL Tools?

ETL Tools are set of specialized tools (software) which are used for extracting data from several sources, customize (transform and clean) the data and insert into a datawarehouse.  

ETL Stands short for Extract, Transform and Load. ETL Tools are those which combine all the following three functions

• Extract - Reading data from specific source of database and extracting relevant set of data
• Transform - The process of transforming the original data and cleansing the data into how we need it to be placed into a data warehouse. 
• Load - Loading the transformed data  into the targeted database.

Questions before buying an ETL Tool?

Most ETL Tools are packed with features. But do they really have the ones which you basically require?
Read More..

Buy Vs. Build an ETL Tool?

An organization must first decide whether to buy or build an ETL tool for their data warehousing needs. Each has its own unique advantages and disadvantages..
Read More..

ETL Tool Features?

Each ETL Tool has its own unique features but some features are common. Take a look at the common features.
Read More..

Apatar - an Open Source ETL Tool

Check out Apatar - an Easy to use Open Source ETL Tool which requires no coding.
Read More..

KETL - 

KETL, Not to be confused with Kettle - another Open Source ETL Tool 
Read More..

Open Source ETL Tools - 

Some of the pros and cons of using an Open Source ETL Tool 
Read More..

SQL Server Integration Services (SSIS) -

SSIS is a powerful ETL tool packaged with Microsoft SQL Server