<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=656789255406301&amp;ev=PageView&amp;noscript=1">
HM_Land_Registry_logo
Category: Case Study
Vertical: Government
Est. read time:

When you buy or sell a house, flat or land, the details about your ownership are recorded with Her Majesty's Land Registry (HMLR) to protect your property rights. The organisation stores over 25 million titles. Each registered title is linked to information about the extent of the land, details about the owners, any charges (mortgage), benefits, restrictions and even the likelihood that the property will flood.

 

HMLR required a robust and effective way of managing their operational planning data and an Anaplan DataHub was introduced to act as a single source for finance and operational data. This strategic tool was key in the organisation being able to make more effective decisions that were data-driven. To see ongoing benefits from the DataHub it was imperative that the data within be as real-time as possible and yet this process required a series of repetitive manual tasks to extract and load the information.

 

Operational information was extracted from a DB2 database or data warehouse using a MicroStrategy (MS) management information reporting application. The finance team would then pull information from an MS-generated report to manually create or amend operational models in the Anaplan Data Hub. HR and financial data was retrieved from the Oracle database to compensate for the lack of details provided by the original MS report. Finally, the team manually manipulated and uploaded these details into the Anaplan model.

 

Challenges

  • Manual extracting and submission of data is inefficient and prone to errors;
  • Lack of automation in critical financial processes, including operational reconciliations;
  • Increased risk of fraud and abuse due to manual tasks;
  • Various siloed data sources without a single point of truth;
  • Duplicate records and data consistency issues due to manual processing.

     

How we made it work

HMLR required an integration solution to automate the process of data extraction and real-time consolidation. To start with, the organisation engaged our MuleSoft experts to run a 1-day MuleSoft Test Workshop. During the event, the HMLR team evaluated whether MuleSoft's integration platform would be the right fit for the organisation's needs. Following the workshop's success, HMLR selected MuleSoft as their integration enabler.

HMLR-API-led-solution

API-led solution

The project applied an API-led connectivity approach to the design (as shown above) to decouple the backend data sources and the receiving Anaplan app. This abstraction layer reduced the dependencies and provided opportunities for reusability for future integration projects.

HMLR Anaplan Solution Overview – Logical View

Data flow solution - logical view.

The results were outstanding. In less than three months of total development time, HMLR fully automated data extraction and entry from Oracle and their SQL Data Server into Anaplan. A scheduled daily process replaced the repetitive, manual tasks. The solution was flexible, secure and scalable. It included:

  • Operational data synchronisation (one-way) between HMLR Repository and Anaplan Data Hub.
  • Historical employee data synchronisation (one-way) between Oracle Cloud HCM and Anaplan Data Hub.
  • Financial data synchronisation (one-way) between Oracle Cloud Financials and Anaplan Data Hub.

Starting your API-led integration initiative?

Our Kick-start Integration Kit is a perfect solution for organisations that have chosen MuleSoft as the primary transformation enabler and are looking to get started fast.

EXPLORE MORE

Momentum gained

Applying Kick-start Integration Kit (KiK), our process-based solution, we helped HMLR set up a solid foundation with reusable APIs, launch the project and demonstrate value in only 90 days. This approach helped design the solution right from the start and follow a series of best practices, thus minimising the need for additional rework and reducing the project delivery time.

 

HMLR is an excellent example of how fast a company can start realising the benefits of MuleSoft and API-led connectivity. The diagram below clearly demonstrates the accelerated delivery enabled through the reuse of APIs.

HMLR API reuse rate

HM Land Registry case study: 30% API reuse rate.

HMLR's three integration projects delivered over a 15-month timeframe benefitted from the foundations laid during this Oracle to Anaplan project. As a result of API reuse and out-of-the-box connectors provided by MuleSoft, the team delivered the consequent projects three(!) times faster than the original implementation on legacy technologies. Furthermore, even within the first project, the team successfully reused several System APIs, and thus, accelerated the delivery.

  • Actionable insights and data consolidation to get instant answers to revenue opportunities and cost concerns;
  • Single source of truth - access to near real-time transactional data from various sources;
  • Reduction of manual operations to eliminate errors, risk of fraud and abuse;
  • Provide foundations and reusable assets to facilitate and accelerate future integrations deliveries.