Airlines
Wipro · LATAM
India · December 2025
Oracle to Cloud SQL PostgreSQL — LATAM Airlines CROAMIS modernization with 98% automation
South America’s largest airline group successfully migrated its mission-critical CROAMIS module — a 17 TB Oracle database with over 10 million Java lines of code — to Cloud SQL PostgreSQL on GCP. Powered by Newt Global’s DMAP platform, the migration achieved 98% automation, optimized the database to 7 TB, and completed at record speed without disrupting airline operations.
Oracle → Cloud SQL PostgreSQL
17 TB → 7 TB
98% Automation
10M+ Java LOC
DMAP
Google Cloud Platform
Customer
LATAM Airlines Group S.A. via Wipro Limited
- Industry
- System integrator
- Primary Location
- Migration
- Source DB size
- Optimized DB size
- Automation achieved
- Published
- Airlines
- Wipro Limited
- India
- Oracle → Cloud SQL PostgreSQL
- 17 TB
- 7 TB
- 98% via DMAP
- December 25, 2025
Source Oracle database size across 29 schemas
Automation delivered by DMAP for schema & SQL remediation
Java lines of code remediated for Cloud SQL compatibility
Optimized database size post-migration on GCP
Background
LATAM Airlines Group S.A. is the largest airline group in South America and one of the largest globally by passengers transported, operating both passenger and cargo businesses across the continent and beyond. Wipro Limited, a global systems integrator headquartered in Bengaluru, India, serves as LATAM’s strategic technology partner — and engaged Newt Global to lead the Oracle modernization initiative.
The target system, CROAMIS, is one of LATAM’s most critical operational modules — deeply embedded in the airline’s day-to-day operations. Migrating a system of this scale and complexity to Google Cloud SQL PostgreSQL required an approach that could handle massive data volumes, thousands of code objects, and intricate inter-schema dependencies — all without disrupting live airline operations.
The challenge
Key obstacles
- Hundreds of database objects with complex, interdependent schema relationships requiring coordinated conversion sequencing
- 29 schemas with deep inter-schema dependencies — one of the most complex schema conversions ever attempted
- 10 million+ Java lines of code requiring systematic SQL remediation for PostgreSQL compatibility
- Mission-critical airline systems — any failure, data loss, or extended downtime is operationally catastrophic
- 17 TB of data requiring validated migration with full data integrity guarantees across dev and pre-prod environments
- Coordinated conversion sequencing needed to respect complex inter-schema dependency chains
The solution
Automated schema conversion with DMAP
DMAP analyzed all 29 Oracle schemas and their interdependencies, generating a coordinated conversion sequence that respected the complex inter-schema dependency chains. Schema objects — tables, views, indexes, constraints, sequences — were converted automatically to Cloud SQL PostgreSQL-compatible equivalents.
SQL remediation across 10M+ Java lines of code
DMAP scanned and remediated Oracle-specific SQL constructs embedded within LATAM's Java application codebase. This included PL/SQL rewrites, data type mappings, function substitutions, and stored procedure conversions — all executed at scale with 98% automation, dramatically reducing manual effort.
Multi-environment validation across dev and pre-prod
Schema and data migration were validated rigorously across development and pre-production environments using DMAP's built-in validation framework — ensuring row count parity, data type accuracy, and full referential integrity before any production data was touched.
CDC-based synchronization for cutover
Change Data Capture was used to maintain continuous synchronization between Oracle and Cloud SQL PostgreSQL during the final cutover window — minimizing the data gap and ensuring a smooth, near-zero downtime production transition for LATAM's live airline operations.
Database optimization to 7 TB
As part of the migration, Newt Global also optimized the database structure for PostgreSQL's architecture — eliminating Oracle-specific bloat, reorganizing storage, and restructuring data models. The result: the 17 TB Oracle database was optimized to just 7 TB on Cloud SQL, significantly reducing storage costs on GCP.
The result
98%
Record speed
17 → 7 TB
17 → 7 TB
Before migration
17 → 7 TB
After migration
7 TB
Cloud SQL PostgreSQL on GCP — 58% smaller
Technology stack
Oracle Database
Cloud SQL for PostgreSQL
Java
DMAP
Schema Conversion
SQL Remediation
CDC (Change Data Capture)
Data Integrity Validation
Google Cloud Platform
Key outcomes
- Production cutover achieved in 12 weeks
- 4.6M lines of Java/NodeJS code remediated
- All Oracle databases migrated to AlloyDB
- Four test environments validated before go-live
- Interfaces and shell scripts adapted for AlloyDB
- CDC + Reverse CDC rollback plan executed flawlessly
- 40+ cross-timezone team coordinated seamlessly
About Hughes Network Systems
A Fortune 500 company and leader in networking technologies and services, Hughes enables essential connectivity for communities, businesses, and governments worldwide. Named a Leader in the 2023 Gartner® Magic Quadrant™ for Managed Network Services.
About Newt Global Consulting
A leader in both heterogeneous and homogeneous database migration with application remediation. Newt’s DMAP platform delivers end-to-end, light-speed solutions for database, data, and application modernization on Google Cloud.
Ready to migrate?
See how DMAP can accelerate your Oracle to AlloyDB or Cloud SQL migration.
About LATAM Airlines Group
The largest airline group in South America and one of the largest globally by passengers transported. LATAM group operates passenger and cargo businesses, with operations across South America and beyond.
About Wipro Limited
A global technology services and consulting company headquartered in Bengaluru, India. Wipro serves as LATAM's strategic systems integrator and engaged Newt Global to deliver this Oracle modernization project.
