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

Edit This Case Study Record

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

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

Astera

Technology Category	Platform as a Service (PaaS) - Data Management Platforms
Applicable Functions	Business Operation
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Data Management Platforms

Applicable Functions

Business Operation

Services

Data Science Services

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.

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

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.

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

Impact #1

Streamlined ETL and Data Synchronization Processes for Faster Data Movement

Impact #2

Automated the data synchronization process through workflows and job scheduling to minimize the manual effort

Impact #3

Generated the required datasets for reporting and analytics

Benefit #1	70 percent reduction in the time spent in creating synchronized database tables
Benefit #2	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

Benefit #1

70 percent reduction in the time spent in creating synchronized database tables

Benefit #2

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

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit