DATA MIGRATION USING COMMUNICATIONS AND COLLABORATION PLATFORM

• US 20120084254A1
• Filed: 01/31/2011
• Published: 04/05/2012
• Est. Priority Date: 10/05/2010
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services Limited (Accenture PLC)
• Inventors: Nebolsky, Charles, Richards, Brian Hale, Holzman, Michael, Hsu, Erin
• Granted Patent: US 8,380,661 B2
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 9/541 via adapters, e.g. between incompatible applications
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services

Abstract

Data migration using communications and collaboration platform provides an efficient and flexible method for migrating data from an existing system to a new system. In particular, the method includes extracting data, cleansing the extracted data based on a master record, receiving approval for the cleansed data, and migrating the approved data into the new system.

Claims

1. A migration method comprising:

executing with a processor a migration program stored in a memory, the migration program comprising logic that when executed causes the processor to;

receive a migration request to migrate source data from one or more source systems to one or more new systems;

extract the source data from the one or more source systems to obtain extracted source data;

access a master record stored in a database;

compare the extracted source data with the master record to obtain a comparison between the extracted source data and the master record;

determine if a change is to be made on the extracted source data based on the comparison;

if it is determined that a change is to be made, make the change on the extracted source data;

determine one or more target systems as the one or more new systems; and

migrate the source data to the one or more target systems.

2. The method of claim 1, wherein the one or more target systems comprise multiple target systems;

wherein the logic to determine the one or more target systems as the one or more new systems comprises;

determining the multiple target systems as the one or more new systems, wherein the extracted source data is to be migrated across the multiple target systems,

determining for each target system of the multiple target system a portion of the extracted source data to be migrated; and

wherein the logic to migrate the source data to the one or more target systems comprises repeatedly communicating with the multiple target systems until all of the extracted source data is migrated across the multiple target systems.

3. The method of claim 2, wherein the one or more source systems comprises multiple source systems.

4. The method of claim 1, wherein the one or more target systems comprise a single target system and the one or more source systems comprises multiple source systems.

5. The method of claim 1, wherein the migration program further comprises logic that when executed causes the processor to identify business rules corresponding to the migration request;

and

wherein the logic to determine if a change is to be made on the extracted source data based on the comparison comprises;

determining if a change is to made on the extracted source data based on the business rules and the comparison, and

determining the one or more target systems based on the business rules.

6. The method of claim 1, wherein the migration program further comprises logic that when executed causes the processor to identify business rules corresponding to the migration request;

and

wherein the logic to extract the source data from the one or more source systems to obtain an extracted source data comprises;

determining a first adaptor for extracting the source data from the one or more source systems based on the business rules, and

extracting the source data from the one or more source systems based on the determined first adaptor.

7. The method of claim 6, wherein the logic to migrate the source data to the one or more target systems comprises:

determining a second adaptor for migrating converted source data to the one or more target systems; and

migrating the converted source data to the one or more target systems based on the second adaptor.

8. The method of claim 1, wherein the migration program further comprises logic when executed causes the processor to:

after making changes on the extracted source data, receiving approval of the source data from a user.

9. The method of claim 1, wherein the migration program further comprises logic when executed causes the processor to:

receive an additional change instruction to make an additional change on the extracted source data; and

make the additional change on the extracted source data based on the additional change instruction.

10. The method of claim 1, wherein the one or more target systems comprises one or more of cloud-based systems.

11. The method of claim 10, wherein the one or more source systems comprises one or more of the cloud-based systems.

12. The method of claim 1, wherein the migration program further comprises logic when executed causes the processor to:

perform a predetermined test based on business rules to ensure that the extracted source data is migrated to the one or more target systems successfully.

13. A migration system comprising:

a processor; and

stored on a computer readable memory coupled to the processor;

a migration program comprising logic that when executed causes the processor to;

receive a migration request to migrate source data from one or more source systems to one or more new systems;

extract the source data from the one or more source systems to obtain extracted source data;

access a master record stored in a database;

compare the extracted source data with the master record to obtain a comparison between the extracted source data and the master record;

determine if a change is to be made on the extracted source data based on the comparison;

if it is determined that a change is to be made, make the change on the extracted source data;

determine one or more target systems as the one or more new systems; and

migrate the source data to the one or more target systems.

14. The system of claim 13, wherein the one or more target systems comprise multiple target systems;

wherein the logic to determine the one or more target systems as the one or more new systems comprises;

determining the multiple target systems as the one or more new systems, wherein the extracted source data is to be migrated across the multiple target systems,

determining for each target system of the multiple target system a portion of the extracted source data to be migrated; and

wherein the logic to migrate the source data to the one or more target systems comprises repeatedly communicating with the multiple target systems until all of the extracted source data is migrated across the multiple target systems.

15. The system of claim 13, wherein the one or more target systems comprise a single target system and the one or more source systems comprises multiple source systems.

16. The system of claim 13, wherein the migration program further comprises logic that when executed causes the processor to identify business rules corresponding to the migration request;

and

wherein the logic to determine if a change is to be made on the extracted source data based on the comparison comprises;

determining if a change is to made on the extracted source data based on the business rules and the comparison, and

determining the one or more target systems based on the business rules.

17. The system of claim 13, wherein the migration program further comprises logic that when executed causes the processor to identify business rules corresponding to the migration request;

and

wherein the logic to extract the source data from the one or more source systems to obtain an extracted source data comprises;

determining a first adaptor for extracting the source data from the one or more source systems based on the business rules, and

extracting the source data from the one or more source systems based on the determined first adaptor.

18. The system of claim 17, wherein the logic to migrate the source data to the one or more target systems comprises:

determining a second adaptor for migrating converted source data to the one or more target systems; and

migrating the converted source data to the one or more target systems based on the second adaptor.

19. The system of claim 13, wherein the migration program further comprises logic when executed causes the processor to:

receive an additional change instruction to make an additional change on the extracted source data; and

make the additional change on the extracted source data based on the additional change instruction.

20. The system of claim 13, wherein the migration program further comprises logic when executed causes the processor to:

perform a predetermined test based on business rules to ensure that the extracted source data is migrated to the one or more target systems successfully.