Digitalization & Data Harmonization

Initial situation & background: Fragmented data landscape & high licensing costs

A global pharmaceutical company faced a key challenge:

• Data was isolated in a local AVEVA PI system, but was needed for analysis in other systems, and at the same time data from other systems needed to be transferred to the PI system;
  • Data had to be written back – in particular, aggregated values (e.g. energy consumption, production metrics) via Kafka into an enterprise data lake.
• Kafka, as a global cloud solution, acted as an overarching data platform for all locations. The local PI systems were not able to communicate with Kafka so far.
• Goal: A modular, cost-effective solution to optimize the global data architecture.

 

The MEGLA solution: Scalable and future-proof

MEGLA developed a solution with a focus on data integration, scalability and cost reduction. We proceeded as follows:

• Managing requirements:
  • Mapping of different data formats for seamless integration
  • Flexible data structure for future extensions
  • Easy adaptability for new requirements
• Development & implementation of the solution with scalable architecture
• Setup & DevOps support for ongoing operations – all from a single source

Result: Efficient data processing & significant savings

With the MEGLA solution, the pharmaceutical company was able to establish a flexible, cost-efficient data platform and thus get the most out of the PI System thanks to our expertise:

• Seamlessly providing data in different systems
• Linking multiple systems for optimized process control
• Elimination of ongoing license costs through a license-free model
• No more data loss: Backfilling mechanisms allow data to be imported afterwards in case of network problems or system failures

 

Benefits:

• Higher data availability for analyses and process optimization.
• Flexibility & scalability for future extensions.
• Reduced operating costs through tailor-made solutions.

Thanks to this solution, our customer was able to speed up their digital transformation – with maximum efficiency and minimum costs