The ULCC Leverages Centerprise Data Integrator for ETL and Data Synchronization to Automate Data Movement Among its Information Systems
公司规模
200-1,000
地区
- America
国家
- United States
产品
- Centerprise Data Integrator
技术栈
- Oracle DB
- MySQL
实施规模
- Enterprise-wide Deployment
影响指标
- Cost Savings
- Productivity Improvements
技术
- 平台即服务 (PaaS) - 数据管理平台
适用功能
- 商业运营
服务
- 数据科学服务
关于客户
The Union League Club (ULCC) is a private city club that caters to a large network of members from across Chicago and beyond. It provides a complete suite of hospitality services, ranging from hosting business and social events to providing guestrooms for overnight stays, fine dining experiences, health and spa services, and various leisure facilities. Since it offers diverse services, the Club uses multiple systems to track data related to membership, finances, guestroom availability, event planning, inventory, and other aspects. To extract, sync, and manage data and derive insights for analytical and reporting purposes, the ULCC performs ETL processes that facilitate data transfer and synchronization among its information systems.
挑战
The Union League Club (ULCC) is a private city club that offers a wide range of hospitality services. It uses multiple systems to track data related to membership, finances, guestroom availability, event planning, inventory, and other aspects. The ULCC has three main systems that handle membership data, and various facilities and services offered to the members. All the three systems work in unison to provide a complete picture of membership and club activities data. This enables to the ability to extract actionable insights to effectively manage resources, finances, and membership services, for better member experience. To achieve this, the Club must use a data integration solution to move and orchestrate data between MySQL and Oracle databases. The solution also helps in mapping specific tables from each system to keep them up-to-date and consistent for use in further analyses.
解决方案
The IT Director at the ULCC, Brian Williams, explored new vendors to meet the Club's business goals. After taking Centerprise Data Integrator's demo, he short-listed the product as it met their requirements in every way possible. Astera's product experts worked with ULCC's IT team to setup dataflows and workflows that can be executed through a simple query. Leveraging Centerprise's workflow automation and job scheduling features, the ULCC saw a stark reduction in the time spent in executing, monitoring, and adjusting dataflows and workflows for moving and syncing member data. The Club has experienced a 70 percent decrease in the total time spent in creating synchronized database tables. Previously, it used to take the team about 4 to 5 hours a week to deploy the dataflows and workflows - now the same task is achieved in 30 minutes.
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
