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

Edit This Case Study Record

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

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

Qlik

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	UMUC achieved operational cost savings.
Impact #2	UMUC is now able to identify actionable opportunities to increase enrollment and provide the right education to the right students.
Impact #3	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.

Impact #1

UMUC achieved operational cost savings.

Impact #2

UMUC is now able to identify actionable opportunities to increase enrollment and provide the right education to the right students.

Impact #3

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.

Benefit #1	UMUC was able to organize and derive insights from four core datasets, totaling 10 terabytes.
Benefit #2	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.

Benefit #1

UMUC was able to organize and derive insights from four core datasets, totaling 10 terabytes.

Benefit #2

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.

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit