Download PDF
Redwood Logistics' Supply Chain Transformation with Fivetran and Snowflake
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
