Qlik > 实例探究 > 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
公司规模
Large Corporate
地区
  • America
国家
  • United States
产品
  • Amazon Redshift
  • Amazon RDS
  • Attunity Software
  • Oracle Streams
  • Oracle Data Integrator (ODI)
技术栈
  • Oracle DB
  • Microsoft SQL Server
  • Amazon EC2
  • Salesforce
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
  • Digital Expertise
技术
  • 基础设施即服务 (IaaS) - 云计算
  • 基础设施即服务 (IaaS) - 云数据库
  • 应用基础设施与中间件 - 数据交换与集成
  • 基础设施即服务 (IaaS) - 云存储服务
适用行业
  • 教育
适用功能
  • 商业运营
服务
  • 云规划/设计/实施服务
  • 数据科学服务
  • 系统集成
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • 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.
数量效益
  • 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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。