This is one of 4620 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).
Overview
- Industries trade
- Specialist tasks Controlling, ETL, KPI, servicing
- DV tasks customised software new development
- System environment Client/Server
- Procedure model OOA/OOD
- Databases MySQL
- Development/ test tools Eclipse
- Operating systems Linux, Windows XP
Project period01.08.2004 - 31.05.2006
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
