Product Data Repository Integration

Helping the world’s largest privately owned optical group achieve its critical business objective seamlessly

Global Optical Retailer


The Client

Company is the world’s largest privately owned optical group. The company has more than 1,600 stores in 10 countries and over 23 million registered customers. It is the largest retail provider of home delivery contact lens and retail dispenser of digital hearing aids in the United Kingdom.

The Challenge

The client required centralization of the product data repository to provide integration between the product data owner and country retail teams as well as integration of the Oracle MDM application with discrete legacy applications to provide product authoring capabilities and enterprise-wide 360° view of product data. There was a requirement to synchronize data in legacy and strategic applications and to driving data consistency across the organization by ensuring quality around the master data. Brand new integration was required with a significant number of existing legacy applications with minimum impact. The current head office application needed to be phased out to be replaced by Oracle and the technology stack had to be upgraded.

The Solution

  • Use of EIP (Enterprise Integration Pattern) architecture, which includes business and technical architecture design
  • Definition of essential functional and technical requirements
  • Analysis of data points and definition of key interfaces between PDH and legacy applications
  • Modularization of the existing application into loosely coupled modules to achieve flexibility for future upgrades
  • First ever implementation of JBossFuse 6
  • Construction of JBI/OSGI integration components using EIP
  • Use of a comprehensive routing engine using Camel (Fuse Mediation Router)
  • Automated integration tests for distributed systems
  • Implementation of a defect free solution for retail interfaces

The Benefits

  • Seamless achievement of business objectives
  • Achievement of consistency in business rules and definitions using an integrated system along with MDM for process and data integration
  • Identification of gaps and new requirements through consistent product information across systems
  • Enhanced ability of in country retail teams to augment product data localizing it for retail sale
  • Step towards decommissioning legacy applications by strategic replacement of Oracle-based solution
  • Replacement of the out-of-support technology stack with the latest stack