About the client
CoolCare LTD is a care home management software provider based in the UK, with a diverse set of customers across the country. The software – CoolCare4 – that our client offers is used by a large number of care homes across the region.
Business challenge
Fragmented data across multiple care home databases without a centralised access point
CoolCare offers a specialised software product called CoolCare4. This platform is designed to support care homes by streamlining key operational areas such as data management, finance, HR, and CRM.
CoolCare LTD faced a significant challenge: consolidating scattered data from various systems into a unified, accessible format.
1As their customer base grew, managing disparate data sources across multiple care homes became increasingly complex.
2Their clients, individual care homes, needed a centralised view of their operational data to make faster, more informed decisions.
3The existing setup lacked seamless integration between systems, leading to inefficiencies, duplicated efforts, and difficulty in maintaining data accuracy.
To overcome these issues, CoolCare engaged GoodCore for API development to centralise data access and streamline operations for care home clients.
The solution
Project goals
The project entailed the following requirements:
- Develop a centralised API to access data from multiple individual databases through a single interface.
- Ensure compatibility with existing systems within the CoolCare4 platform.
- Enable easy integration across multiple endpoints to support scalability and future expansion.
System features and functionality
The project that we delivered had two main parts: The API and the administrator portal.
Centralised API for scalable data access
We built a centralised API that allows CoolCare4 to retrieve and update data across individual care home databases. This includes information related to:
- Care homes
- Staff members
- Residents
The API was designed to be scalable and dynamic, functioning as a plug-and-play solution. New client databases can be added on the fly, no need to modify the source code.
Key features include:
- Flexible integration: Automatically supports new databases without code changes.
- Efficient querying: Uses complex SQL queries tailored to CoolCare’s specific needs.
- Robust security: Incorporates strong authentication and authorisation protocols to protect sensitive data.
User-friendly admin portal for data management
We developed a simple, web-based admin portal that allows users to interact with multiple connected databases in CoolCare’s system. Through this interface, users can view and add data with ease.
Key features include:
- View data from any connected data source.
- Add new entries (e.g., client name and contact details) via a straightforward form.
- Select target database when submitting new data.
- Minimalist design with limited, focused actions for ease of use.
The impact
- The API solution now supports data access across 100+ care home databases.
- New client databases can be added instantly without any code changes.
- The admin portal is actively used by CoolCare’s internal team and partner care homes.
- Improved data consistency and accessibility across all connected systems.
- The solution lays a strong foundation for future scalability and system integrations.
Related success stories
Looking to create an impact with software?
Explore how we can work together.