AUTOMATIC MIGRATION FOR ON-PREMISE DATA OBJECTS TO ON-DEMAND DATA OBJECTS

• US 20140222756A1
• Filed: 02/01/2013
• Published: 08/07/2014
• Est. Priority Date: 02/01/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Schmidt, Olaf, Fischer, Martin P.
• Granted Patent: US 9,892,207 B2
• Time in Patent Office: Days
• US Class Current: 707/610
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

Methods, systems, apparatus, and computer programs encoded on computer storage medium for automatically migrating on-premise data objects used by an on-premise application to on-demand data objects used by an on-demand application including retrieving mapping rules corresponding to the on-premise data objects from a rule repository; extracting data corresponding to on-premise data objects that are affected during execution of the on-premise application, the on-premise application being executed within an on-premise computing environment, the data being stored in an on-premise database based on an on-premise database schema; generating an export file comprising the data; generating an import file based on the export file and the mapping rules, the import file comprising the data; and providing the import file to an on-demand computing environment that hosts the on-demand application, the import file being process-able by the on-demand computing environment to write the data from the import file into an on-demand database.

Claims

1. A computer-implemented method for automatically migrating on-premise data objects used by an on-premise application to on-demand data objects used by an on-demand application, the method being executed using one or more processors and comprising:

retrieving mapping rules corresponding to the on-premise data objects, the mapping rules being retrieved from a rule repository;

extracting, by the one or more processors, data corresponding to on-premise data objects that are affected during execution of the on-premise application, the on-premise application being executed within an on-premise computing environment, the data being stored in an on-premise database based on an on-premise database schema;

generating, by the one or more processors, an export file, the export file comprising the data;

generating, by the one or more processors, an import file based on the export file and the mapping rules, the import file comprising the data; and

providing the import file to an on-demand computing environment that hosts the on-demand application, the import file being process-able by the on-demand computing environment to write the data from the import file into an on-demand database.

2. The method of claim 1, wherein the mapping rules map fields of on-premise data objects to fields of on-demand data objects.

3. The method of claim 1, wherein generating the import file comprises:

parsing the data provided in the export file; and

mapping the data based on the mapping rules.

4. The method of claim 1, further comprising:

identifying, by the one or more processors, on-premise data object models corresponding to the on-premise data objects;

defining the mapping rules to map fields of the on-premise data object models to fields of corresponding on-demand data object models; and

storing the mapping rules in the rule repository.

5. The method of claim 1, wherein extracting data is achieved based on a schema mapping that maps fields of the on-premise database to fields of the on-premise objects based on the on-premise database schema.

6. The method of claim 1, wherein the data is written to the on-premise database based on a schema mapping that maps fields of the on-demand data objects to fields of the on-demand database based on an on-demand database schema.

7. The method of claim 1, wherein the on-premise application embodies a business process of an enterprise, the business process comprising one or more tasks, at least one task affecting an on-premise data object.

8. The method of claim 1, wherein the on-premise computing environment is operated and maintained by an enterprise.

9. The method of claim 1, wherein the on-demand computing environment is operated and maintained by a service provider.

10. The method of claim 1, wherein an on-premise data object is affected during execution of the on-premise application when data is one or more of stored to and read from the on-premise data object.

11. A computer-readable medium coupled to one or more processors having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for automatically migrating on-premise data objects used by an on-premise application to on-demand data objects used by an on-demand application, the operations comprising:

retrieving mapping rules corresponding to the on-premise data objects, the mapping rules being retrieved from a rule repository;

extracting, by the one or more processors, data corresponding to on-premise data objects that are affected during execution of the on-premise application, the on-premise application being executed within an on-premise computing environment, the data being stored in an on-premise database based on an on-premise database schema;

generating, by the one or more processors, an export file, the export file comprising the data;

generating, by the one or more processors, an import file based on the export file and the mapping rules, the import file comprising the data; and

providing the import file to an on-demand computing environment that hosts the on-demand application, the import file being process-able by the on-demand computing environment to write the data from the import file into an on-demand database.

12. The computer-readable medium of claim 11, wherein the mapping rules map fields of on-premise data objects to fields of on-demand data objects.

13. The computer-readable medium of claim 11, wherein the operation of generating the import file comprises:

parsing the data provided in the export file; and

mapping the data based on the mapping rules.

14. The computer-readable medium of claim 11, the operations further comprising:

identifying, by the one or more processors, on-premise data object models corresponding to the on-premise data objects;

defining the mapping rules to map fields of the on-premise data object models to fields of corresponding on-demand data object models; and

storing the mapping rules in the rule repository.

15. The computer-readable medium of claim 11, wherein extracting data is achieved based on a schema mapping that maps fields of the on-premise database to fields of the on-premise objects based on the on-premise database schema.

16. A system, comprising:

one or more processors; and

a computer-readable medium coupled to the one or more processors having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for automatically migrating on-premise data objects used by an on-premise application to on-demand data objects used by an on-demand application, the operations comprising;

retrieving mapping rules corresponding to the on-premise data objects, the mapping rules being retrieved from a rule repository;

extracting data corresponding to on-premise data objects that are affected during execution of the on-premise application, the on-premise application being executed within an on-premise computing environment, the data being stored in an on-premise database based on an on-premise database schema;

generating an export file, the export file comprising the data;

generating an import file based on the export file and the mapping rules, the import file comprising the data; and

providing the import file to an on-demand computing environment that hosts the on-demand application, the import file being process-able by the on-demand computing environment to write the data from the import file into an on-demand database.

17. The system of claim 16, wherein the mapping rules map fields of on-premise data objects to fields of on-demand data objects.

18. The system of claim 16, wherein the operation of generating the import file comprises:

parsing the data provided in the export file; and

mapping the data based on the mapping rules.

19. The system of claim 16, the operations further comprising:

identifying, by the one or more processors, on-premise data object models corresponding to the on-premise data objects;

defining the mapping rules to map fields of the on-premise data object models to fields of corresponding on-demand data object models; and

storing the mapping rules in the rule repository.

20. The system of claim 16, wherein extracting data is achieved based on a schema mapping that maps fields of the on-premise database to fields of the on-premise objects based on the on-premise database schema.