Customer service representatives maintained two separate legacy mainframes for water and electrical billing accounts. Employees logged into six different software tools with separate passwords, while customers could not view combined utility consumption statements online.
Modernizing Legacy Database Integration and Single Sign-On for a Public Utility District
A municipal public utility district serving eighty thousand water and electric customer accounts needed to modernize customer billing and staff authentication.
Challenge
Solution
FlipWorks built a unified API integration layer and customer portal connected to both legacy billing mainframes, alongside a SAML 2.0 Single Sign-On (SSO) identity provider for staff. Customers access a unified billing portal, while employees authenticate securely across all internal applications with a single PIV card login.
Result
- Unified water and electrical billing records into a single customer online account portal.
- Implemented SAML 2.0 Single Sign-On across internal agency software tools, improving access security.
- Extended the operational lifespan of legacy billing mainframes without requiring full database replacement.