Company Overview

Schneider National, Inc. is a leader in transportation
and logistics services and has been providing expert solutions for more than 77
years.. With unmatched shipping
capacity, the industry’s best personnel, communication and technology,
Schneider has everything to get the job done. Wherever freight is moved, timeliness, safety and
adherence to budget are distinguishing factors for Schneider.

Challenges and Goals

Schneider National, Inc. was embarking on a multi-year program to
transform their business and IT solutions. Legacy processes and systems were not cost effective to extend and
maintain, and were not allowing the Schneider business to expand and evolve services
as required. Schneider’s goals were to
enable highly effective business processes for internal operations for all
lines of business, and decrease the overall total cost of ownership. Internal systems related to revenue
management tasks, equipment validation, status and inventory control, as well
as systems for driver/shipment assignments would be affected. In this effort, the initiative included a
standardized architecture for designing and building, executing, and managing
the applications and infrastructure across the end to end solution. Oracle was chosen as the technology partner
of choice across applications, middleware, systems management, database, and
infrastructure. Oracle Data Integrator
was specifically chosen as the data movement standard, eliminating the need for
the various other movement tools previously used within the organization. Oracle Data Integrator was tasked with
providing real-time shipment updates across many packaged, custom built, and third-party
external applications; ensuring high performance, scalability, reliability, and
availability. Additionally, operational
reporting and analytical environments needed to have updates from the various
operational systems fed into and transformed to reporting structures.

Solution and Results

A strategic initiative, dubbed The Quest Program, was set in motion and
included a data warehouse, an operational data store, and multiple integration
hubs. Oracle Data Integrator was used as
a foundation for bulk data movement across the board, integrating an
environment with a large number of technologies and application end-point such
as Oracle DB , SQL Server, DB2 z/OS, Siebel, E-Business Suite, Oracle Transportation
Manager, Hyperion and SOA. The data warehouse itself consolidates data from 18
sources to a single Oracle system whereby processing data related to
transportation orders, shipment updates, and related financial transactions. This solution consists of over 800 Oracle
Data Integrator packages and 3,900 interfaces with data available for reporting
by 6 am daily. The operational data
store leverages 16 sources to a single Oracle system processing transportation
orders and related financial transactions. This solution consists of over 1,000 Oracle Data Integrator packages and
3,400 interfaces with latency being under 30 minutes. The integration hubs gather data related to
drivers and shipments which are subsequently propagated to other systems via SOA
BPEL. Latency for these integration hubs
is under 1 minute. Overall, there are
225,000,000 DML operations via Oracle Data Integrator against the operational
data store and data warehouse on a daily basis. Benefits in cost, performance, scalability, productivity, and time have
already been proven, with more to come! Schneider
continues to work through this multi- year program, and looks forward to
completing the business and IT transformation in 2013.

For additional information, please check out a customer case study about Schneider National, Inc.