Quotes On Communication Bible

function of 'ETL and ETL

ETL (Extract, Transform, Load) is a process of extraction, transformation and loading of data into a synthesis system (data warehouse, data mart ...). ETL processes (Extraction, Transformation and Loading ) are the components important and with more value-added infrastructure Business Intelligence (BI), they retrieve data from all operating systems and pre-process them for analysis and reporting tool. The accuracy and timeliness of the entire BI platform depend largely on the ETL processes.

The processes of extraction, transformation and loading include multiple steps that have as their goal the transfer of data from production applications to business intelligence systems:

• Extraction of data from production applications and databases (ERP, CRM, RDBMS, files, etc...)
• Transformation of these data for their reconciliation on all i sistemi sorgente, eseguire calcoli o parsing di stringhe, arricchirli con informazioni di lookup esterne e confrontare il formato richiesto dal sistema target (Third Normal Form Star Schema, Slowly Changing Dimensions, ecc.).
• Caricamento dei dati risultanti nelle varie applicazioni BI: Data Warehouse o Enterprise Data Warehouse, Data Mart, applicazioni Online Analytical Processing (OLAP) o “cubi”, ecc.

I maggiori TOOLS di Query Reporting sono:



-ACCESS di Microsoft;

-BOAD;

-COGNOS;

-SAP;

-BUSINESS OBJECTS.