Systems and methods for migrating data

• US 20070299975A1
• Filed: 05/16/2007
• Published: 12/27/2007
• Est. Priority Date: 05/16/2006
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Daschakowsky, Klaus, Frauenfeld, Dirk, Schlieper, Peter
• Application Number:
  US11/798,727
• Publication Number:
  US 20070299975A1
• Time in Patent Office: Days
• US Class Current: 709/228
• CPC Class Codes: G06F 16/214 Database migration support

Abstract

The present invention provides systems and methods for migrating data from at least one data source to at least one data target according to one or more migration objects or migration rules. The migration rules, for example, may control how the data migration is done. For instance, the migration rules may describe how the source data may be modified during the migration process to meet the requirements of the target system. In exemplary embodiments, a neutral interface is provided which comprises a mapping of external data fields to business objects located on the target system.

Claims

1. A system for migrating a business object from a source to a target, the system comprising:

a migration object associated with the business object, where the migration object is used to control the conversion of source data at the source to target data at the target, wherein the source data reflects the business object; and

a migration program to migrate the source data to the target according to the migration object.

2. The system of claim 1, wherein the migration object comprises:

data identifying the associated business object;

a definition of the source data which describes the business object;

a definition of the target data which describes the business object; and

at least one migration rule which specifies migration of the source data describing the business object into the target data describing the business object.

3. The system of claim 2, wherein migrating the source data includes applying the migration rule to the source data.

4. The system of claim 2, wherein the source data definition is stored in one of a flat file, a structured file, an XML scheme, a data repository and an XML data file.

5. The system of claim 2, wherein a migration rule includes at least one of:

a mapping of source data fields to target data fields, or

a conversion of source data values to target data values.

6. The system of claim 1, further comprising a controller program which triggers and controls the migration program.

7. The system of claim 1, further comprising a program generator adapted to generate the migration program.

8. The system of claim 1, wherein the migration programs comprise executable binary programs and interpretable program code.

9. The system of claim 1, wherein the target is one of a database, a flat file, a structured file, an XML data file, a data container, a message, a service, and a software application.

10. The system of claim 1, further comprising:

means for flagging migrated data stored at the target; and

means for removing the flagged data from the target.

11. A method for migrating a business object from a source to a target, the method comprising:

selecting, based on the business object to be migrated, a migration object used to control a conversion of source data at the source to target data at the target, wherein the source data reflects the business object; and

generating, based on the selected migration object, a program which migrates the source data to the target according to the migration object.

12. The method of claim 11, wherein the migration object comprises:

data identifying the associated business object;

a definition of the source data which describes the business object;

a definition of the target data which describes the business object; and

at least one migration rule which specifies migration of the source data describing the business object into the target data describing the business object.

13. The method of claim 12, wherein migrating the source data includes applying the migration rule to the source data.

14. The method of claim 12, wherein a migration rule includes at least on of:

a mapping of source data fields to target data fields, or

a conversion of source data values to target data values.

15. The method of claim 12, wherein the source data definition is stored in one of a flat file, a structured file, an XML scheme, a data repository and an XML data file.

16. The method of claim 11, wherein the target is one of a database, a flat file, a structured file, an XML data file, a data container, a message, a service, and a software application.

17. The method of claim 11, further comprising:

flagging migrated data stored at the target; and

removing the flagged data from the target.

18. A set of migration objects for use with a data migration system may migrate a business object from a source to a target, each migration object comprising:

data which identifies the business object;

a definition of the source data describing the business object;

a definition of the target data describing the business object; and

at least one migration rule which specifies the migration of the source data into the target data.

19. The migration objects of claim 18, wherein the at least one migration rule modifies the source data during the migration.

20. The migration objects of claim 18, wherein the at least one migration rule defines a transformation from the source data to the target data based on the source data definition and the target data definition.