This is one of 4140 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.


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.


Project period01.07.2021 - 01.06.2022

Have we sparked your interest?

Joachim Schütter

Key Account Manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.