Enabled a large theme park to migrate, and process their data quickly and improve customer services

Migrating from SAS to Hadoop for Efficient Data Processing for a Theme Park

Case Study: Migrating from SAS to Hadoop for Efficient Data Processing for a Theme Park

About the Client

The client is a leading theme park based in the US. The client maintains a customer data environment by getting data from multiple sources.

The Business Challenge

The client wanted to process the incoming data at a faster pace to improve its services. The client was getting its data from two sources (Omniture and Digital Envoy) where the processing time was around four days for a week’s worth of data.

What Aptus Data Labs Did

We migrated the client’s database from SAS to the Hadoop platform to process data from the two sources quickly.

The Impact Aptus Data Labs Made

Our approach helped the client to

The Business and Technology Approach

Aptus Data Labs used the below process to migrate the data and solve the existing challenge. Aptus Data Labs:

  • Transferred the data files from landing to the Hadoop cluster
  • Loaded data files to HDFS
  • Converted all SQL scripts to Hive Scripts
  • Loaded the processed data to a staging location on the Hadoop platform

The Architecture & Work Flow

Tools Used

  • Hortonworks
  • SAS platform – Campaign
  • Legacy CRM
  • CDE platform

The Outcome

The migrated Hadoop platform helped the client to increase the data processing performance by 80%. The client was able to use the Hadoop platform as a storage and data processing engine for data derived from both the sources. The capability helped the client to make better business decisions quickly.

Related Case Studies

Case Study: Achieving Low-Latency API-Based Queries with MongoDB

Achieving low-latency API-based queries with Mongo DB

Performance analysis - MapR DB vs. Mongo DB - Tool Selection Process
Read More
Case Study: Revolutionizing Pharma Analytics with AWS Data Lake

Revolutionizing Pharma Analytics with AWS Data Lake

Enterprise Data Lake and Analytics implementation for a large Pharmaceutical Company in India on AWS platform
Read More
Case Study: Boosting Performance with Apache Spark Migration

Boosting Performance with Apache Spark Migration

Data Migration & Performance Improvement of large data processing
Read More
View all Case Studies

Unlock the Potential of Data Science with Aptus Data Labs

Don't wait to harness the power of data science - contact Aptus Data Labs today and start seeing results.

Get In touch with our  Experts

If you’re looking to take your business to the next level with data science, we invite you to contact us today to schedule a consultation. Our team will work with you to assess your current data landscape and develop a customized solution that will help you gain valuable insights and drive growth.

Get In Touch