Wigersma & Sikkema
Challenge
The existing system had become difficult to maintain and scale, leading to performance bottlenecks in daily operations. The company relied on a highly fragmented architecture of siloed Microsoft Access databases scattered across individual clients. This lack of centralization created massive blind spots. It exposed them to security risks like unauthorized "license tuning" and made it nearly impossible to efficiently manage complex industrial data, such as monitoring seasonal gas pressure drops.
The existing system had become difficult to maintain and scale, leading to performance bottlenecks in daily operations. The company relied on a highly fragmented architecture of siloed Microsoft Access databases scattered across individual clients. This lack of centralization created massive blind spots. It exposed them to security risks like unauthorized "license tuning" and made it nearly impossible to efficiently manage complex industrial data, such as monitoring seasonal gas pressure drops.
Solution
Vivasoft executed a sweeping architectural overhaul, migrating decades of decentralized legacy data into a high-performance, cloud-native PostgreSQL hub. The solution integrated:
- Mobile "Inspector Window": Developed a Kotlin-based Android module enabling field technicians to instantly capture and sync live counter readings.
- Predictive Maintenance: Implemented a framework that analyzes device trends to proactively trigger calibration alerts before hardware actually fails.
- Automated Handshaking: Engineered a smart system that instantly recognizes connected gas regulators and automatically loads their precise configuration parameters.
Vivasoft executed a sweeping architectural overhaul, migrating decades of decentralized legacy data into a high-performance, cloud-native PostgreSQL hub. The solution integrated:
- Mobile "Inspector Window": Developed a Kotlin-based Android module enabling field technicians to instantly capture and sync live counter readings.
- Predictive Maintenance: Implemented a framework that analyzes device trends to proactively trigger calibration alerts before hardware actually fails.
- Automated Handshaking: Engineered a smart system that instantly recognizes connected gas regulators and automatically loads their precise configuration parameters.
Results
The cloud migration was a massive success, driving functional coverage from 30% to over 90% and automating 70% of manual tasks. The head office now commands 100% visibility over global license usage, while engineers safely utilize real-time analytics to manage volatile seasonal gas fluctuations.
The cloud migration was a massive success, driving functional coverage from 30% to over 90% and automating 70% of manual tasks. The head office now commands 100% visibility over global license usage, while engineers safely utilize real-time analytics to manage volatile seasonal gas fluctuations.