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.
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.
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.
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:
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.
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.