Fivetran Case Studies Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake

Edit This Case Study Record

	Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake Fivetran

Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake

Fivetran

Technology Category	Functional Applications - Transportation Management Systems (TMS) Infrastructure as a Service (IaaS) - Backup & Recovery
Applicable Industries	Buildings Transportation
Applicable Functions	Logistics & Transportation Maintenance
Use Cases	Last Mile Delivery Transportation Simulation
Services	Cloud Planning, Design & Implementation Services System Integration
Challenge	Redwood Logistics, a third-party logistics and transportation management firm, was struggling with managing a complex reporting structure that relied on multiple siloed warehouses. The rapidly growing business needed a modern data stack that could support its mergers and acquisitions strategy, providing leadership with an accurate overview of business performance in near real time. The company was generating 500,000 data points per hour, which was a significant challenge to manage and process. The old system could only load data once a day and was prone to numerous daily failures, becoming a massive maintenance burden. Redwood was initially cautious about using Fivetran’s high-volume data replication because the team needed to understand how it interacted with their existing databases. Read More
About Customer	Redwood Logistics is a Chicago-based third-party logistics and transportation management firm. The company partners with its clients to develop custom solutions for every area of their supply chains, from warehousing to brokerage and fully managed transportation products. The rapidly growing business has a complex reporting structure that relies on multiple siloed warehouses. Redwood needed a modern data stack that could support its mergers and acquisitions strategy and provide leadership with an accurate overview of business performance in near real time. Read More
Solution	Redwood turned to a team from 2nd Watch, a global cloud services company, to build a modern data architecture. They deployed Fivetran’s high-volume data replication solution to automate the data replication from its on-premise SQL databases to the Snowflake Data Cloud. Fivetran now replicates numerous data types in Redwood’s Snowflake Data Cloud, including operational data, invoicing and payment data, TMS data, rating info, and extensive audit data. This data makes it easy for leadership teams to conduct rapid and comprehensive reporting in Tableau. The enterprise application has replaced numerous spreadsheets and ad hoc inquiries with a more modern data stack and data visualizations from Tableau. Read More Log in to view content
Contents

Technology Category

Functional Applications - Transportation Management Systems (TMS)

Infrastructure as a Service (IaaS) - Backup & Recovery

Applicable Industries

Buildings

Transportation

Applicable Functions

Logistics & Transportation

Maintenance

Use Cases

Last Mile Delivery

Transportation Simulation

Services

Cloud Planning, Design & Implementation Services

System Integration

Challenge

Redwood Logistics, a third-party logistics and transportation management firm, was struggling with managing a complex reporting structure that relied on multiple siloed warehouses. The rapidly growing business needed a modern data stack that could support its mergers and acquisitions strategy, providing leadership with an accurate overview of business performance in near real time. The company was generating 500,000 data points per hour, which was a significant challenge to manage and process. The old system could only load data once a day and was prone to numerous daily failures, becoming a massive maintenance burden. Redwood was initially cautious about using Fivetran’s high-volume data replication because the team needed to understand how it interacted with their existing databases.

About Customer

Redwood Logistics is a Chicago-based third-party logistics and transportation management firm. The company partners with its clients to develop custom solutions for every area of their supply chains, from warehousing to brokerage and fully managed transportation products. The rapidly growing business has a complex reporting structure that relies on multiple siloed warehouses. Redwood needed a modern data stack that could support its mergers and acquisitions strategy and provide leadership with an accurate overview of business performance in near real time.

Solution

Redwood turned to a team from 2nd Watch, a global cloud services company, to build a modern data architecture. They deployed Fivetran’s high-volume data replication solution to automate the data replication from its on-premise SQL databases to the Snowflake Data Cloud. Fivetran now replicates numerous data types in Redwood’s Snowflake Data Cloud, including operational data, invoicing and payment data, TMS data, rating info, and extensive audit data. This data makes it easy for leadership teams to conduct rapid and comprehensive reporting in Tableau. The enterprise application has replaced numerous spreadsheets and ad hoc inquiries with a more modern data stack and data visualizations from Tableau.

Impact #1	Thanks to Fivetran and Snowflake, Redwood can now quickly supply custom and feature-rich data dashboards to internal customers and leadership so they can better track their business metrics. Redwood can access and process more data in a timely manner than before. Fivetran helped Redwood enable its customers to quickly recognize and adjust to changing market trends. Most importantly, Fivetran helped free up Redwood’s team to spend more of their time on value-add projects. The enterprise application has replaced numerous spreadsheets and ad hoc inquiries with a more modern data stack and data visualizations from Tableau, which are now commonplace in daily status meetings.

Impact #1

Thanks to Fivetran and Snowflake, Redwood can now quickly supply custom and feature-rich data dashboards to internal customers and leadership so they can better track their business metrics. Redwood can access and process more data in a timely manner than before. Fivetran helped Redwood enable its customers to quickly recognize and adjust to changing market trends. Most importantly, Fivetran helped free up Redwood’s team to spend more of their time on value-add projects. The enterprise application has replaced numerous spreadsheets and ad hoc inquiries with a more modern data stack and data visualizations from Tableau, which are now commonplace in daily status meetings.

Benefit #1	On-premises SQL data is now replicated into the Snowflake Data Cloud by Fivetran log-based change data capture.
Benefit #2	More data can be processed and accessed faster with minimal source system impact.
Benefit #3	Developer resources were freed from fixing broken pipelines to designing and architecting downstream processes.

Benefit #1

On-premises SQL data is now replicated into the Snowflake Data Cloud by Fivetran log-based change data capture.

Benefit #2

More data can be processed and accessed faster with minimal source system impact.

Benefit #3

Developer resources were freed from fixing broken pipelines to designing and architecting downstream processes.

Download PDF Version

Overview

Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake

Operational Impact

Quantitative Benefit