Qlik > Case Studies > University of Maryland College Uses Attunity Software to Replicate Data to the AWS Cloud

University of Maryland College Uses Attunity Software to Replicate Data to the AWS Cloud

Qlik Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • Amazon Redshift
  • Amazon RDS
  • Attunity Software
  • Oracle Streams
  • Oracle Data Integrator (ODI)
Tech Stack
  • Oracle DB
  • Microsoft SQL Server
  • Amazon EC2
  • Salesforce
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
  • Digital Expertise
Technology Category
  • Infrastructure as a Service (IaaS) - Cloud Computing
  • Infrastructure as a Service (IaaS) - Cloud Databases
  • Application Infrastructure & Middleware - Data Exchange & Integration
  • Infrastructure as a Service (IaaS) - Cloud Storage Services
Applicable Industries
  • Education
Applicable Functions
  • Business Operation
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
  • System Integration
About The Customer
University of Maryland University College (UMUC) is an institution that provides quality education at an affordable cost to busy professionals. The majority of their students are adults who are juggling work and families and, often times, military service. Like other providers of higher education, UMUC faces increasing pressure to attract the best students and supply a quality education at the right price. To stay ahead of the curve, colleges and universities must ultimately seek a competitive advantage, constantly identifying opportunities for improvement. To achieve this, UMUC launched a big data strategy on the strengths of Amazon Web Services.
The Challenge
University of Maryland University College (UMUC) was facing the challenge of organizing and deriving insights from four core datasets, totaling 10 terabytes. These datasets included data related to online student activities, student enrollments, financials, and customer relationship management. The data was stored in a mix of on-premises Oracle and SQL Server databases, Salesforce, and other cloud-based service applications. UMUC’s challenge was to aggregate these disparate data sources, normalize the data, and then load it into a data warehouse for analysis. This was a classic ‘data integration challenge’ that included extracting data from source systems, staging the data in a relational database and applying transformations, loading data into a data warehouse, and running analytics and providing a visualization layer.
The Solution
UMUC selected Amazon Redshift for its data warehouse, citing its high performance and low cost. To address the data integration challenge, UMUC turned to the AWS Marketplace and chose Attunity for Amazon Redshift. In the past, UMUC was using Oracle Streams to collect data from Oracle Databases and load it into an Operational Data Store (ODS) for transformation using Oracle Data Integrator (ODI), before ultimately loading into a data warehouse for analysis. However, some of the data sources are located on Microsoft SQL Server databases and Oracle Streams is not able to load from non-Oracle databases. To work around this challenge, the team at UMUC had to manually extract data from their SQL Server databases and combine it with their Oracle source data–a time-consuming process. UMUC leveraged Attunity software to both speed up their data movement and have a single point of management for all data movement. This gives the University greater visibility and flexibility when they choose to add or remove data sources or targets in the future.
Operational Impact
  • UMUC achieved operational cost savings.
  • UMUC is now able to identify actionable opportunities to increase enrollment and provide the right education to the right students.
  • UMUC can now make sense of patterns, including understanding enrollment trends and demand for academic programs, measuring student and faculty engagement in online course, analyzing patterns of re-enrollment and course taking behaviors, identifying ‘at risk’ students that need assistance, and drilling down on the effectiveness of marketing campaigns.
Quantitative Benefit
  • UMUC was able to organize and derive insights from four core datasets, totaling 10 terabytes.
  • UMUC's centralized management of Attunity tasks runs on just a single Amazon EC2 machine, achieving near real-time replication across the mesh of sources & targets.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.