Essex County Council

Partnering to accelerate digitisation


As a local authority and government body, Essex City Council is the keeper of year's worth of data, being required to store records while making them easily available and secure. The council decided to find an archiving solution that would finalize its move to the cloud.

Challenge

The council needed to move four terabytes of data (or 10 billion data entries) and design a reporting solution that would simplify retrieving information, while keeping the records secure.

Solution

Fujitsu built the council an archive solution on Oracle autonomous database to export legacy data and store it safely in the cloud. It also designed a custom reporting solution for the archive.

Outcomes

  • Transferred legacy data quickly and within budget
  • Saved costs with the new archiving solution
  • Simplified information retrieval with a custom support solution
The delivery time was exceptional, that was the fastest I've seen something completed. This Fujitsu solution is far better than what we had.

Nick Pimm, Project Manager, Essex City Council

4 TB data migrated

8 months to build the archive and transfer the data

About the customer

Essex County Council is a local government body within the county of Essex. It collaborates with other local, regional and national bodies to deliver services and represent the best interests of the people within the county. It has 75 councillors elected from 70 divisions, and serves a population of almost 1.5 million, making it one of the largest local authorities in England.

Living up to high expectations

For local authorities, serving the population means, among others, protecting their privacy, offering resources quickly, and sharing information based on sensitive data securely. Not having the right tools to achieve this means letting down a lot of people precisely at the time when they need help. Taking this mission seriously, Essex County Council collaborated with Fujitsu to migrate to an Oracle SaaS application (HCM, Finance, Procurement and EPM) ensuring the best possible information management system for all projects.

The final piece of the puzzle was to safely store the legacy data. As a government body, the council is required to store records for a set period as mandated by business need or legislation, such as the Freedom of Information Act (FoI) 2000 and the Data Protection Act 2018.

Protecting information with compliance and security

In June 2022, Fujitsu started working with Essex County Council to construct a static archive solution as part of its migration to the cloud. Fujitsu, using its Oracle CloudScale tools and accelerators, built the solution on Oracle autonomous database, using Oracle APEX as the user interface. This allowed the council to export legacy data and store it safely on Oracle Cloud Infrastructure (OCI).

The work had to be done quickly and reliably. According to Nick Pimm, Project Manager at Essex County Council, the council and Fujitsu had worked together for years and the relationship is an example of true collaboration. “The results of the entire Oracle project, including the archive, are clear. The delivery time was exceptional, that was the fastest I’ve seen something completed. This Fujitsu solution is far better than what we had,” he comments.

Fujitsu even helped the council with an unanticipated legacy solution problem. “This was an unplanned, emergency piece of work. Fujitsu helped us get out of a challenging situation on that,” says Pimm. “A lot of that depended on Fujitsu’s goodwill but there was never any doubt in my mind they would help,” adds Benjamin Sutherland, Programme Manager at Essex County Council.

Serving the citizens

Perched on top of the brand-new archive is a custom reporting solution designed by Fujitsu, which was contracted to host the application suite and provide an application management service. This solution is used mostly for answering FoI requests in a timely and reliable manner.

Fujitsu has also been helping the council with knowledge acquisition and preparing for running the archive without external support for security and patching. To better serve its citizens and be more responsive to their requests without relying on a third party, the council wants to be self-sufficient and have the ability to write new reports beyond what Fujitsu delivered.

Fujitsu will be leaving the solution in great hands. Commenting on the long-lasting relationship, Sutherland says: “We really had a one-team feel with Fujitsu. We did a big programme and you’re not going to get away without some issues, but there was a real sense of maturity across the teams and we were able to work through all that stuff together.”

Related Customer stories

Helsinki University Hospital
Helsinki University Hospital (HUS) has innovated with a partner ecosystem to develop a unique digital solution that makes home dialysis treatment simpler and more sustainable for both patient and professional.
City of Hamm
A co-design workshop with the City of Hamm and Fujitsu identified the most important sustainability data requirements for an open data citizens' portal.
Skogforsk
Enabling Sustainable Forestry for the next 100 years. Using technologies like 5G and VR, Skogforsk has enabled remote control of heavy forest machinery over a private 5G network, enhancing worker safety while boosting productivity and sustainability.
REHAU Industries SE & Co. KG
As the new AI-based Quality Inspection solution eliminates possible defect sources and raises product quality to a new level, it helps to lower costs and make production more sustainable.
HMD Global
The provision of strategic RISE with SAP consultation services removed the burden of having to handle multiple vendors and contracts. HMD Global can now ramp up their manufacturing plants and deliver continuous improvements in business process efficiency, functionality, and automation.
Northern Trains Limited
Commuting made fuss-free through mobile applications
tex.tracer
Blockchain is the basis of the whole tex.tracer structure and fashion supply chain
Township of Barsbüttel
Energy efficiency in public buildings is a top priority for the township of Barsbüttel. To take one step closer to this goal, Fujitsu has captured and evaluated a wide range of room data in real time.