AWS re:Invent 2025 - CCC Intelligent Solutions gains better efficiency with Oracle to AWS PostgreSQL

Database Modernization Journey: CCC Intelligent Solutions' Transition from Oracle to AWS PostgreSQL

Overview

CCC Intelligent Solutions, a leading SaaS provider for the auto claims and collision repair industry, embarked on a comprehensive database modernization journey to migrate from an on-premises Oracle database to AWS Aurora PostgreSQL. This transition aimed to improve operational efficiency, enhance scalability, and optimize costs while maintaining high performance and reliability.

CCC Intelligent Solutions: Business Context

• CCC processes around 18 million claims per year, equivalent to 50,000-55,000 claims per day, touching the lives of thousands of customers.
• CCC's SaaS platform serves top 300 auto insurers, 35,000 repair shops, 5,000 suppliers, and integrates with 12 of the top 15 automakers.
• Data is the core of CCC's business, with the database processing up to 50,000 transactions per second.

The Modernization Journey

1. Infrastructure Modernization:

   • Migrated all workloads from on-premises to the AWS Cloud, enabling greater flexibility and scalability.

2. Application Modernization:

   • Migrated Oracle WebLogic workloads to microservices and JBoss.
   • Transitioned from Oracle Service Bus to Mulesoft.
   • Leveraged Kafka architecture to adopt an event-driven design.

3. Database Modernization:

   • Identified all integration points, data sources, and downstream applications to plan a phased approach.
   • Analyzed Oracle-native SQL queries to determine which could be easily migrated to PostgreSQL.
   • Addressed data migration challenges, including handling over 150TB of data, with a focus on separating binary and non-binary data.
   • Leveraged AWS Schema Conversion Tool (SCT) to automate schema conversion and identify manual remediation requirements.
   • Utilized AWS Database Migration Service (DMS) for the actual data migration, with customizations to handle the high transaction rate.

Key Challenges and Mitigation Strategies

• Maintaining business continuity during the migration process, with no compromise on SLAs.
• Addressing data type compatibility differences between Oracle and PostgreSQL.
• Handling large data volumes (up to 100TB) within the PostgreSQL storage limitations.
• Ensuring reliable data transfer and validation during the migration process.

Benefits and Outcomes

1. Improved Operational Efficiency:

   • Sustained performance and throughput, with some cases of improvement.
   • Optimized cost strategy by leveraging AWS managed database solutions.
   • Enhanced automation and DevOps practices for improved cloud management.

2. Enhanced Reliability and Scalability:

   • Improved RTO and RPO capabilities through multi-AZ and multi-region strategies.
   • Simplified disaster recovery and failover processes with Aurora PostgreSQL's headless DR feature.
   • Seamless horizontal scaling to accommodate growing business needs.

3. Improved Security and Compliance:

   • Leveraged AWS-managed security features, reducing the burden on the internal team.
   • Streamlined compliance and regulatory testing through automation and improved incident management.

4. Cost Optimization and Operational Efficiency:

   • Reduced the Oracle database footprint from a 9-node cluster to a 2-instance Aurora PostgreSQL setup.
   • Eliminated the need for manual Oracle patching and management, freeing up the DBA team to focus on more strategic initiatives.
   • Achieved over 30% reduction in patching and DR testing efforts compared to the previous Oracle-based infrastructure.

Collaboration and Partnerships

• CCC collaborated with AWS and Cognizant, a strategic partner, throughout the modernization journey.
• Cognizant's expertise in PostgreSQL and application modernization, as well as their deep understanding of CCC's landscape, were instrumental in the successful execution of the project.

Conclusion

CCC's database modernization journey from Oracle to AWS Aurora PostgreSQL exemplifies the benefits of cloud-based database solutions. By addressing technical challenges, mitigating risks, and leveraging AWS managed services, CCC achieved improved operational efficiency, enhanced reliability, and cost optimization, ultimately enabling the company to better serve its customers and support its business growth.