Interface concept for an energy data management system

Company portrait

As an energy service provider, EHA Energie-Handels-Gesellschaft mbH & Co. KG is the specialist for branch-based companies in Germany and Austria. Customers receive a comprehensive package of energy services “from a single source”. This includes the procurement and supply of green electricity and gas, energy controlling and energy consulting. The result is sustainable reductions in consumption and costs as well as practiced climate protection.

Grid utilization management - a new challenge

EHA is responding to the dynamic changes in the liberalized electricity market by, among other things, expanding its range of services to include supply via “grid usage”. This results in new challenges for EHA – “specialists for chain stores”. For example, EHA handles the registration for grid usage for its customers, i.e. it ensures that the customer is supplied by the grid operator. For this purpose, all relevant data is exchanged between EHA and the grid operator and a grid usage contract is concluded. EHA uses historical and planning data to forecast the energy consumption for each of its grid usage customers. This activity is referred to as “timetable management”. Up to this point, all the necessary data on customers and their contracts through to physical meters had been managed in an in-house developed company-wide application and associated database. This application is the leading system for all applications and systems at EHA. To support and improve its business processes in the area of grid usage, EHA has opted for standard software for energy data management (EDM). The entire timetable management will therefore be carried out with the help of the EDM software in future.

The collaboration

The interface implemented by PTA between the EHA application and the EDM system now allows central information to be used promptly and efficiently in different systems. The many years of experience of the PTA and the good cooperation with the employees of the "Grid Utilization" and "Systems Engineering" departments have led to this success.

The task of the PTA

The requirement for PTA GmbH is to design and implement an interface to the EDM system that is fully integrated into the existing or developing system landscape. Cross-system standardization and synchronization of business processes is a prerequisite for smooth communication. The systems to be linked are located in a very heterogeneous system landscape. EHA’s self-developed application consists of an Access2000 frontend and an MS SQL2000 database server on a Windows2000 server. The EDM system is programmed in Java and is operated with an Oracle database on a Unix server. Microsoft’s BizTalkServer is to be used as the EAI tool. Data is to be exchanged via XML files. On this basis, PTA GmbH analyzed the complex business processes in close cooperation with the employees of the “Grid Usage” department and developed and implemented an interface concept with the aim of achieving a high degree of automation.

Functionality and transparency

Based on the analysis of the business processes, the process-relevant events in the application and the database have been identified and adapted. As soon as business processes relevant to the EDM system are triggered, the associated data is first saved before being exported as an XML file. This approach enables the desired high level of traceability and transparency as well as fine control of data processing. Communication with the EDM system is asynchronous, i.e. feedback on the status of processing does not have to be immediate. Regularly executed monitoring routines check the interface functionality and alert in the event of malfunctions. Extensive tests have been carried out to ensure that the interface works correctly. The PTA test database used for this enabled complete documentation of the tests and analysis of the results.

Project ID: 1144

You can also find this project in our project database.

Customer testimonial

“It pays off for the EHA to have a professional partner, the “PTA”, at its side. The PTA’s professional approach to project work has definitely paid off for EHA”

Olaf Büttner, Head of Information Technology EHA

Have we sparked your interest?

Dr. Andreas Schneider

Sector Manager Energy

Jetzt Kontakt aufnehmen

Contact now

Download file