The ULCC Leverages Centerprise Data Integrator for ETL and Data Synchronization to Automate Data Movement Among its Information Systems

• 平台即服务 (PaaS) - 数据管理平台

• 商业运营

• 数据科学服务

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

• Streamlined ETL and Data Synchronization Processes for Faster Data Movement
• Automated the data synchronization process through workflows and job scheduling to minimize the manual effort
• Generated the required datasets for reporting and analytics

• 70 percent reduction in the time spent in creating synchronized database tables
• Reduced the time spent in running and scheduling workflows to sync data among the three main systems from 4-5 hours a week to 30 minutes