ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL code created by programmers. This task was tedious and cumbersome in many cases since it involved many resources, complex coding and more work hours. On top of it, maintaining the code placed a great challenge among the programmers.
These difficulties are eliminated by ETL Tools since they are very powerful and they offer many advantages in all stages of ETL process starting from extraction, data cleansing, data profiling, transformation, debugging and loading into data warehouse when compared to the old method.
There are a number of ETL tools available in the market to do ETL process the data according to business/technical requirements. Following are some those.
| Tool Name | Company Name |
|---|---|
| Informatica | Informatica Corporation |
| DT/Studio | Embarcadero Technologies |
| DataStage | IBM |
| Ab Initio | Ab Initio Software Corporation |
| Data Junction | Pervasive Software |
| Oracle Warehouse Builder | Oracle Corporation |
| TransformOnDemand | Solonde |
Learn data modeling design Skills on OLTP and OLAP from a US University Professor with…
These SQL commands are related with Oracle's data dictionary and can be used to get…
important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..
In this section, we will try to explain about important database DROP commands that are…
In this section, we will try to explain about important database DML commands that are…
In this section, we will try to explain about important database ALTER commands that are…
View Comments
Hi,
Pentaho has a very good ETL tool (PDI) that should be included here in this list.
Thanks,
Rana