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. In the web application that data is searchable and analysable. Reporting runs through an integration with Qlik Sense.

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 so you can search, filter and analyse it.

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 application 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. An integration with Qlik Sense allows further analysis and reporting.

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

Data analysis and reporting through an integration with the BI platform Quooker already used

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. In the Angular web application all data is searchable and filterable, and you can view and compare data from different angles. Because Quooker already worked with Qlik Sense, we built a direct integration with it.

Result

Service data directly available for analysis and reporting

Quooker now searches and analyses service data from the entire unit fleet in one system, which is connected 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 further analysis

Custom

Fully tailored to Quooker's data structure and work processes

Technology

Built with

AngularTypeScriptCakePHPPHPMSSQL ServerREST APIJWTQlik SenseDocker

FAQ

Frequently asked questions about Quooker 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. In the web application that data is searchable and analysable. Reporting runs through an integration with Qlik Sense.
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 so you can search, filter and analyse it.
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.