Load Data from Oracle Transportation Management Cloud Service into Oracle Fusion Data Intelligence (Preview)

As a service administrator, you can use the Oracle Fusion Data Intelligence extract service to acquire data from an Oracle Transportation Management Cloud Service SaaS instance.

1. Create a confidential application in Oracle Identity Cloud Service. See IDCS Configuration.
2. In Oracle Transportation Management Cloud Service, create a user and assign the "Integration" role using these instructions:
   1. Navigate to the User Manager with DBA.Admin privileges and click New in User Finder.
   2. In User Name, enter a name of your choice.
   3. Enter the client ID from the Oracle Identity Cloud Service confidential application in Nickname.
   4. In Domain Name, enter the name of the target domain.
   5. Enter a compliant Password and the password confirmation.
   6. In User Role ID, select INTEGRATION.
   7. In Access Control List add the list named Data Replication Service - Rest with the Granted option selected.
   8. Select Finished.
3. Obtain the OAuth 2 client credentials from your Oracle Transportation Management Cloud Service instance to provide while creating the data connection. See OAuth 2.
4. In Fusion Data Intelligence, enable Oracle Transportation Management on the Enable Features page. See Make Preview Features Available.
5. In Fusion Data Intelligence, create the Oracle Transportation Management Cloud Service data connection:
   1. In Fusion Data Intelligence Console, click Data Configuration under Application Administration.
   2. On the Data Configuration page, click Manage Connections.
   3. On the Manage Connections page, click Create and then click Connection.
   4. In Create Connection, select Data Extraction in Usage Type and then select Oracle Transportation Management as the connection type.
      
      

      

      
      
   5. In the dialog for the Oracle Transportation Management Cloud Service connection, enter these details and then click Save:
      • Connectivity Type: Standard.
      • Notification Email: An email address to receive notifications.
      • Scope: The scope name defined in your Oracle Transportation Management Cloud Service's Oracle Identity Cloud Service application’s configuration.
      • Token URL: The URL from which to obtain the access token. See Runtime Configuration.
      • URL: Source application URL (hostname and protocol of the Oracle Transportation Management Cloud Service instance).
      • Client ID: The unique client identifier generated during OAuth registration process.
      • Client Secret: The client secret generated during the OAuth registration process (a private key similar to a password that is generated when registering your Oracle Transportation Management Cloud Service's Oracle Identity Cloud Service application).
      • Verify that the Refresh Metadata toggle is enabled to ensure that the metadata is refreshed when you save the connection. You can later refresh the metadata from the Actions menu on the Manage Connections page, if required.
        Note
        
        You can’t create augmentations for Oracle Transportation Management Cloud Service unless you perform a metadata extract.

      
      

      

      
      
6. On the Manage Connections page, select Actions for the Oracle Transportation Management Cloud Service connection and then select Test Connection.
7. To delete a connection, on the Manage Connections page, click Actions for the applicable connection and select Delete.
   Note
   
   Ensure that you delete the functional areas, data augmentations, and custom data configurations related to the data connection before deleting it. You can't update or load data from deleted data connections to the warehouse.
8. After the connections are successfully established, navigate to the Data Configuration page, select the connection in Data Source, then click the Data Augmentation tile, and create a data augmentation using the Oracle Transportation Management Cloud Service data. Select the applicable Oracle Transportation Management Cloud Service source tables. See Augment Your Data.