Client background:A leading online value retailer in UK, providing personal shopping service to around 1.8 million of customers every year through a combination of direct marketing and online.
Industry: Retail eCommerce
Products/Services: SAP BusinessObjects

Leveraged SAP BODS to build DWH for a leading retailer

Business Challenge

  • Data from disparate systems – DB2,SQL Server, Feed files, IBM MQ

  • Changes to the Data Warehouse

  • Re-Branding of Existing Business into multiple Operations (Ace, Studio)

  • 400+ Migration of BI Reports to new environment with new business logic

Business Solution

  • Adopted a short-term tactical solution, followed by a long-term solution

  • Short-term solution involved making changes to DWH, loading data into Staging and then on to ODS and finally into EDW

  • Built the DWH using SAP BODS

  • Migrated BI reports into the new environment

  • Re-branded business operations

Business Benefits

  • Eliminated multiple system and created a single system thereby centralizing the process

  • Promoted better flexibility and leverage through the solution

  • Created historical feed by combining multiple source systems into a central system

  • Eliminated manual inconsistencies/Intervention


  • SQL Server Enterprise Edition 2017

  • SAP BODS 4.2

  • SAP Business Objects 4.2 SP5