fbpx

How a Luxury Retailer Uses Near Real-time Data to Improve Customer Service and Grow Market Share

Customer-Service-and-Market-Share-1.jpg

Combining SAP and Google BigQuery for Success

Access to vital SAP data

Founded in Germany in 1881, the luxury department store Breuninger is one of Germany’s most successful fashion and lifestyle businesses. With 5,500 employees, it offers 1,200 brands across 13 department stores in Germany and Luxembourg and an online storefront in Austria, Germany and Switzerland.

Breuninger’s primary aim is to preserve and expand its market share by delivering excellent customer service. However, identifying customer needs and acting quickly with marketing campaigns relies on gaining real-time access to large amounts of data tied up in its SAP systems. The data access was problematic because traditional Extract, Transform, Load (ETL) processes require a lot of labor-intensive manual scripting and are prone to human error. Inaccurate and untrusted data is delivered when engineers add new data sources to brittle ETL pipelines.

Breuninger’s fragmented technology stack further complicated access to vital data, with many silos such as CRM, ERP, billing, inventory and POS, all with their sources and requirements. “SAP holds data on many corporate functions and also our 60-year-old Breuninger Card – a loyalty program built around an SAP sub-module,” says Matthias Krenzel, Head of Data Platform Services, Breuninger.

“One of our unique challenges was to get that data out of SAP faster because our CRM team needs close to real-time data to drive its campaigns. The key was how quickly after purchase we could enable customers to share their insights on what they had just bought, and that meant getting the data out of SAP as fast as possible.”

Quicker data pipeline builds

Breuninger decided to use BigQuery, Google Cloud’s fully managed enterprise data warehouse. BigQuery’s data security features make it ideal for the sensitive datasets held in SAP systems; it can accommodate both SAP and non-SAP data and easily integrates with SAP.

The missing component for near real-time data access was a tool to transfer data from SAP to BigQuery efficiently. Already a satisfied user of Qlik analytics software, Breuninger chose the open, end-to-end Qlik Data Integration platform featuring Qlik Replicate.

“Having our warehouse based on BigQuery, we wanted tight integration with the existing stack,” adds Matthias. “We did not want to start from scratch and needed a solution that would leave us free to concentrate on our core competency of serving the customer.”

For a proof of concept (POC), Breuninger set up SAP as the data source, and the initial target was a PostgreSQL database in Google Cloud and from there on to BigQuery. In the POC Qlik’s engineers set up the pipelines in just a few hours, and the POC revealed that data delivery was as near real-time as possible. Qlik Replicate allows Breuninger to integrate SAP data with other data from various sources across the company then consolidate it all in BigQuery.

Near real-time data for sound decisions

Continuous end-to-end availability of analysis data, automated processes and Qlik’s Change Data Capture (CDC) technology enables the company to deliver faster data for decision-makers. Decreasing daily SAP demands also means it can reduce money spent on external SAP contractors.

“The Qlik solution automatically carries over any schema changes at the source to the target and is nearly maintenance-free, to the point that I would say it’s the least maintenance-intensive pipeline we run,” says Matthias. “When I didn’t get any error messages, I had to keep checking that Replicate was still working. It was!”

Looking to the future, Breuninger plans to add new SAP data sources for new use cases and is now looking to extend the use of the Qlik Data Integration platform to other source systems beyond SAP. It is also looking at CDC for other on-prem relational databases.

“Effective use of data analytics in real-time to address customer needs is a critical part of our business as a modern retailer,” concludes Matthias. “With Qlik Data Integration automating the flow of data from SAP and various other systems into BigQuery, we’re confidently able to respond to market changes with the timely data we need for good business decisions.”


This article is sponsored by Qlik

Share this post

Leave a Reply

scroll to top