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