RETAIL DATA STORE

The goal is to integrate all date from relevant sources into the retail data store.

Currently linked sources:

  • REWE merchandise management
  • SAP (partly also as ABAP dataflow)
  • Warehouse management system
  • HR software (DPW)
  • CRM software (OROCRM)
  • Frequency measurement in the branches
  • Sales slips as XML
  • iDocs (Webshop CH)

These should be used for the central reporting. In the retail data store (RDS/DWH), the corresponding cubes (SAP HANA Calculation Views) are built that can be accessed via SQL or Tableau.

AVAILABLE CUBES

  • Sales cube (DE/AT/CH)
  • HR cube (DE/AT)
  • Data mining cube (e.g. aggregated data for shopping basket analysis, links with promotions and newsletter/flyer campaigns).

Additional cubes for purchasing and Office World (CH) have been planned or are in progress.

STACK

Datenbank:

Oracle 7-18c, SAP HANA 1.0 SPS12, SAP HANA 2.0 SPS 3, postgresql 9.6/10, mariadb 10.1/mysql 5.7

ETL Tools:
SAP Data Services 4.2 SP 9, IBMData Stage inkl. Enterprise Edition zuletzt Version 8, Oracle Data Integrator 11g/12c, Informatica

Programmiersprachen:
PL/SQL, Python 3, Unix Shell Skripte, C / Java – wenig genutzt