1. Content Management System Integration Guide
  2. Defining CMS Connections for Storage

Defining CMS Connections for Storage

A CMS connection in Oracle Transportation and Global Trade Management Cloud is defined with a Content Management System record. This can be accessed via the main menu from Business Process Automation > Power Data > Document Generation > Content Management Systems.

Connection details required by different CMS that are supported are as follows:

  • WebCenter Content
    • URL: The URL needed to communicate with the CMS over a specified protocol.
    • User: The CMS user name used to authenticate the connection.
    • Password: The CMS credentials used to authenticate the connection.
  • SharePoint Online
    • Details for connecting to SharePoint Online are specified using an External System.

Architectures requiring more complex credentialing, e.g. those involving certificate authentication, are not supported.

WebCenter Content

For WebCenter Content, Oracle Transportation and Global Trade Management Cloud supports only the IDC protocol. This requires the application server be a trusted client from the standpoint of the document server. The connection URL should be of the form:

https://<WCC host>:<WCC SSL Port></cs/idcplg

The certificates required for Oracle Transportation and Global Trade Management Cloud to trust the URL should be loaded to the Java trust store. Check the guides to know the procedure to load the certificates to the trust store. Check the Outbound Integration and SSL Certificates section of the Cloud Administration Guide for more details.

Note: The user and password are ignored for the initial connection but allow for document-based security on subsequent document requests.

SharePoint Online

For SharePoint Online, define the setup as specified below:

Setting Up an External System in Oracle Transportation and Global Trade Management Cloud

Configure an external system in Oracle Transportation and Global Trade Management Cloud that will enable you to authenticate/interact with SharePoint. The external system fields should be set as follows:

  • Authentication Type: OAuth 2.0 - Client Credentials
  • Authorization Service Authentication Type: Microsoft Graph API
  • Client ID: Provide the Application (client) ID value generated after registering the application
  • Client Secret: Provide the Secret Value generated after registering the application
  • Authorization Service URL: https://login.microsoftonline.com/{Directory or tenant ID}/oauth2/v2.0/token (replace {Directory or tenant ID} with the actual value)
  • Application Scope: https://graph.microsoft.com/.default
  • URL: https://graph.microsoft.com/v1.0/drives (acts as a base URL for all API requests)

Setting Up a Content Management System In Oracle Transportation and Global Trade Management Cloud

Configure a Content Management System (CMS) in Oracle Transportation and Global Trade Management for SharePoint. The CMS fields should be set as follows:

  • System Type: SharePoint Online
  • External System: Select the External System created in the above section
  • Drive ID: This represents the location where the documents will be stored. The drive ID to be used can be obtained by means of an API call. Microsoft Graph provides certain ways to obtain the drive ID. Refer to Microsoft documentation for Microsoft Graph APIs (Microsoft Graph > v1.0 reference > Files > Drives > Get drive) to check for the various ways to obtain the drive ID. Refer to the application help for a sample request on how to obtain Drive ID.