This is one of 4620 IT projects that we have successfully completed with our customers.How can we support you?
Interface Legionella remediation consultig – SAP
Project duration: 11 months
Brief description
There is an MS Access application for managing rehabilitation projects for drinking water systems in the event of Legionella infestation. In addition to the data of the renovation object, the project resources involved such as services, expenses, processors, renovation consultants, renovation experts, etc. are managed in the system. The services provided by those involved in the project are recorded and billed to the clients. Invoicing takes place in an SAP system. The data is currently transferred manually to the SAP system, which is a quite complex process and should therefore be automated through an interface.
Supplement
The service provided by the customer consists of the coordination of all relevant resources relating to a project to remediate the drinking water system in real estate in the event of Legionella infestation. Legionella are bacteria that can spread in drinking water systems and cause serious illnesses if there is a lack of maintenance or incorrect temperature settings. Once a drinking water system has been infected, structured and monitored remediation is required. Renovation can be a very complex process that can range from replacing parts of the drinking water system to replacing the entire system. Depending on the severity and complexity of the Legionella infestation, specialized remediation experts are involved in the project.
Subject description
A new control module based on MS Access will be created to control the interface and validate/data cleanse the data to be exported. The relevant data from the existing source system is periodically read into this module, visualized and transformed into the SAP target system structures. Originally, a file-based export as a .csv file was planned. However, an Oracle database already exists for another application that also transfers data to the SAP billing system. To standardize the export procedures, there is now a direct connection to the Oracle database from the control module. After processing, SAP writes status information back into the Oracle database, which can be evaluated by the control module.
Overview
- Industries services
- Specialist tasks property renovation
- DV tasks customised software new development
- System environment Client/Server
- Procedure model PTA project manual
- Databases MS Access, Oracle Database
Project period01.07.2021 - 01.06.2022
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
