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.
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:
Feature | Supported |
---|---|
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
- Create a schema with the Schema Wizard
- or, Create a schema with the Schema Designer
- Load the schema
- Explore the schema
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 + New → Add 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:
Property | Control | Description |
---|---|---|
Name Your Data Source | text box | Enter a name for your data source. |
Domain | text box | Enter the URL for your Oracle OTM/GTM System in the following format: https://<servicename>-<identity-domain-name>.otm.<data-center>.oraclecloud.com/ |
Username | text box | Enter your username. |
Password | text box | Enter your password. |
Max concurrent calls | text box | Enter the maximum number of concurrent calls that Incorta sends to Oracle OTM/GTM. The default is 5 calls. |
Timeout in seconds | text box | Enter the time in seconds to wait for a response from Oracle OTM/GTM. The default is 600 seconds. |
Metadata cache time (hours) | text box | The 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 + New → Schema 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:
Property | Control | Description |
---|---|---|
Type | drop-down list | The default is Oracle OTM/GTM |
Data Source | drop-down list | Select the Oracle OTM/GTM data source |
Callback | toggle | Enable this property to expose the Callback URL field |
Callback URL | text box | This 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 Load → Full 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.