Wendy’s
Wendy’s is an international fast food restaurant chain having around 7,000 branches worldwide. Out of all the branches, only 5% are company-owned restaurants whereas rest of them are franchised branches.
Wendy’s has various functional areas and there is collected big data about these departments. Data/Reports related to the company-owned branches were centralized but it was not centralized with franchise branches. Wendy’s wanted a big data solution to better analyze the business areas in order to improve business KPIs and to best utilize their available resources.
Challenge
- QSR Restaurant owners do not have self-service capabilities and rely on corporate for analysis
- Limited capability for Market Basket Analysis
- Approaching hardware limits and need to procure additional capacity
Solution Delivered to Meet Challenges
- Change of ETL tool (Informatica to Snaplogic)
- Create reporting dashboards on Qlik
- Building a data lake on S3
Architecture Diagram
AWS Services Used
- AWS Redshift
- AWS Redshift Spectrum
- AWS S3
- AWS EC2 (Qlik and Snaplogic Servers)
- AWS Cognito
- AWS EMR
- AWS Lambda
- AWS IAM
- AWS VPC
- AWS CloudWatch
- AWS SSM
- AWS API Gateway
- AWS Elastic Search
- AWS DynamoDb
- AWS EFS
- AWS Athena
Database Workload Migration Details
- 1 Oracle database
- 1 SQL Server database
- Overall 150+ Tables having size of more than 10 TB.
- SMG (Survey Management System) – JSON Files
- Sources and Targets:
- Oracle Exadata -> Redshift
- Oracle Exadata -> S3
- SQL Server -> Redshift
- SQL Server -> S3
Migration Patterns Used
- Converted Informatica ETL logic into Snaplogic
- Extrated useful information from oracle and ms sql to Redshift
Migration Tools Used
- Snaplogic
Third-Party Tools Used
- Snaplogic (ETL Tool)
- Qlik Sense (Reporting Tool)
About NorthBay
We are a fast-growing, 100% AWS focused onshore/offshore AWS Premier Consulting Partner, supporting our customers to accelerate the reinvention of their applications and data for a Cloud-native world. Our >350 AWS Certified Employees excel in developing and deploying Database & Application Migrations, Data Lakes and Analytics, Machine Learning/AI, DevOps and Application and Data Modernization/Development that drive measurable business impact.
