My Oracle Support Banner

GoldenGate Deployment for Oracle Transportation and Global Trade Management Cloud (OTM) (Doc ID 2497511.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Cooperative Routing Cloud Service
Oracle Transportation Operational Planning Cloud Service
Oracle Transportation Intelligence Cloud Service
Oracle Transportation Management Cloud Service
Oracle Transportation Sourcing Cloud Service
Information in this document applies to any platform.

Purpose

OTM SaaS Cloud provides various methods to extract data from external sources: XML, CSV, REST and DB.XML. If you are performing external reporting or business intelligence and need to populate an external database for SQL access, you can purchase the Oracle OCI GoldenGate Marketplace license and request via  SR to have that connected to the Transportation and Global Trade Management Cloud. This solution replicates the key data from the Transportation and Global Trade Management Cloud database to an external database, either in the Oracle Cloud or on premise. This replication is for reporting purposes only and should not be used for integration or custom applications.

Use this document to prepare your environment to receive data from a Transportation and Global Trade Management Cloud database through a GoldenGate interface after you log an SR.

 

Scope

       Your Data Integrator should work with your DBA and Network Managers. 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 OTM/OGG on OCI Marketplace - High Level Architectural Diagram
 Requirements for Target
 Preparing the Target Environment
 Prepare Target Environment
 Whitelisting
 Replication Environment
 What You Need from Oracle before Deploying the Target Environment
 Install Golden Gate Microservices
 Create an Empty Shell Database
 Prepare the Target Database
 Configure the Target Database within GoldenGate
 Reserve Public IP for Receiver Server
 Backup Requirement
 Instantiation
 What You Need from Oracle before Beginning Instantiation
 Execute Datapump Import
 Create a Primary Replicat
 Goldengate P2T / re-initiation High level steps for the targets
 Further Reference
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.