What an ETL Tool can do for you !!!
In the today’s IT market scenario, an ETL tool is more than just DATA MIGRATION from Source A to Target B. It can be taken a step further to DATA WAREHOUSING to merge Data from Source A – Z to the Target 1 – N.
ETL stands for Extract, Transform and Load
Exploiting the Capacity as we HUMAN always do, its now moved to DATA SYNCHRONIZATION to keep one DATABASE changes updated to other in REAL TIME…which means you can’t even finish a blink of eyes and data might have already traveled miles.
DATA INTEGRATION is the NEED OF EVERY SECOND !!! yeah…because an HOUR will be to long to think of in today’s streaming world which is continuously screaming words on SOCIAL MEDIA.
ELT [i.e. Extract, Load and Transform] – Another paradigm gaining popularity due to Big Data and Hadoop
- Major ETL Tools available in Market are:
- Informatica PowerCenter
- IBM DataStage
- AbInitio
- SAP BODS
- ODI
- Talend
- Sqoop [Open Source]
Leave a Reply