ETL Service
ETL service (Extract, Transform, Load) – subsystem is used for integration with external systems. Implemented on the basis of the use of Integration Services DBMS, which is used in the system, as well as on the basis of free software Pentaho Data Integration Kettle ETL.
Main Purpose
Processing and import into the system of information about subscribers of communal organizations and organizations of service providers.
Export for these organizations information about payments accepted in their favor.
Data transformation.
Extracting data from external sources.
Data transformation, to store data in an appropriate structure or format, for the purpose of further analysis.
Loading data into the final database. More specifically, it can be a data store or a data warehouse.
