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.