What is the Quooker Cap Database?

The Cap Database is a web application that allows Quooker to centralise service data from units in the field. The web application makes this data searchable and analysable, with an integration to Qlik Sense for advanced reporting.

How does the integration with the QSM app work?

The QSM app used by service technicians stores data via the REST API developed by The Next App. The Cap Database web application reads this data and provides search, filter and analysis capabilities.

Can you build an API and web application for field data?

Yes. The Next App builds custom web applications and APIs for organisations that want to centralise and analyse data from service technicians or external apps.

Quooker Cap Database — web application for service data

Client

Quooker

Platform

Web

Type

Web application / Data analysis

Technology

Angular / CakePHP / Qlik Sense

Service

Web Development

About the project

Centralising Quooker unit service data: from field technician to Qlik Sense dashboard

Quooker, the inventor of the boiling water tap, has a worldwide network of service technicians who maintain units at customer locations. Via the QSM app, technicians record service data per unit: firmware versions, EEPROM information and chip keys. However, this data was not centrally available for analysis.

The Next App developed the Cap Database: a REST API that connects the QSM app to an Angular web application, making the data searchable and filterable. Via an integration with Qlik Sense, advanced analysis and reporting is possible.

Features

REST API for receiving service data from the QSM app
Search and filter by firmware version, EEPROM data and chip keys
Integration with Qlik Sense for advanced reporting
JWT authentication for secure access

Quooker

Inventor of the boiling water tap, active in more than 20 countries

Qlik Sense

Advanced data analysis and reporting via integration with the existing BI platform

Custom API

Custom-built REST API connecting the QSM app and the web application

Challenge and approach

The challenge

Service data from thousands of units not centrally available

Service technicians recorded data via the QSM app at every maintenance moment, but this data was not searchable or analysable at organisational level. Quooker needed insight into firmware versions, EEPROM data and chip keys across the entire unit fleet.

The approach

REST API as a bridge between QSM app and Angular analysis dashboard

We built a CakePHP REST API as the central data layer. The QSM app writes service data directly to the API. The Angular web application makes all data searchable and filterable, including the ability to view and compare data from different angles. Connecting to Quooker's existing BI infrastructure, a direct integration with Qlik Sense was established.

Result

Service data directly available for analysis and reporting

Quooker has a central system where service data from the entire unit fleet is searchable, analysable and connectable to the existing Qlik Sense BI platform.

Central

All service data from field technicians available in one searchable system

Qlik Sense

Direct integration with the existing BI platform for advanced analysis

Custom

Fully tailored to Quooker's data structure and work processes

Technology

Built with

AngularTypeScriptCakePHPPHPMSSQL ServerREST APIJWTQlik SenseDocker

FAQ

Frequently asked questions aboutQuooker Cap Database

What is the Quooker Cap Database?: The Cap Database is a web application that allows Quooker to centralise service data from units in the field. The web application makes this data searchable and analysable, with an integration to Qlik Sense for advanced reporting.
How does the integration with the QSM app work?: The QSM app used by service technicians stores data via the REST API developed by The Next App. The Cap Database web application reads this data and provides search, filter and analysis capabilities.
Can you build an API and web application for field data?: Yes. The Next App builds custom web applications and APIs for organisations that want to centralise and analyse data from service technicians or external apps.