Connectors → Oracle Transportation and Global Trade Management

About Oracle OTM/GTM

Oracle Transportation and Global Trade Management (OTM/GTM) systems manage all transportation activity throughout your global supply chain and trading. It combines ease of use with industry-leading capabilities.

About the Oracle OTM/GTM Connector

With the Oracle OTM/GTM connector, you can get data from Oracle OTM/GTM inside Incorta. You can create dashboards and insights based on this data to help your organization make good decisions.

This connector fetches data from your Oracle OTM/GTM system using a set of REST APIs.

Note

This connector only supports Oracle OTM/GTM version 23A and is available for preview only.

The Oracle OTM/GTM connector supports the following Incorta-specific functionality:

FeatureSupported
Chunking
Data Agent
Encryption at Ingest
Incremental Load
Multi-Source
OAuth
Performance Optimized
Remote
Single-Source
Spark Extraction
Webhook Callbacks

Steps to connect Oracle OTM/GTM and Incorta

To connect Oracle OTM/GTM and Incorta, here are the high-level steps, tools, and procedures:

Create an external data source

Here are the steps to create an external data source with the Oracle OTM/GTM connector:

  • Sign in to the Incorta Direct Data Platform™.
  • In the Navigation bar, select Data.
  • In the Action bar, select + NewAdd Data Source.
  • In the Choose a Data Source dialog, in Database, select Oracle OTM/GTM.
  • In the New Data Source dialog, specify the applicable connector properties.
  • To test, select Test Connection.
  • Select Ok to save your changes.

Oracle OTM/GTM connector properties

Here are the properties for the Oracle OTM/GTM connector:

PropertyControlDescription
Name Your Data Sourcetext boxEnter a name for your data source.
Domaintext boxEnter the URL for your Oracle OTM/GTM System in the following format:
https://<servicename>-<identity-domain-name>.otm.<data-center>.oraclecloud.com/
Usernametext boxEnter your username.
Passwordtext boxEnter your password.
Max concurrent callstext boxEnter the maximum number of concurrent calls that Incorta sends to Oracle OTM/GTM. The default is 5 calls.
Timeout in secondstext boxEnter the time in seconds to wait for a response from Oracle OTM/GTM. The default is 600 seconds.
Metadata cache time (hours)text boxThe time to cache the JSON response for table and column discovery. Set to 0 for no caching.

Create a schema with the Schema Wizard

Here are the steps to create an Oracle OTM/GTM schema with the Schema Wizard:

  • Sign in to the Incorta Direct Data Platform.
  • In the Navigation bar, select Schema.
  • In the Schema Manager, in the Action bar, select + NewSchema Wizard.
  • In (1) Choose a Source, specify the following:
    • For Enter a name, enter the schema name.
    • For Select a Datasource, select the Oracle OTM/GTM source.
    • Optionally create a description.
  • In the Schema Wizard footer, select Next.
  • In (2) Manage Tables, in the Data Panel, first, select the name of the Data Source, and then check the Select All checkbox.
  • In the Schema Wizard footer, select Next.
  • In (3) Finalize, in the Schema Wizard footer, select Create Schema.

Oracle OTM/GTM data source properties

For a schema table in Incorta, you can define the following Oracle OTM/GTM-specific data source properties as follows:

PropertyControlDescription
Typedrop-down listThe default is Oracle OTM/GTM
Data Sourcedrop-down listSelect the Oracle OTM/GTM data source
CallbacktoggleEnable this property to expose the Callback URL field
Callback URLtext boxThis property appears when the Callback toggle is enabled. Specify the URL.

View the schema diagram with the Schema Diagram Viewer

Here are the steps to view the schema diagram using the Schema Diagram Viewer:

  • Sign in to the Incorta Direct Data Platform.
  • In the Navigation bar, select Schema.
  • In the list of schemas, select the Oracle OTM/GTM schema.
  • In the Schema Designer, in the Action bar, select Diagram.

Load the schema

Here are the steps to perform a Full Load of the Oracle OTM/GTM schema using the Schema Designer:

  • Sign in to the Incorta Direct Data Platform.
  • In the Navigation bar, select Schema.
  • In the list of schemas, select the Oracle OTM/GTM schema.
  • In the Schema Designer, in the Action bar, select LoadFull Load.
  • To review the load status, in Last Load Status, select the date.

Explore the schema

With the full load of the Oracle OTM/GTM schema complete, you can use the Analyzer to explore the schema, create your first insight, and save the insight to a new dashboard.

To open the Analyzer from the schema, follow these steps:

  • In the Navigation bar, select Schema.
  • In the Schema Manager, in the List view, select the Oracle OTM/GTM schema.
  • In the Schema Designer, in the Action bar, select Explore Data.