Urban Outfitters migrates Sterling OMS to AlloyDB for PostgreSQL on Google Cloud

Urban Outfitters, Inc. (URBN) recently completed a major infrastructure upgrade, migrating its IBM Sterling Order Management System (Sterling OMS) from an Oracle database to Google Cloud‘s AlloyDB for PostgreSQL. The 11TB Oracle database was increasingly becoming a bottleneck due to high licensing and maintenance costs, growing operational complexity, and the constraints of proprietary technology. URBN needed a modern database solution that could reduce total cost of ownership, ensure business continuity with high availability and rapid failover, embrace open standards to avoid vendor lock-in, and maintain full feature parity without disrupting Sterling OMS functionality.

The migration success relied on deep collaboration between URBN, IBM, and Google Cloud. Key technical pillars included first-tier database recognition for AlloyDB by Sterling OMS, an enterprise-grade architecture with two read replicas for low-latency reporting and improved operational resiliency, extensive performance tuning by a dedicated Google Cloud team to exceed Oracle benchmarks, and rigorous iterative switchover testing. This testing involved running Sterling OMS on AlloyDB for a full day before switching back to Oracle, allowing teams to identify and resolve issues proactively.

The move to AlloyDB for PostgreSQL delivered a more favorable TCO through optimized storage and compute architecture, while also providing the flexibility of an open-source ecosystem. The migration unlocked superior performance and scalability, with significant speed improvements directly enhancing the responsiveness of the Sterling Commerce system. URBN’s experience provides a blueprint for organizations looking to modernize mission-critical infrastructure and future-proof their environment, emphasizing the importance of phased, risk-mitigated approaches and cross-organizational partnership.