Data Integration / ETL
Enterprise Data integration (aka Enterprise Information Integration - EII) is a collection of processes, technology, control mechanisms, automated tasks and skills necessary to standardize and integrate data originating from different sources within an organization.
Typically data integration in Business Intelligence is realized through the ETL processing, which consists of extracting the data from source systems, transforming it and loading the data into a data warehouse.
The critical data integration tasks include: data conversion from different sources into a common format, data cleansing and data quality control, data transformation, validation, data calculations and loading into a target.
Data Integration & ETL software
- Informatica PowerCenter
- IBM Infosphere Information Server
- Ab Initio
- SAP BusinessObjects Data Services
- ODI - Oracle Data Integrator
- Microsoft SQL Server Integration Services
- Sybase ETL
- SAS Dataflux
- PDI - Pentaho Data Integration ETL
- Jasper ETL
- Talend Open Studio Data Integration
- Pervasive ETL
- Syncsort Data Integration
- Adeptia EBIMS
- Composite Information Server