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.
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.