Global Trade Intelligence

1. GTI Reference Guide Introduction

This GTI Reference Guide describes in detail the technical details of the various components that make the Oracle Global Trade Intelligence solution. While the components of the Oracle Global Trade 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 Global Trade 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 Global Trade Intelligence reference guide to users who would like to understand the deeper technical aspects of the Oracle Global Trade Intelligence components and perhaps develop their customer-defined extensions to the Oracle Global Trade Intelligence components.

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

About this Document

The document contains the following sections:

  1. Chapter 1 Introduction
  2. Chapter 2 ETL Server explains ETL data loading
  3. Chapter 3 Oracle Analytics Server documents the out-of-the-box dashboards, prompts, and reports.

Definitions, Acronyms, and Abbreviations

Term

Definition

OTM

Oracle Transportation Management

GTM

Global Trade 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 Fusion Transportation Intelligence ETL component is developed and deployed at run-time.

 

Architecture Overview

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

The Global Trade Intelligence 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 Global Trade Intelligence 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