RATP Dev Lyon operates and maintains the public transport network in Lyon, including metros, trams, and funiculars. Managing such a complex and high-volume environment requires reliable, timely, and scalable data integration across multiple operational and partner systems.

To support its growing data needs and modernize its architecture, RATP Dev Lyon chose Semarchy xDI as a strategic data integration platform—enabling faster data flows, improved reliability, and a unified technology stack.

• Replace a legacy Oracle ODI-based integration stack
• Reduce technology fragmentation (ODI, Talend, multiple tools)
• Enable faster and more reliable data processing
• Support operational reporting and contractual obligations
• Facilitate data exchange with external partners
• Prepare for a modern cloud data platform (Snowflake on AWS)

Beyond technical modernization, the objective was to create a simpler, more scalable, and future-ready data integration framework.

1. Operational data integration & reporting

• Extraction of data from multiple business applications (maintenance, operations, HR, etc.)
• Loading into decision-support databases
• Transformation and exposure via SAP BusinessObjects reporting
• Feeding a central data warehouse used for monthly contractual reporting to SYTRAL (transport authority)

2. Data exchange with ecosystem partners

• Integration of external data sources (e.g., ticketing validation data)
• Automated ingestion of files and APIs
• Distribution of processed data via SFTP to partners (SYTRAL, Keolis, etc.)

3. Technology rationalization

• Migration from Oracle ODI to Semarchy xDI
• Rewriting and consolidating ~30 Talend data flows into xDI
• Standardization on a single integration platform to reduce complexity and maintenance overhead

4. Enabling modern data platform (cloud)

• Use of xDI to feed Snowflake (AWS) as part of a new data platform initiative
• Focus on high-performance data ingestion (ELT approach with DBT for transformations)

5. Partner-supported implementation

• Migration and transformation supported by Nexial (partner)
• Strong collaboration ensuring speed, quality, and continuity

Fast and secure migration

• Transition from ODI completed quickly and smoothly
• Minimal regression, ensuring operational continuity

Simplified architecture

• Consolidation of multiple tools (ODI, Talend) into one unified platform
• Reduced technical complexity and maintenance burden

Improved data reliability & performance

• Robust pipelines supporting critical operational reporting
• Reliable production of monthly contractual performance reports

Enhanced data collaboration

• Seamless data exchange with multiple stakeholders
• Improved ability to ingest, process, and distribute data at scale

Future-ready data foundation

• Successful integration with Snowflake on AWS
• Scalable architecture supporting future data and AI initiatives

High-quality support experience

• Responsive and efficient support from Semarchy teams
• Rapid resolution of technical issues
• Strong overall customer satisfaction over ~3 years of collaboration