Overview

Customer: RLDatix
Industry: Healthcare Governance, Risk & Compliance Software
Headquarters: Global (19 countries)
Cloud Platform: Amazon Web Services (AWS)
Cintra Services: Modernization Viability Assessment, Database Architecture Design, Database Refactoring, Data Migration Services

Business Challenge

The RLDatix Loop application operated across AWS regions using Microsoft SQL Server on RDS to meet data residency requirements. However, SQL Server licensing costs and vertical scaling constraints significantly increased cloud spend during peak workload demands and limited business growth.

Key business drivers included:

  • Enhancing user experience by addressing database performance and removing bottlenecks

  • Eliminating dependency on expensive SQL Server licensing

  • Ensuring growth by enabling vertical and horizontal scaling

  • Understanding PostgreSQL differences and modernization complexities

  • Completing the modernization within a strict two-month timeline

  • Ensuring minimal business disruption throughout the transition

RLDatix required a trusted specialist to assess modernization viability and deliver a low-risk and rapid modernization of the Loop Healthcare application database.

Cintra’s Solution

Cintra executed a two-phase modernization program:

Phase 1 - Modernization Viability Assessment (MVA)

• Assessment of the Loop SQL Server environment
• Evaluation of database modernization complexity
• Target Aurora PostgreSQL architecture design
• Modernization business case, delivery plan and ROI model

Phase 2 - Database Refactoring & Migration Services

• Modernization plan and technical design
• Schema and code conversion using AWS DMS Schema Conversion Tool
• Full AWS DMS-managed data migration
• PostgreSQL automation provisioning scripts
• SME modernization support during testing and go-live
• Knowledge transfer on Aurora PostgreSQL cloud operations

The result: a scalable and resilient, multi-region, Aurora PostgreSQL architecture with automated scaling and read replica redundancy to meet business requirements.

Outcomes

Cintra delivered a successful accelerated modernization program aligned to RLDatix’s commercial and operational goals.

Operational Excellence

  • 2X improvement in database query performance 

  • Scalable platform to meet healthcare application workload demands 

  • Zero business disruption during transition to Aurora PostgreSQL

Financial Optimization

• 90% reduction in cloud database costs by migrating from Microsoft SQL Server on Amazon RDS (license included) to Aurora PostgreSQL, removing the need for ongoing SQL Server licensing.

Delivery & Platform Modernization

• Modernization completed in less than two months
• Future-proof platform with automated vertical scaling + read replicas
• Customer teams trained on Aurora PostgreSQL and AWS DMS best practices

Testimonials

Business Impact Summary

  • Cloud costs reduced & controlled – 90% savings

  • Performance – 2 x faster query response

  • Modernization timeline – Achieved in less than 2 months 

  • Scalability – Automated and Read Replica Scaling

  • Risk Mitigation - Zero disruption modernization, multi-region resilience