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

Executive Summary

3Hold Technologies, an AWS Advanced Consulting Partner, helped Dinosol Supermercados create and implement an AWS-based point-of-sale (POS) data lake solution that provides a centralized view of POS data. The solution has resulted in an improved experience for shoppers and will eventually help Dinosol analyze customer behavior. The POS data lake integrates AWS services such as Amazon RDS, Amazon Redshift, and API Gateway with the Dinosol POS system and SAP applications.

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 with 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. “We have to provide the strongest possible customer service, and we needed more scalability to meet the demand on our ecommerce system,” says Eduardo Prieto, director of IT at Dinosol Supermercados.

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. “We had decentralized POS data and we wanted to find a solution that could enable us to collect it in one place and scale it quickly when necessary,” Prieto says.

“AWS is the right technology for our company. We look forward to working with 3Hold as we continue our growth.”

- Eduardo Prieto, Director of IT, Dinosol Supermercados

3Hold Creates a POS Data Lake on AWS

Dinosol decided to migrate its applications, including a growing SAP environment, to AWS for increased scalability and flexibility. “AWS offers an excellent selection of cloud technology and services,” Prieto says. Dinosol engaged 3Hold Technologies, a Spanish technology services provider and an 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. Magento then assigns the data to a corresponding customer ticket. All Dinosol supermarkets are currently taking advantage of the POS data lake.

Gaining Full Visibility into POS Sales Data

Dinosol now has a centralized view of its POS sales data thanks to the integration of the company’s POS system, SAP ERP system, and ecommerce application. “The POS data lake solves Dinosol’s challenge of decentralized POS data,” says Juan Vargas, director of sales and marketing at 3Hold Technologies. “As a result, all Dinosol departments can more easily access store transaction data in near-real time.”

Customer Landscape Diagram

Dinosol Supermercados

Giving Shoppers a Better Experience

Because of its low-latency database and automated scalability, the POS data lake can quickly ingest POS data and grow to meet Dinosol’s business demands. Every day, about 150,000 POS tickets are uploaded and stored in AWS from the moment of transaction. Each ticket is integrated from SAP PO into AWS in under 1,500 milliseconds. “We’re a growing company, and we can quickly add compute capacity on AWS to support thousands of new customers making purchases through our POS system,” says Prieto.

By uploading and accessing POS data so rapidly, Dinosol can ultimately deliver an improved customer experience. “We want customers to immediately get a digital receipt on their mobile phone as they leave the store,” Prieto says. “We can do that with this solution by ingesting tickets as fast as possible, so we can help our stores run more smoothly and give our customers the best possible shopping experience.”

Analyzing Customer Shopping Patterns

In the next phase of the POS data lake implementation, Dinosol will use its POS data to make better, faster decisions. Specifically, the company hopes to analyze customer purchasing patterns or the performance of specific seasonal products, and to develop actionable insights in response. “For example, with the data in Amazon Redshift, Dinosol will be able to look at sales patterns to determine which products are top sellers,” says Vargas.

As it looks to expand its use of AWS, Dinosol is currently evaluating the development of a disaster recovery solution. “AWS is the right technology for our company,” says Prieto. “We look forward to working with 3Hold as we continue our growth.”

 

Dinosol Supermercados Technology Landscape
 Click to enlarge

Dinosol Supermercados Technology Landscape

HiperDino

About Dinosol Supermercados

Based in Spain, Dinosol Supermercados operates a chain of supermarkets on five of the Canary Islands. The company has more than 200 stores and employs over 6,000 people.

About 3Hold Technologies

3Hold Technologies is a Spanish technology services provider that works with customers across the globe. An AWS Advanced Consulting Partner, the company specializes in providing cloud solutions, SAP consulting and technology services, and managed services.

Published July 2021