Now a days we can find many popular ETL tools in the software industry.
Among them, the following are the Top 10 ETL Tools that are available in the market.
- Informatica PowerCenter
- Data Stage from IBM
- AB Initio
- ODI (Oracle Data Integrator)
- BODS (Business Object Data Services) from SAP
- SSIS (SQL Server Integration Services) from MicroSoft
- Data Integration Studio from SAS
- Pentaho Data Integration
- Talend Open Studio For Data Integration
- Clover ETL
Informatica PowerCenter is a product of 'Informatica Corporation'. It was released in the year 1993.
This is the most popular and powerful ETL Tool which is used for Extraction, Transformation and Loading(ETL) purpose.
Data Extraction:It is a process of extracting or pulling day to day transactional data from various types of sources like RDBMS sources(Oracle, Teradata, Sysbase), Files( .txt, .csv, .xml) and ERP sources(SAP, People Soft).
It is the process of converting the source data (input data) from one format to another format(client required format) by applying business logics.
It is a process of populating or dumping the source data into the corresponding target systems. The data is loaded into the target system after the transformation. Here target systems means nothing but Data warehouse.
Informatica PowerCenter is a client server technology.
It is GUI which allows the user to develop ETL Applications. Those who develops ETL Applications are known as 'ETL Developers'
It is a service which executes ETL Applications developed by Informatica Client.
The work of the Reporting Developer starts only after the completion of the ETL Process.
The process of generating reports by querying the data from the data warehouse is called "Reporting". The tools used for reporting are called reporting tools. Those who develop reports using the reporting tools are called 'Reporting Developers'.
The following are top 5 reporting tools:
- IBM Cognos
- SAP BO
The process of constructing the DWH or designing the DWH, ETL and Reporting is called 'Data warehousing'.