The Challenge

Aspetar is a globally recognized Orthopaedic and Sports Medicine Hospital based in Doha, Qatar. The institution operates at international standards and manages high volumes of clinical, imaging, and sports medicine data.
As part of a strategic modernization initiative, Aspetar decided to transition from Cerner Millennium to Health Insights EMR to improve data accessibility, reporting flexibility, and long-term system sustainability.

Problem Overview

The transition presented exceptional scale and complexity.

Data Volume & Complexity

• • • • 40 TB of structured legacy EMR data
      • 100 TB of CAMM imaging files
      • 50 million scanned clinical documents
      • 68+ million clinical results records

The Migration Required:

• • • • Zero data loss
      • Full auditability
      • Business continuity during cutover
      • Regulatory compliance (HIPAA-equivalent controls and local MoPH reporting requirements)

Technical Risks

• • • • Encrypted BLOB storage in Cerner
      • Legacy CAMM image formats
      • Need for incremental live data synchronization
      • Field-level compatibility mapping between source and destination models
      • High-performance cutover within a limited downtime window

Failure would have risked operational disruption, regulatory exposure, and clinical access gaps.

Migration Requirements

Aspetar mandated:

• • • • Complete raw data extraction into a secure staging layer
      • Transformation of qualified patient data into Health Insights
      • Creation of a secondary analytics repository for regulatory reporting
      • Daily incremental refresh from Cerner production
      • Decryption and preservation of encrypted clinical BLOB data
      • Conversion of CAMM files into readable formats
      • Comprehensive data validation before go-live

Santeware’s Solution & Approach

Santeware assembled a specialized migration task force including:

• • • • Data Solution Architects
      • Cerner EMR Specialists
      • SQL & ETL Engineers
      • Dedicated QA and Validation Teams

A structured, steering-committee-approved migration framework was established prior to execution.

Architecture & Execution Model

1. System Compatibility & Field-Level Mapping

• • • • Detailed comparison of Cerner schema to Health Insights data model
      • Column-by-column validation
      • Business-rule alignment workshops

2. ETL & Data Pipeline Engineering

• • • 18 ETL packages covering 126 raw Cerner tables
    • Daily refresh of staging environment from Cerner production
    • Transformation into 63 normalized tables in a dedicated “Trans” layer
    • Snowflake schema implementation for structured analytics

110 structured views were exposed for seamless ingestion into Health Insights.

3. Handling Complex Data Types

• • • In-house utility developed for CAMM image conversion
    • Secure extraction and decryption of encrypted BLOB data
    • Metadata-linked file reconstruction to preserve clinical context

4. Multi-Layer Data Validation Framework

Santeware implemented a multi-phase QA strategy:

• • • Small-scale validation
    • Large-scale validation
    • Full-volume testing
    • Cutover simulation
    • Mirror-to-mirror MRN verification

Validation reports included:

• • • Data Load Integrity Reports
    • Testing Artefacts Reports (visual + extracted comparison)
    • Categorical Inspection Reports (patient type, gender, payer class, etc.)

A total of 89 issues were identified and resolved during pre-production testing.

Data Migration Scale

• • • 279,000+ patient demographics records
    • 35M+ encounters
    • 2M+ procedural orders
    • 7M+ clinical results
    • 17M+ dynamic clinical documents
    • 50 TB historical dataset migrated in 4.5 hours during final cutover

Post-go-live: Only two minor business-logic-related adjustments were required — none attributed to migration defects.

The Impact

The migration achieved full operational continuity with measurable execution precision.

• • • 100% successful EMR data migration
    • 0% data loss
    • 5-hour optimized cutover window for 50 TB data transfer
    • 18 ETL packages and 40 transformation stored procedures deployed
    • 110 structured views enabling seamless downstream ingestion
    • Secondary data warehouse enabling MoPH regulatory analytics
    • Entire project completed within 7 months

The new environment became self-descriptive and query-friendly, enabling non-Cerner stakeholders to retrieve structured clinical insights efficiently.

Conclusion

Santeware executed one of the region’s most complex EMR migrations by combining structured governance, high-performance ETL engineering, deep Cerner expertise, and rigorous validation controls.

The project delivered:

• • • Seamless transition to Health Insights
    • Regulatory-ready analytics infrastructure
    • Secure decommissioning pathway for Cerner
    • Zero disruption to clinical operations

Aspetar has continued collaboration with Santeware for ongoing data management and system initiatives, reinforcing long-term partnership confidence.