Automated Data Migration Planning for Legacy ERP Systems

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The difficulty in transitioning between software applications, particularly Enterprise Resource Planning (ERP) systems, due to the large effort, cost, and exposure involved in data migration, discourages organizations from upgrading, leading to reluctance in adopting new applications.

Innovation Solution

A data migration planning method that proposes a plan to move or copy data from legacy systems to new applications, utilizing application plugins and existing data migration tools, while allowing legacy data to remain stored, and providing a user-friendly interface to minimize skill requirements, thus reducing the complexity and risk of application transitions.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual data migration is performed from legacy systems to new applications, then data can be moved between systems, but the effort, time, and cost required become prohibitively large

Engineering Contradiction:
Improvedata migration successVSAvoidmigration time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The patent introduces an automated data migration system that acts as an intermediary between legacy systems and new applications. This system automatically discovers data sources, maps data elements, and executes migration processes without requiring manual intervention, thereby dramatically reducing migration time while maintaining reliability through systematic automated procedures

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary actions by automatically discovering and analyzing data sources before the actual migration begins. It pre-maps data elements, identifies relationships, and prepares migration strategies in advance, which streamlines the subsequent migration process and reduces the time required for the actual data transfer

Inventive Principle:
Principle #10Preliminary action

2Reliability

If manual data migration is performed from legacy systems to new applications, then data can be moved between systems, but the cost and human resources required become prohibitively large

Engineering Contradiction:
Improvedata migration successVSAvoidhuman resources
Core Design Contradiction:
ReliabilityVSQuantity of substance

Solution Approach 1:

The data migration system is designed to be self-service capable, automatically performing discovery, mapping, and migration execution without requiring extensive human resources. The system autonomously identifies data sources, determines migration strategies, and executes the migration process, thereby eliminating the need for large teams of manual workers while ensuring reliable data transfer

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The automated migration system serves as an intermediary that replaces manual human effort with automated intelligent processes. It handles all aspects of data migration including discovery, mapping, and execution, thereby reducing human resource requirements while maintaining high reliability through systematic automated control

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If organizations transition to new applications, then they can access new functionality, but the complexity and exposure of the transition process discourage adoption

Engineering Contradiction:
Improveapplication functionalityVSAvoidmigration complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The automated data migration system acts as an intermediary that simplifies the complex transition process between legacy systems and new applications. It provides a unified interface that automatically handles discovery, mapping, and migration execution, thereby reducing the perceived complexity while enabling organizations to access new application functionality

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary analysis and planning actions automatically before migration begins, including discovering data sources, mapping data elements, and determining optimal migration strategies. This preliminary work simplifies the overall transition process by preparing everything in advance, thereby reducing the complexity experienced during the actual migration phase

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS7831568B2Data migration
Publication Date: 2010.11.09 SAP SE
  • US7831568B2 patent drawing
  • US7831568B2 patent drawing
  • US7831568B2 patent drawing

AI summary

The present subject matter relates to configuring computer systems and, more particularly, to data migration. Various embodiments of the present subject matter provide systems, methods, and software to receive and store customer information including information detailing customer data from legacy applications. Some embodiments further determine a plan to migrate the customer data from the legacy applications to a target application as a function of the received customer information and the target application.