Back to blog

Cross-Department Data Sharing

By Rplus AnalyticsCase study13 Aug 2026

Secure APIs Rplus built on a central government department's data estate, serving two other government departments.

7 yrsHistory from one lookup
140Databases behind one API
2Departments served
6 monthsPrototype tested first

Data moving both ways

Rplus built REST APIs on top of the Data Services Platform, exposed to other government organisations.

The part that matters most is the direction of travel. Data services are built on synchronous and asynchronous APIs that both send information to and receive it from other government organisations and local government. Information flows in both directions across organisational boundaries — one department shares data with the department holding the platform, which in turn shares data with another.

INFORMATION CROSSES ORGANISATIONAL BOUNDARIES IN BOTH DIRECTIONS Another government department shares in receives back THE PLATFORM Hadoop · Spark · NoSQL exposed via Apache LIVY synchronous and asynchronous shares out and back again A third government department Also connected: local government, and 100+ further government data sources Neither department can see inside the other's systems. The platform is the shared ground.
Sharing in one direction is an integration. Sharing in both, across three organisations, is a governance arrangement with an integration attached.

Two APIs, two questions

Benefit history

GET /benefits?nino=…

Returns a citizen's benefit history for the last seven years, retrieved by searching on a National Insurance number. The data behind it is pulled from 140 SQL and non-SQL databases residing across cloud and on-premise environments.

Employer history

GET /employment?ytd=…

Confirms year-to-date employer history for Jobseeker's Allowance, for a further government department.

The first is configured using the WS02 enterprise platform for integrating APIs, applications and web services locally and across the various applications.

What the number means

One lookup, one identifier, one response — and 140 separate databases behind it, spread across cloud and on-premise. The consuming department never sees any of that. Hiding the estate is the work.

The estate behind it

The platform holds data from more than 140 source systems, plus over 100 further data sources from local government and other government organisations.

It is built on Hadoop, processes data using Spark and stores it in NoSQL databases. Those platforms are exposed using Apache LIVY, which supports synchronous and asynchronous APIs.

Running a service other organisations consume

Integrating new components onto the platform includes the rollout and management of the various hurdles that come with a service, whether public or private, and the different methods of integration used by consumers. Three questions get worked through every time: what security is required, how versioning is handled, and how the service is documented and supported.

Source system has an API? yes no REST scalable, flexible, client and server separate Secure file transfer simple, widely accepted — but security first OpenAPI specification CSV · JSON · Parquet · sheets
Flat files are accepted only once security has been addressed during discovery and design — not assumed to be valid because they are easy.

APIs adhere to OpenAPI specifications and support formats including spreadsheets, CSV, JSON and Parquet. We work to the microservice and service-oriented architecture approaches set out in the Government Digital Service Manual.

Event-driven architecture

We implemented event-driven architecture APIs on the platform, enabling data linkage between datasets and keeping that data up to date. Alongside REST we developed SOAP services and microservices, working with the Microsoft BI stack including SSRS, SSIS and Power BI Service, over MS SQL, MySQL and Oracle.

These automate legislation or policy changes by creating variable parameters that can be configured as required — so a rule change becomes a configuration rather than a release. The prototype was tested for more than six months before implementation.

Elsewhere on the platform

The same approach serves the department's own services. Apply for NINO verifies submitted address proof using a unique property reference number, linked to the citizen's information, and checks passport and visa status through another department's REST APIs. REST APIs built on the big data platform are also consumed directly by web and mobile applications.

The stack
  • C#
  • .NET
  • Java
  • Node.js
  • Angular
  • Kafka
  • Spark
  • Python
  • Apache LIVY
  • WS02
  • SOAP
  • REST
  • SSRS
  • SSIS
  • Power BI Service
  • MS SQL
  • MySQL
  • Oracle
Across on-premise and cloud environments.
Proof points
  • 7 years of benefit history from one lookup
  • 140 databases behind a single API
  • 140+ source systems and 100+ further government data sources
  • 2 departments served
  • 6 months of prototype testing before implementation