Background
The Union League Club (ULCC) is a private city club which caters to a large network of members across Chicago and beyond. ULCC provides a complete suite of hospitality services, ranging from hosting business and social events to hosting guests for overnight stays to fine dining experiences, health and spa services, and various leisure facilities. With so many diverse services, the Club uses multiple systems to track membership data, room availability, scheduled events, inventory, etc. To extract, sync, and manage data and derive insights for analytical and reporting purposes, the ULCC needs a functioning ETL processes to facilitate data transfers and synchronization among its information systems.
Use Case
The ULCC has three main systems that handle all of their incoming data. The first and most used of these is Northstar, which manages membership details, accounting, budgeting, events and catering, inventory, and more. Northstar uses a MySQL database to store all of this information. The data from Northstar is exported via a CSV format and fed into the ULCC website, which is powered by the second system—ClubEssentials, a web development platform which manages member activity and data. Finally, the third system, ResortSuite, handles room reservations at ULCC.
All three systems work in tandem to provide a complete picture of membership and club data. This enables ULCC to make decisions based on data, which helps effectively manage resources, finances, services, and activities for an overall better member experience. In order to allow these three systems to communicate with each other, ULCC was using a data integration solution which allowed them to move and orchestrate data between the MySQL (used by Northstar) and Oracle (used by ResortSuite) databases. The solution additionally helped map specific tables from each system to keep all the information up to date and consistent.
However, this ETL solution had a steep learning curve for new users and high costs for product license renewal and tech support extension. Over the years, the costs of the ETL solution effectively tripled. Additionally, the solution had outdated functionality and lacked proper product documentation.
“With Astera, we purchased a block of professional service hours and worked with a data specialist. We provided them with the original XML files (of the old product), and assisted them in ‘picking apart’ the dataflow and getting it operational. After a few calls, they understood how the dataflow should work, and we were able to create the dataflows and workflows from scratch. They attentively worked with us and our vendors during the testing phases to ultimately achieve the tasks at hand.”
– Brian Williams, IT director
Enter Astera Data Pipeline Builder
The IT director at ULCC, Brian Williams, explored new options that would better fit the club’s needs. After a demo of Astera Data Pipeline Builder Data Integrator, Williams found that the product fit every single requirement.
Astera Data Pipeline Builder is a high-performance, scalable data integration platform that allows businesses to meet today’s advanced data needs. Powered by an enterprise-grade, parallel processing engine, Astera Data Pipeline Builder offered ULCC data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform.
Profile
The Union League Club of Chicago (ULCC) is a private city club that caters to a large network of members across Chicago and beyond.
Industry
Hospitality
Use Case
ULCC works with three main systems which need to be integrated to synchronize data across the organization. The system they used in the past had a steep learning curve and lacked proper product documentation.
Product
Astera Data Pipeline Builder
Result
Using Astera Data Pipeline Builder has led to a 70 percent reduction in the time it takes to create synchronized data tables across the ULCC’s main systems.
Leveraging Astera Data Pipeline Builder’s workflow automation and job scheduling features, ULCC saw a stark reduction in the time spent executing, monitoring, and adjusting dataflows and workflows. The Club experienced a 70 percent decrease in the total time spent on creating synchronized database tables. Astera Data Pipeline Builder Data Integrator not only proved to be a cost-effective solution, but also checked all of the boxes for an intuitive, user-friendly interface with workflow automation and job scheduling.
“With Astera Data Pipeline Builder, we only spend half an hour a week to check if everything is running as it should, as compared to three to four hours a week previously, which also required making adjustments to the dataflows and workflows.”
– Brian Williams, IT Director
