Data integration 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 or ELT 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 modeling, data transformation, validation, data calculations and loading into a target.

Data Integration & ETL software

• Composite Information Server
• Adeptia EBIMS
• Syncsort Data Integration
• Pervasive ETL
• Talend Open Studio Data Integration
• Jasper ETL
• PDI - Pentaho Data Integration ETL
• SAS Dataflux
• Sybase ETL
• Microsoft SQL Server Integration Services
• ODI - Oracle Data Integrator
• SAP BusinessObjects Data Services
• Ab Initio
• IBM Infosphere Information Server
• Informatica PowerCenter