As the oldest state government department responsible for operating the state’s public health system, the Corona virus pandemic has created a very urgent requirement to deploy solutions, manage and plan Covid 19 responses, in healthcare and government. 

The department needs to stream near real-time data to support better clinical decision making.

The Needs / Challenges

-We need to urgently stream data into the Clinical and Business Information Data Lake which is based on Azure. This Real-time data is needed for operational reasons (ICU bed space etc), also clinical decision making is critical.

-Challenge to collect ICU data in real time from the Hospitals across the State. 

-Need a system with the ability to scale without increasing the load on source systems key to procurement.

The Solution  

Qlik Replicate – MS SQL Server& Oracle to Azure SQL.  Target is Azure Synapse.

The Results

-Successful POC, exceeded expectations and benchmarks

-Qlik Replicate’s ability to scale without increasing the load on source systems key to procurement.

-“One of the key features that I am keen on with Replicate is its native log reader for Oracle. Most of the other implementation use Oracle’s log miner, which cannot support Oracle databases that have more than 1TB/day of data transactions.”

-Qlik Replicate was found to be a cost-effective platform with an easy to use interface.

Photo credit: Thanks to Piron Guillaume for sharing their work on Unsplash.