Migrating Your Oracle Transportation Management to the Cloud with KSAP

Welcome to KSAP, your trusted partner for Oracle Transportation Management (OTM) Cloud migrations. We understand that many OTM customers running on-premise are looking to harness the benefits of the cloud. In this guide, we'll outline our comprehensive approach, best practices, and the key considerations for a successful
migration to OTM Cloud.

Cloud Migration Approach

Best Practices – Process

Project Management
  • Team Coordination: Collaboration between the Client, Partner, and Oracle teams is critical for success.
  • Limit Scope Creep: Clearly define project scope to avoid unnecessary changes.
Change Management
  • Embrace New Features: Be prepared for new features in OTM Cloud and adapt your business processes accordingly.
  • User Training: Training your team on the cloud adoption is essential for a smooth transition.
  • Upgrade Testing: Thoroughly test user experience with well-scripted UX test scripts by role.
  • Downtime Management: Plan for downtime, and coordinate with internal and external teams and applications.
  • Robust Promotion Process: Create a migration checklist and categorize objects by migration type.
  • User Management: Evaluate user management, especially with Oracle SSO.

Best Practices – Customization

  • Local DB Replication: Consider replicating and synchronizing data between local databases and the cloud.
  • Local DB UOM Preferences: Set up user preferences by sub-domain and role as REST API may not support all user preferences.
  • Data Validation: Reduce excessive data validations to avoid performance degradation.
  • Log Management: Enable relevant logs and minimize clutter.
  • Dev & Test Environment: Simulate the development and test environment in a non-production environment.
  • REST API Collaboration: Work closely with Oracle Support & DEV Teams as REST APIs evolve.

Cloud Readiness Assessment

Before migrating to OTM Cloud, a thorough readiness assessment is essential:

  • Confirm your current OTM on-premise implementation's readiness for the cloud.
  • Analyze customizations and identify custom requirements that can be satisfied outside of OTM.
  • Identify and analyze customizations and recommend standardization or re-implementation.
  • Develop a report summarizing and detailing recommendations for the path to the Cloud.

Migration Roadmap and Approach Strategy

Developing a migration roadmap is crucial and involves inputs based on KDDs, KSDs, and KBDs.

Data Migration

Configuration and Data Migration

  • Migrate data elements including configurations, master data, and transactional data.
  • Transform configurations to be cloud-compatible.
  • Apply data retention and migration policies for historical and current data.

KSAP OTMNow Migrate

  • Monitor migration progress with a dashboard.
  • Control migration period, duration, and sequence.
  • Incrementally migrate historic data ahead of go-live.
  • In-flight data is migrated only at go-live.

Integration Migration

  • Update integration mappings to meet cloud-compatible standards.
  • Replace deprecated integration methods with HTTPS/Webservices or REST APIs.
  • Configure external systems with Fully Qualified Domain Names (FQDNs) and route integration traffic through a proxy server.

BI Reports Migration

  • Convert embedded BI reports to standalone BI Publisher reports.
  • Redefine report parameters to use bind parameters.
  • Assess report complexity to plan migration accordingly.

Transportation Intelligence (FTI) Migration

  • Evaluate FTI customizations.
  • Migrate FTI reports based on complexity.
  • Transition away from ETL customizations and direct database access.

Customization Migration

Our approach to customization migration involves several stages:

  • Stage 1: Remove customization from the migration plan and adjust business processes.
  • Stage 2: Convert to standard OTM functionality.
  • Stage 3: Create OTM agents.
  • Stage 4: Utilize Cloud-Compatible KSAP OTMNow Add-Ons.
  • Stage 5: Retrofit customization in Cloud OTM.

Customization Evaluation

Evaluate customizations based on complexity, whether low, medium, or high.

Data Replication Approach

For ongoing data replication, consider options like Oracle GoldenGate, DIPC Platform, XML Push, and KSAP OTMNow Replicate Add-On.

OTMNow Migrate Demo

Explore our OTMNow Migrate tool, designed to simplify data migration between OTM instances.

  • Visibility into the migration progress.
  • Criteria-based copy capability.
  • Validation layer for data integrity.
  • Supports both on-premise to cloud and on-premise to on-premise migrations.

Quarterly Release Certification

Stay up to date with Oracle's quarterly release schedule and our approach to quarterly upgrades.

Why KSAP for Your OTM Cloud Journey

Choose KSAP for your OTM Cloud migration because:

  • We have a proven track record of successful cloud migrations.
  • We specialize in complex migrations with high degrees of customizations.
  • We value long-lasting customer relationships and provide trusted advisory services.
  • We offer a dedicated platform, OTMNow, to manage data migration to the cloud.

Learn more about the services KSAP can offer.