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

Wendy’s – AWS Database Migration

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.