A Property Management Company

4-Week Cloud-Based Data Warehouse with Snowflake.

An Overview

The Challenge

A Chicago property management company wanted to centralize multiple sources into a Snowflake cloud-based data warehouse in a tight, 4-week timeframe.

The Solution

The 2nd Watch team was able to leverage Alooma to integrate multiple data sources quickly into Snowflake. A custom integration solution was used to bring in more complex data sources.

The Outcome

At the end of the 4-week time period, we had the foundations of a cloud-based data warehouse that enabled our client to streamline business processes and provide better business insights.

01

The Challenge

A Chicago property management conglomerate wanted to move data from multiple sources to a centralized Snowflake cloud-based data warehouse in a tight, 4-week timeframe. They chose 2nd Watch because of our data migration experience and certification of the tools needed to effectively do this on time and on budget.

02

The Solution

The 2nd Watch team focused on the integration of two main sources: a database and a non-standard application API. We were able to get data flowing from the SQL database within one day using the built-in connector in Alooma.

The API integration proved to be a bigger challenge. While Alooma does have a built-in API connector, the complexity of this particular API required a workaround. Our team rose to the challenge and created functions in AWS to contact the API, access the necessary data, and pass it to Alooma in batches. Although the process required some technical creativity, it worked perfectly in the end and the data was soon flowing into Snowflake.

03

The Outcome

Although we had a short period of time for this project, the 2nd Watch team was able to leverage Alooma, Snowflake, and our own experience to create a cloud-based data warehouse that will enable our client to streamline business processes and provide better business insights.