Denodo Technologies Case Studies Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics

Edit This Case Study Record

	Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics Denodo Technologies

Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics

Denodo Technologies

Technology Category	Analytics & Modeling - Real Time Analytics Infrastructure as a Service (IaaS) - Cloud Computing Infrastructure as a Service (IaaS) - Cloud Storage Services
Applicable Functions	Business Operation
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Cloud Planning, Design & Implementation Services Data Science Services
Challenge	Prologis, a global real estate asset management company, was struggling with its data management system. The company's data was stored in a variety of languages and dispersed across different geographical locations. The existing system was an on-premises data warehouse comprised of 27 servers supporting a series of databases, integration servers, and reporting servers. The system was becoming outdated and inefficient, with ETL scripts needing to be rewritten and re-tested whenever there was a change in the source environment. Migrations were all-day events that required the entire team, and with every test, a complete regression test of the entire stack was needed to ensure that nothing broke. Prologis wanted to modernize its data infrastructure to include cloud capabilities and introduce efficiencies that would accelerate analytics, without causing undue downtime. Read More
About Customer	Prologis is a global leader in logistics real estate solutions. Founded in 1983, the company has 1,600 employees in 19 countries and manages over $111 billion in assets, representing over 797 million square feet across these countries. Prologis collaborates with customers to achieve operational efficiencies, reduce environmental impacts, and improve communities. The company's vast portfolio of real estate assets generates a staggering amount of data every day, which needs to be integrated effectively for the company to operate its business. Read More
Solution	To modernize its data infrastructure, Prologis implemented a Snowflake cloud-based data warehouse alongside its existing on-premises data warehouse. Snowflake's ability to scale on demand based on the query being run and accommodate both structured and semi-structured data made it an ideal choice. To further enhance its data infrastructure, Prologis leveraged the Denodo Platform, which uses data virtualization to integrate data in real time from myriad disparate data sources without replicating data to a new consolidated repository. The Denodo Platform acts as an intelligent data-access layer between data sources and data consumers, abstracting data consumers from the complexities of access. This enabled Prologis to establish a logical data warehouse architecture that provides real-time access to data across on-premises, cloud, and other sources. The Denodo Platform's data catalog lists all available data assets in a single location, and also delivers the listed data on-demand. Using this catalog, Prologis was able to implement a higher level of diligence in data management, providing standard definitions for every column and every view, as well as detailed documentation for every object. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Computing

Infrastructure as a Service (IaaS) - Cloud Storage Services

Applicable Functions

Business Operation

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Cloud Planning, Design & Implementation Services

Data Science Services

Challenge

Prologis, a global real estate asset management company, was struggling with its data management system. The company's data was stored in a variety of languages and dispersed across different geographical locations. The existing system was an on-premises data warehouse comprised of 27 servers supporting a series of databases, integration servers, and reporting servers. The system was becoming outdated and inefficient, with ETL scripts needing to be rewritten and re-tested whenever there was a change in the source environment. Migrations were all-day events that required the entire team, and with every test, a complete regression test of the entire stack was needed to ensure that nothing broke. Prologis wanted to modernize its data infrastructure to include cloud capabilities and introduce efficiencies that would accelerate analytics, without causing undue downtime.

About Customer

Prologis is a global leader in logistics real estate solutions. Founded in 1983, the company has 1,600 employees in 19 countries and manages over $111 billion in assets, representing over 797 million square feet across these countries. Prologis collaborates with customers to achieve operational efficiencies, reduce environmental impacts, and improve communities. The company's vast portfolio of real estate assets generates a staggering amount of data every day, which needs to be integrated effectively for the company to operate its business.

Solution

To modernize its data infrastructure, Prologis implemented a Snowflake cloud-based data warehouse alongside its existing on-premises data warehouse. Snowflake's ability to scale on demand based on the query being run and accommodate both structured and semi-structured data made it an ideal choice. To further enhance its data infrastructure, Prologis leveraged the Denodo Platform, which uses data virtualization to integrate data in real time from myriad disparate data sources without replicating data to a new consolidated repository. The Denodo Platform acts as an intelligent data-access layer between data sources and data consumers, abstracting data consumers from the complexities of access. This enabled Prologis to establish a logical data warehouse architecture that provides real-time access to data across on-premises, cloud, and other sources. The Denodo Platform's data catalog lists all available data assets in a single location, and also delivers the listed data on-demand. Using this catalog, Prologis was able to implement a higher level of diligence in data management, providing standard definitions for every column and every view, as well as detailed documentation for every object.

Impact #1	Prologis was able to transition smoothly to Snowflake with the help of the Denodo Platform, moving chunks of data from the old architecture to the new one without impacting business operations.
Impact #2	The implementation of a logical data warehouse configuration allowed Prologis to accelerate analytics. The company could virtualize a new table and immediately start doing analytics on it.
Impact #3	Prologis leveraged the query push-down capabilities of the Denodo Platform to push key workloads to Snowflake, resulting in substantial performance improvements on larger data sets.

Impact #1

Prologis was able to transition smoothly to Snowflake with the help of the Denodo Platform, moving chunks of data from the old architecture to the new one without impacting business operations.

Impact #2

The implementation of a logical data warehouse configuration allowed Prologis to accelerate analytics. The company could virtualize a new table and immediately start doing analytics on it.

Impact #3

Prologis leveraged the query push-down capabilities of the Denodo Platform to push key workloads to Snowflake, resulting in substantial performance improvements on larger data sets.

Benefit #1	Accelerated analytics activities by as much as 30%.

Benefit #1

Accelerated analytics activities by as much as 30%.

Download PDF Version

Overview

Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics

Operational Impact

Quantitative Benefit