Project Description

Dinosol

3Hold Technologies Uses AWS to Help Dinosol Analyze Shopping Data in Near-Real Time

Client

Dinsosol

Business

Retail, Cash&Carry

Sector

Food distribution

Objective

Optimization of commercial processes

Products y services

Amazon RDS, Amazon Redshift, API Gateway, SAP, POS Data Lake

The client

DinoSol is a totally Canarian distribution company that today employs more than 7,000 direct workers in 57 HiperDino stores, 91 SuperDino stores and 76 HiperDino Express stores. Currently, the brand is present in five of the seven Canary Islands.

In addition, through the DinoSol Foundation, it collaborates in solidarity with various actions, supporting the social development of the Canary Islands and always paying special attention to the people who form part of the DinoSol Group.

PREVIOUS SITUATION

Growing Chain Seeks Scalability and Improved Analytics

Dinosol Supermercados is a growing Spanish supermarket chain that operates more than 200 stores throughout the Canary Islands. The company has experienced significant growth over the past year and has seen increasing demand on its digital ecommerce application, which thousands of customers use to purchase goods in stores and online. Because it hosted the application in an on-premises data center, the company struggled to keep pace with growth. They needed to provide the strongest possible customer service, and needed more scalability to meet the demand on their ecommerce system.

Dinosol also needed to centralize all sales information from each store’s point-of-sale (POS) system, so it could better analyze customer purchasing behavior. As they had decentralized POS data and wanted to find a solution that could enable them to collect it in one place and scale it quickly when necessary.

The Solution

Dinosol decided to migrate its applications, including a growing SAP environment, to Amazon Web Services (AWS) for increased scalability and flexibility. Dinosol engaged 3Hold Technologies (AWS Advanced Consulting Partner) for assistance. 3Hold already managed all Dinosol SAP solutions, including the company’s business-critical enterprise resource planning (ERP) application.

3Hold moved the Dinosol POS application and database into Amazon Relational Database Service (Amazon RDS) and containers through Amazon Elastic Kubernetes Service (Amazon EKS). 3Hold then created an AWS-based POS data lake, a centralized and automatically scalable data repository. In this new solution, an SAP Process Orchestration (PO) module analyzes purchasing information collected from each supermarket’s POS system and sends it to Amazon API Gateway. From there, an AWS Lambda function extracts the data—including updated information on promotions, discounts, payments, and surveys—and sends the data to Amazon Redshift tables for visualization.

At the same time, the solution stores plain XML documents in Amazon Simple Storage Service (Amazon S3) buckets and triggers Amazon Simple Notification Service (Amazon SNS). An SNS notification is captured by an AWS Lambda function that sends document data to the company’s Magento ecommerce application. Within Magento, the data is assigned to a corresponding customer ticket. All Dinosol supermarkets are currently taking advantage of the POS data lake.

Benefits

Are you facing similiar challenges?

We help you to design solutions that adapt to your business’ needs