Data migration made simple with Bedrock
Background to the project
Like many healthcare organisations, Kingston Hospital was using an outdated data management and reporting system that could not meet their requirements for real time reporting from Electronic Patient Records (EPRs).
Historically, Kingston Hospital has used overnight extracts from its core clinical system to populate its data warehouse for management information reporting. Bulk processing can cause issues such as extraction errors, delays, data quality and timeliness of data.
At the same time, there is increasing pressure for NHS Trusts to provide high quality real time or near real time information to a range of stakeholders and partners as well as the desire to utilise data for their own operational efficiency.
“We had years and years of relying on overnight feeds. When they fail it can all go wrong because you have to load data manually and in the right order. We were keen to move to a new environment ASAP as data extraction was very painful for everyone involved,” explains Ursula Kingsley, Deputy Head of Information Services, Kingston Hospital.
The initial goal for the project was to achieve real time data access, but Kingston Hospital also has ambitions to use analytics for performance-based predictions.
Why Trustmarque was selected as partner
Trustmarque is well-versed in the issues NHS Trusts are facing in pulling data from EPR systems. We were able to demonstrate to Kingston Hospital our unique position; offering a consultative approach based on unrivalled market knowledge to identify the right value-based solution.
As part of the consultation, Trustmarque introduced Kingston Hospital to a similar data migration project at Royal Berkshire Hospital where they were using Bedrock data extraction tool. According to Ursula, when they saw the effectiveness of Bedrock in operation they were “bowled over”.
Zoe Dronfield, Trustmarque Client Manager, said: “Trustmarque have strong competencies around prediction which is an area the NHS is moving into. Being proactive and understanding the ‘what if’ scenarios is crucial to understanding your service and working in the most efficient manner to deliver better care. We have an impartial view of the market, so we can really look across the vendor landscape to find the right solution, whatever your data challenge.”
Bedrock Real Time Connector is a data extraction tool that moves data from Cerner to a local SQL Server database within just a few seconds. Bedrock is highly specialised to the healthcare market and works very efficiently with Cerner data platforms, however it can also be used to support any EPR system.
It is designed to simplify data warehouse management, making processes and reporting faster and more reliable. Large updates can run in minutes and the data is always available 24/7.
The extracted data can be used for a range of operational needs; monitoring patients in A&E, daily finance reporting and other operational notifications via mobile apps. Discover more
Trustmarque delivers customer centric IT solutions that enable better outcomes. We’re an award-winning IT partner who has helped over 2,000 organisations to gain competitive advantage through digital transformation.
For over 30 years we’ve empowered our customers to work smarter and run their businesses more effectively, with long-standing relationships in the healthcare sector. Together, with partners like Bedrock, we can transform your data reporting and data processes.
About Kingston Hospital NHS Trust
Kingston Hospital is a district hospital and Foundation Trust in south west London that provides a full range of diagnostic and treatment services in the surrounding area. In the last year, the Trust saw over 127,000 patients in A&E, delivered almost 444,500 outpatient appointments and cared for more than 67,000 admitted patients. They employ around 2,900 staff with another 300 staff employed by contractors.
Kingston Hospital NHS Foundation Trust has a national reputation for innovative developments in healthcare, particularly in ‘patient-focused’ care across its services including emergency, day surgery and maternity services.