The ULCC Leverages Centerprise Data Integrator for ETL and Data Synchronization to Automate Data Movement Among its Information Systems
Company Size
200-1,000
Region
- America
Country
- United States
Product
- Centerprise Data Integrator
Tech Stack
- Oracle DB
- MySQL
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Functions
- Business Operation
Services
- Data Science Services
About The Customer
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 Challenge
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 Solution
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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
