This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4837 IT projects that we have successfully completed with our customers.How can we support you?
Fullservice Reporting
Project duration: 1 year, 10 months
Brief description
Development of an ETL tool for providing company-wide data for reporting, as well as controlling service work on machines (e.g. inspections, repairs). The tool is implemented in Java and it enhances the software system for filling an existing data warehouse. The transformation rules are mapped in XML.
Supplement
The ETL tool is implemented as a Java application. This is based, on the one hand, on a proprietary software architecture that uses Java as a strategic programming language. On the other hand, it is based on the Clover ETL framework from Berlios. The transformation processes, including the technical and functional transformation rules, are stored in XML files. Another component of the ETL platform is a MySQL database. It serves as a transformation data cache and is responsible for data archiving tasks. The files to be transferred from operational systems and the data to be forwarded after processing by the ETL platform are available in ASCII format. The data warehouse is implemented as a DB2 database on the mainframe.
Subject description
Economic and efficient handling of machine servicing contracts that cover a wide range of services (e.g. inspections, repairs, warranty work) requires a set of instruments that identify data from various operational systems and make it available for various user views. A central role is played here by a data warehouse that is enhanced to operate additional reporting tasks from the area of full service (controlling, identifying key figures, etc.). Part of the enhancement involves implementing a new ETL tool (extract, transform, load) as a general process for information integration or as a new technology for filling the data warehouse with data from the technologically diverse upstream systems (mainframe systems, SAP).
IT project data
- Industries trade
- Specialist tasks Controlling, ETL, KPI, servicing
- DP tasks customised software new development
- System environments Client/Server
- Procedure model OOA/OOD
- Programming languages Java
- Databases MySQL
- Development and test tool Eclipse
- Operating systems Linux, Windows XP
- Middleware and frameworks XML
Project period01.08.2004 - 31.05.2006
Customers who trust us
Have we sparked your interest ?
