Denodo Technologies
109 Case Studies
A Denodo Technologies Case Study
Vancouver Coastal Health (VCH), a regional health authority serving over a million people across Canada, faced a challenge when rolling out a new transactional patient information system that its legacy, dimensionally modeled data warehouse couldn’t support. Rather than replace the warehouse, VCH implemented the Denodo Platform as a virtualization layer to integrate the two disparate systems and present transactional data in the warehouse’s familiar structure.
Using the Denodo Platform, VCH achieved near-real-time reporting (replacing nightly feeds), improved overall system output by an estimated 30–50%, and implemented highly granular, cell-level security across the organization. The single access layer also allowed incremental testing and an agile development approach, letting VCH modernize systems without disrupting users.
Alan Knox
Director, Technical Data Management