Transportation Intelligence

1. TI Reference Guide: Introduction

This TI Reference Guide describes in detail the technical details of the various components that make the Oracle Transportation Intelligence solution. While the components of the Oracle Transportation Intelligence solution are developed using Oracle Analytics Server (OAS) and Oracle Data Integrator products, the scope of this document is to describe only the technical definition of the relevant Oracle Transportation Intelligence components and not to describe how to develop components using OAS and Oracle Data Integrator.

The intent of this document is to provide an Oracle Transportation Intelligence reference guide to users who would like to understand the deeper technical aspects of the Oracle Transportation Intelligence components and perhaps develop their own customer-defined extensions to the Oracle Transportation Intelligence components.

It is expected that target users of this document have a moderate to fair understanding of data warehousing concepts, Oracle Transportation Management, OAS and Oracle Data Integrator. However for deeper understanding of these products refer their corresponding documentation.

About this Document

The document contains the following sections:

Definitions, Acronyms and Abbreviations

Term

Definition

OTM

Oracle Transportation Management

OAS

Oracle Analytics Server. The Oracle analytics suite with which the Oracle Transportation Intelligence components are developed and deployed at run-time.

ODI

Oracle Data Integrator. The Extract, Transform, and Load (ETL) tool with which the Oracle Transportation Intelligence ETL component is developed and deployed at run-time.

 

Architecture Overview

Transportation Intelligence (TI) is a business intelligence solution developed primarily for the Oracle Transportation Management application to strategically and tactically analyze the various aspects of the transportation processes and to aid business decision making.

The Oracle TI solution is developed primarily using the OAS (for the core analytics metadata and dashboard reports) and Oracle Data Integrator (for the core Extract, Load, Transform process) products.

The solution architecture of Oracle TI comprising the various tiers is best described in the picture below.

External APIs, engines, and user input pass through the single sign on to the web server. The OTM server interacts with the BI server. The production schema goes through the Oracle Data Integrator to the BI schema. Production schema data can be purged and sent to the archive schema. The BI server can send to the BI schema and the archive schema.

 

Related Topics