1. Cloud
  2. Guides
  3. Tours
  4. Concepts
  5. Tools
  6. References
    1. Built-in Functions
    2. Incorta Component SDK
    3. Incorta Connector SDK
    4. Connectors
      1. AlloyDB
      2. Amazon Web Services (AWS) Athena
      3. Amazon Web Services (AWS) DynamoDB
      4. Amazon Web Services (AWS) RedShift
      5. Amazon Web Services (AWS) S3
      6. Apache Drill
      7. Apache Hadoop HDFS
      8. Apache Hive
      9. Apache Kafka
      10. Autoline
      11. Box
      12. Cassandra (Simba)
      13. Cassandra (Incorta)
      14. Cisco Meraki
      15. Cosmos DB
      16. Custom CData
      17. Custom SQL
      18. Dropbox
      19. File System (LocalFiles)
      20. Freshservice
      21. FTP
      22. Google BigQuery
      23. Google Cloud Storage (GCS)
      24. Google Drive
      25. Google Sheets
      26. GraphQL
      27. IBM DB2
      28. IBM Netezza
      29. JIRA
      30. JSON
      31. Kyuubi
      32. Local Files
      33. MariaDB
      34. Microsoft Azure Gen2
      35. Microsoft OneDrive
      36. Microsoft SharePoint
      37. Microsoft SQL Server
      38. Microsoft SQL Server (JTDS)
      39. MongoDB BI
      40. MySQL
      41. NetSuite - Saved Searches
      42. NetSuite - SuiteAnalytics
      43. NetSuite - SuiteQL
      44. NetSuite - Web Service
      45. OneLogin
      46. Oracle
      47. Oracle B2C Service
      48. Oracle Cloud Applications
      49. Oracle Cloud Applications V2
      50. Oracle CPQ
      51. Oracle EPM
      52. Oracle Essbase
      53. Oracle OTM/GTM
      54. Oracle Sales Cloud
      55. Oracle WMS
      56. PostgreSQL
      57. Presto
      58. Salesforce v2
      59. SAP ERP
      60. SAP Hana
      61. SAP Sybase IQ
      62. ServiceNow
      63. SFTP
      64. Smartsheet
      65. Snowflake
      66. Splunk
      67. Teradata
      68. Vertica
      69. XML
      70. Zuora
    5. Public API
    6. Security
    7. Visualizations
    8. SQL Interface
    9. Other
  7. Integrations
  8. Data applications
  9. Releases

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 + 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:

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 + 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:

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 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.