From Access to a scalable cloud platform
Initial situation
To manage company and user licenses, the SBV had previously relied on an internally developed solution based on MS Access. The so-called DARI app was functionally established, but no longer met today’s requirements for scalability, cloud capability, and maintainability. It was also rather difficult to integrate interfaces to third-party applications .
Challenge
All functions, from license management to automated processes, were to be retained and modernized in a targeted manner. At the same time, it was necessary to connect existing systems such as CRM, Abacus, and BI and to integrate the existing user management via Azure.
Solution
As part of an application modernization project, soxes completely redeveloped the existing DARI app and transferred it to a modern, cloud-based architecture. The goal was not only to adopt the existing functionality, but also to further develop itin a sustainable system architecture for the future.
The new solution is based on the following technology stack:
- .NET, C#, Angular, based on the abp.io platform
- Single sign-on (SSO) via Entra ID (Azure)
- Hosting on a managed Kubernetes service (AKS)
In terms of content, the web application includes:
- Management of customer and user licenses
- Connection to a CRM system
- Billing of licenses via an Abacus interface
- Monitoring of license usage via business intelligence
Through re-engineering, the application was completely moved to the cloud and can now be used decentrally. In addition, the basis was created for implementing future enhancements such as a customer portal.
Result
With the newly developed DARI web application, the SBV benefits from a modern, maintainable, and scalable solution that is ideally suited to today’s requirements:
- Future-proof platform: Modern cloud architecture, open to further development
- Better maintainability: Clear structure, automated processes, transparent data
- Seamless integration: Direct connection to existing systems such as Abacus, CRM, and BI
- Decentralized availability: Secure use regardless of location and device
- Greater efficiency: Reduced effort for operation, support, and license management
This project shows how targeted application modernization can transform an Access solution that has grown over many years into a modern business application.
