The ETL ( Extract, Transform, Load ) are how to extract-transformation-loading data from transactional or other system (CRM, ERP ...) in different structures or DataWarehouse Business Intelligence (DataMart, OLAP ... .)
The acronym it contains the key concepts: • Extraction
data from all operating systems;
• Transformation of these, thanks to cleaning processes (selection of data), integration (operations such as normalization), aggregation, calculation, execution of joins in homogeneous information, useful to the objective analysis that is taking place, production reporting that supports business decisions or to provide information (eg public enterprises)
• Loading and storing data on the various BI applications.
ETL processes are programmed within the DBMS, recorded and released at specific times through appropriate schedulers.
are important for a company as they give managers the opportunity to work and to communicate information which, despite coming from different sources are aligned. It, thus avoiding the risk that comes from the same data to different results: Suppose that the Rector of un'Ateneo wants to know the number of deserving students enrolled, it could happen that the meaning of "student praiseworthy among the various faculty. It 'important that there is a specific system that integrates the various departments of the university and guarantee the uniqueness of the information.
Usually ETL allows you to graphically display data transformations, including options that allow you to comment on their manipulation, contain a battery of transformations to perform the most common and simple calculations and a debugging environment where you can test the operations.
The continuous increase of data that a company handles causes the ETL processes are found to be working with information from source systems and to play more and more complex transformations.
Among the most common ETL software: • Data Studio
;
• Informatica PowerCenter, IBM DataStage •
;
• Microsoft SSIS;
• Benetl;
• Oracle Data Integration Suite.
0 comments:
Post a Comment