Client Description

Ryder System, Inc. provides a continuum of logistics, supply chain, and transportation management solutions worldwide. The Company’s offerings range from full-service leasing, commercial rental and maintenance of vehicles to integrated services. The Company also offers comprehensive supply chain solutions, logistics management services, and e-Commerce solutions.

When it comes to commercial vehicles and distribution, Ryder System wants to be the designated driver. The company’s Fleet Management Solutions (FMS) segment acquires, manages, maintains, and disposes of fleet vehicles for commercial customers. Similarly, the Supply Chain Solutions (SCS) segment provides logistics and supply chain services from industrial start (raw material supply) to finish (product distribution). SCS also offers dedicated contract carriage service by supplying trucks, drivers, and management and administrative services to customers on a contract basis. Ryder’s worldwide fleet of more than 222,000 vehicles ranges from tractor-trailers to light-duty trucks.

Ryder operates through three main divisions: Fleet Management Solutions (FMS — full service leasing, contract maintenance, contract-related maintenance and commercial rental of trucks, tractors and trailers, in North America and the UK); Dedicated Transportation Solutions (DTS — provides vehicles and drivers as part of a dedicated transportation solution in the US), and Supply Chain Solutions (SCS — supply chain solutions including distribution and transportation services, in North America and Asia).

Ryder operates in North America (Canada, Mexico, and the US), Europe (Germany and the UK), and Asia (China and Singapore).

Challenge

Ryder corporation purchased SAS for their analytics reporting needs.  The software was capable of merging all of the various pieces of enterprise data into analytic reports, however, the software lacked the capability to acquire their data from the various source systems and platforms.

Building a typical data acquisition process has plenty of challenges with data record quantities, data matching, and processing time windows.  However, performing this task on a wide variety of source systems, which included various Oracle, DB2 AS/400, DB2 UDB, SQL Server, and source system files, can be a challenge when trying to write it all to a set of Netezza tables within a specific time window in an organized and maintainable process. In addition to the variety of systems, the quantity of data was in the terabytes, and was spread across over 50 independent nodes.  This required capturing only changed data, but most of the source systems did not have record modification information in the source data.

Solution

The iOLAP Data Management Architects collaborated with the various subject matter experts at Ryder to devise source system processes that would identify new or modified data.  Then the iOLAP Data Management Architects worked with iOLAP Data Management Developers to create the data acquisition processes. 

Benefits

The resulting set of tables in Netezza are populated within the defined time window, and with all of the data needed for SAS.  SAS was able to easily gather and process the data, and produce the required analytical reports in a timely manner.

  • Tools: DB2 AS/400 | DB2 UDB | Netezza | Oracle | SQL Server
  • Categories: Big Data, Strategy
  • Tags: Logistics, Transportation