APPARATUS AND METHOD FOR UTILIZING A TASK GRID TO GENERATE A DATA MIGRATION TASK

• US 20080228550A1
• Filed: 03/14/2007
• Published: 09/18/2008
• Est. Priority Date: 03/14/2007
• Status: Abandoned Application

• Current Assignee: SAP America Incorporated (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: TAN, Aun-Khuan, PAKKIRISAMY, Kirubakaran
• Application Number:
  US11/686,292
• Publication Number:
  US 20080228550A1
• Time in Patent Office: Days
• US Class Current: 705/9
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A computer readable storage medium includes executable instructions to present a task grid to a set of users. A specification of target column information and source column information is accepted from the set of users to produce a data migration task grid. A data migration task is generated from the data migration task grid. The data migration task is processed.

Claims

1. A computer readable storage medium, comprising executable instructions to:

present a task grid to a plurality of users;

accept a specification of target column information and source column information from the plurality of users to produce a data migration task grid; and

generate a data migration task from the data migration task grid.

2. The computer readable storage medium of claim 1 further comprising executable instructions to process the data migration task.

3. The computer readable storage medium of claim 1 wherein the task grid is a spreadsheet.

4. The computer readable storage medium of claim 1 wherein the task grid includes a non-scrollable target column.

5. The computer readable storage medium of claim 1 wherein the executable instructions to accept include executable instruction to accept a specification from an offline session.

6. The computer readable storage medium of claim 1 wherein the source column information is specified from a fragment of a source column name.

7. The computer readable storage medium of claim 1 wherein the source column information is specified from a pull-down menu.

8. The computer readable storage medium of claim 1 further comprising executable instructions to

match target column data type with possible source column data types to form a list of matched source columns;

and

allow selection of a matched source column.

9. The computer readable storage medium of claim 1 wherein the data migration task is an extract, transform, load (ETL) task.

10. The computer readable storage medium of claim 1 wherein the data migration task is an enterprise information integration (Eli) task.

11. The computer readable storage medium of claim 1 further comprising executable instructions to support the approval of column mappings to produce approved column mappings.

12. The computer readable storage medium of claim 10 further comprising executable instructions to display a history of approved column mappings.

13. The computer readable storage medium of claim 1 further comprising executable instructions to support the specification of textual notes in the task grid.

14. The computer readable storage medium of claim 1 further comprising executable instructions to display a column mapping in response to selection of a row.

15. The computer readable storage medium of claim 1 further comprising executable instructions to process administrative settings.

16. The computer readable storage medium of claim 15 further comprising executable instructions to process administrative settings in the form of mapping validation rules.

17. The computer readable storage medium of claim 15 further comprising executable instructions to process administrative settings in the form of permissions.

18. The computer readable storage medium of claim 17 further comprising executable instructions to support permissions selected from read permission, read/write permission, and read/write/delete permission.

19. The computer readable storage medium of claim 1 further comprising executable instructions to support column mapping version control.

20. The computer readable storage medium of claim 1 further comprising executable instructions to facilitate the importation of table and column mapping information associated with an existing task.