The ETL or the data integration process stands for Extraction, Transformation and Loading of the data. ETL is basic and essential process for any Master Data Management (MDM) or Data Ware House (DW) project.
The ETL Tools are used to save the time and make the whole process more accurate and free of error.
The following ETL tools are used in the industry today.- Comercial ETL Tools:
- IBM Infosphere DataStage
- Informatica PowerCenter
- Oracle Warehouse Builder (OWB)
- Oracle Data Integrator (ODI)
- SAS ETL Studio
- Business Objects Data Integrator(BODI)
- Microsoft SQL Server Integration Services(SSIS)
- Ab Initio
Freeware / open source ETL tools:
- Pentaho Data Integration (Kettle)
- Talend Integrator Suite
- CloverETL
- Jasper ETL
By Rajesh Vassey,
Team Leader, Modak Analytics.
No comments :
Post a Comment