APPARATUS AND METHOD FOR UTILIZING A TASK GRID TO GENERATE A DATA MIGRATION TASK
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.
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.