The current data from the source systems is required for energy trading and risk management, among other things. This means that malfunctions in the ETL (extract, transform, load) processes used have a direct impact on operations and must therefore be rectified at short notice. For this reason, performance analyses, error corrections and optimizations of the ETL loading routes are carried out.
Supplement
The source data is read from MS SQL Server and Oracle databases, processed using SSIS packages and database procedures, and transferred to the target systems. The job is controlled by one of the SQL servers involved.