ICON Builds Bi-Directional Transatlantic Replication With RheoData
About ICON
ICON is a medical development company with research and development offices in Europe and the United States.
Situation
ICON needed to keep development environments and data continuously synchronized between its Dublin, Ireland and Raleigh, NC offices, which required both a proven replication tool and an architecture engineered for a transatlantic footprint. ICON partnered with RheoData to confirm feasibility, then design, architect, and implement bi-directional replication on a tight project timeline.
Action
RheoData worked with ICON to validate Oracle GoldenGate as the right tool through a proof-of-concept, then designed a bi-directional replication architecture between Dublin and Raleigh that was stubbed for future horizontal and vertical growth. The team established Oracle GoldenGate 21c and Oracle Database 19c settings tuned for scale and configured Automatic Conflict Detection and Resolution (AutoCDR) to manage write conflicts across both regions. RheoData implemented Oracle GoldenGate Veridata to continuously validate data integrity between sites and configured Oracle GoldenGate High-Availability to keep replication running without interruption. CDC and DDL changes were enabled in both directions so schema and data changes flow seamlessly between offices. Throughout the engagement, RheoData applied industry best practices so ICON would walk away with a reusable blueprint, not just a one-off deployment.
Impact
ICON achieved a fully operational transatlantic architecture with bi-directional replication running at 7ms or less in both directions, capturing data changes in real time and replicating them within seconds across the Atlantic. The project delivered a 75% increase in operational readiness, ensured both offices work from accurate and synchronized data, and gave ICON a future-ready blueprint for building high-volume replication architectures across large geographical regions.