What are ETL Tools?
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, debuggging 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.
Popular ETL Tools
| 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 |
Microsoft SQL Server Integration | Microsoft |
TransformOnDemand | Solonde |
Transformation Manager | ETL Solutions |
New Emerging ETL TOOLS:
The matter of fact is that Talend and Pentaho Data Integration are sufficiently different in conception, architecture and implementation that they are in fact two distinct choices on the ETL market. While some people prefer one tool and some prefer another, the choice is there. Having the opportunity to try out both tools for Free and to have this choice is one of the most important differentiators with the traditional closed source ETL companies.
1 comments:
Don't forget about some nice new open source ETL players in this arena like Pentaho's Kettle, and Talend. They aren't quite up to the level of features and robustness found in some of the big players yet, but they are impressive free alternatives which may, someday, give the proprietary companies good competition.
Post a Comment