My Oracle Support Banner

Extracting Data from Analytics (OTM/GTM Cloud) using Data Sync Tool (Doc ID 2386753.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Transportation Intelligence Cloud Service - Version 6.4.2 and later
Oracle Forwarding and Brokerage Operations Cloud Service - Version 6.4.2 and later
Oracle Transportation Sourcing Cloud Service - Version 6.4.2 and later
Oracle Logistics Inventory Visibility Cloud Service - Version 6.4.2 and later
Oracle Global Trade Management Cloud Service - Version 6.4.2 and later
Information in this document applies to any platform.

Purpose

 Data can be extracted from OBIEE using the web service URL (of OBIEE) via the Data Sync Tool to load into target tables.

Scope

 For Oracle Transportation Management and Global Trade Management Cloud 6.4.2 and later.

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
 Downloading and Creating Connection
 Setting the OTM Password
 Creating Pluggable Data Sources
 Types of pluggable sources:
 Extract from Report:
 Example of Extract from Report:
 Extract from SQL query in Advance tab of Analysis:
 Example of Extract from SQL query in Advance tab of Analysis:
 Creating a Job to Run:
 Validation:
 Contacts
 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.