Data Migration to Hadoop Platform and process large data set

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

data_migration-casestudy-banner

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

The new migrated Hadoop platform helped the client to improve the performance processing time of the weekly data by 80%.

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

theme-park-data-migration-casestudy

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

Download Case Study

Explore more of our client stories

Download Case Study