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

Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake

Fivetran Logo
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • On-premises SQL data is now replicated into the Snowflake Data Cloud by Fivetran log-based change data capture.
  • More data can be processed and accessed faster with minimal source system impact.
  • Developer resources were freed from fixing broken pipelines to designing and architecting downstream processes.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.