Automatic migration for on-premise data objects to on-demand data objects

• US 9,892,207 B2
• Filed: 02/01/2013
• Issued: 02/13/2018
• Est. Priority Date: 02/01/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Schmidt, Olaf, Fischer, Martin P.
• Primary Examiner(s): Featherstone, Mark D
• Assistant Examiner(s): MCQUITERY, DIEDRA M
• Application Number:
  US13/757,158
• Publication Number:
  US 20140222756A1
• Time in Patent Office: 1,838 Days
• Field of Search: 707827, 707649, 707634, 707679, 707692, 707E1701, 707694, 707698, 707722, 707822, 707823, 707E17005, 707E17014, 707E17032, 707E17044, 707609, 707610, 707624, 707635, 707639, 707640, 707644, 707645, 707646, 707652, 707654, 707661, 707667, 707673, 707687, 707693, 707736, 707737, 707741, 707747, 707756, 707797, 707821, 709203, 709219, 709213, 709217, 709223, 709226, 709206, 709212, 709220, 709221, 709224, 709230, 711162, 711170, 711154, 711E12001, 711E12008, 711E12017, 711E12069, 711E12084, 711E12092, 711103, 711114, 711118, 711158, 711163, 711166, 700275, 700 11, 700 17, 700 2, 700232, 715255, 715207, 715853, 718 1, 705 144, 705 1461, 705 1464, 705 1466, 717110, 717121, 717170, 717172, 717173, 717176
• 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 to on-demand data objects, the method being executed using one or more processors and comprising:

identifying a first mapping between an on-premise database and the on-premise data objects according to a first schema associated with the on-premise database, the on-premise database and the on-premise data objects used by an on-premise application that is executed within an on-premise computing environment;

based on the first mapping, extracting, by the one or more processors, data corresponding to a subset of the on-premise data objects that are affected during execution of the on-premise application, the data being stored in the on-premise database;

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

in response to and subsequent to identifying the first mapping, identifying, by the one or more processors, a second mapping between the subset of the on-premise data objects and the on-demand data objects;

generating, by the one or more processors, an import file based on i) the export file and ii) the second mapping; and

providing the import file to an on-demand computing environment that hosts an on-demand application, the import file being processable by the on-demand computing environment to write the data from the import file into an on-demand database, the on-demand database and the on-demand data objects used by the on-demand application that is executed within the on-demand computing environment, the on-demand data objects being affected during execution of the on-demand application,

wherein the on-premise data objects are associated with an on-premise process executed by the on-premise application, the on-demand data objects are associated with an on-demand process executed by the on-demand application, and the on-demand process and the on-premise process provide a substantially same process result.

2. 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 second mapping.

3. The method of claim 1, wherein the second mapping is a mapping between fields of the subset of the on-premise data objects to fields of corresponding on-demand data objects.

4. The method of claim 1, wherein the first mapping maps fields of the on-premise database to fields of the on-premise data objects according to the first schema associated with the on-premise database.

5. The method of claim 1, farther comprising:

identifying, by the one or more processors, a third mapping between the on-demand data objects and the on-demand database according to a second schema associated with the on-demand database; and

based on the third mapping, storing the data of the export file to the on-demand database.

6. 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.

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

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

9. 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.

10. The method of claim 1, wherein the on-premise computing environment is under control by an enterprise customer and physically accessible by the enterprise customer, and wherein the on-demand computing environment is independent of control by the enterprise customer and physically inaccessible by the enterprise customer.

11. The method of claim 1, wherein the on-demand application interacting with the on-demand data objects is same as the on-premise application interacting with the on-premise data objects.

12. The method of claim 1, wherein extracting data corresponding to a subset of the on-premise data objects comprises:

during the extraction, locking data that is associated with the on-premise data objects and stored in the on-premise database.

13. A non-transitory 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 to on-demand data objects, the operations comprising:

identifying a first mapping between an on-premise database and the on-premise data objects according to a first schema associated with the on-premise database, the on-premise database and the on-premise data objects used by an on-premise application that is executed within an on-premise computing environment;

based on the first mapping, extracting, by the one or more processors, data corresponding to a subset of the on-premise data objects that are affected during execution of the on-premise application, the data being stored in the on-premise database;

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

in response to and subsequent to identifying the first mapping, identifying, by the one or more processors, a second mapping between the subset of the on-premise data objects and the on-demand data objects;

generating, by the one or more processors, an import file based on i) the export file and ii) the second mapping; and

providing the import file to an on-demand computing environment that hosts an 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, the on-demand database and the on-demand data objects used by the on-demand application that is executed within the on-demand computing environment, the on-demand data objects being affected during execution of the on-demand application,

wherein the on-premise data objects are associated with an on-premise process executed by the on-premise application, the on-demand data objects are associated with an on-demand process executed by the on-demand application, and the on-demand process and the on-premise process provide a same process result.

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

parsing the data provided in the export file; and

mapping the data based on the second mapping.

15. The computer-readable medium of claim 13, wherein the second mapping is a mapping between fields of the subset of the on-premise data objects to fields of corresponding on-demand data objects.

16. The computer-readable medium of claim 13, wherein the first mapping maps fields of the on-premise database to fields of the on-premise data objects according to the first schema associated with the on-premise database.

17. A system, comprising:

one or more processors; and

a non-transitory 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 to on-demand data objects, the operations comprising;

identifying a first mapping between an on-premise database and the on-premise data objects according to a first schema associated with the on-premise database, the on-premise database and the on-premise data objects used by an on-premise application that is executed within an on-premise computing environment;

based on the first mapping, extracting, by the one or more processors, data corresponding to a subset of the on-premise data objects that are affected during execution of the on-premise application, the data being stored in the on-premise database;

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

in response to and subsequent to identifying the first mapping, identifying, by the one or more processors, a second mapping between the subset of the on-premise data objects and the on-demand data objects;

generating, by the one or more processors, an import file based on i) the export file and ii) the second mapping; and

providing the import file to an on-demand computing environment that hosts an 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, the on-demand database and the on-demand data objects used by the on-demand application that is executed within the on-demand computing environment, the on-demand data objects being affected during execution of the on-demand application,

wherein the on-premise data objects are associated with an on-premise process executed by the on-premise application, the on-demand data objects are associated with an on-demand process executed by the on-demand application, and the on-demand process and the on-premise process provide a same process result.

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

parsing the data provided in the export file; and

mapping the data based on the second mapping.

19. The system of claim 17, wherein the second mapping is a mapping between fields of the subset of the on-premise data objects to fields of corresponding on-demand data objects.

20. The system of claim 17, wherein the first mapping maps fields of the on-premise database to fields of the on-premise data objects according to the first schema associated with the on-premise database.