Methods and apparatus for transferring data

An apparatus for transferring data, comprising:

• a memory;
• and
• a processor, coupled to the memory, and adapted to:
• receive first information about a location and type of a data source and a location and type of a data destination associated with a first data transfer from the data source to the data destination;
• receive second information relating data in previously-created mapping documents in the data source to data in the data destination;
• create a data structure that defines a relationship between the data source and the data destination based on the first and/or second received information;
• and
• employ the data structure for the first data transfer;
• wherein the data structure is adapted to transfer data from a single table in the data source to multiple tables in the data destination and transfer data from multiple tables in the data source to a single table in the data destination,
• wherein the apparatus is further adapted to receive the first and/or second information in response to prompting a user for the first and/or second information with a graphical user interface.

A system for transferring data, comprising:

• a data source associated with a first data transfer;
• a data destination associated with the first data transfer;
• and
• an apparatus for transferring data, coupled to the data source and the data destination, and having:
• a memory;
• and
• a processor, coupled to the memory, and adapted to:
• receive first information about a location and type of the data source and a location and type of the data destination associated with the first data transfer from the data source to the data destination;
• receive second information relating data in previously-created mapping documents in the data source to data in the data destination;
• create a data structure that defines a relationship between the data source and the data destination based on the first and/or second received information;
• and
• employ the data structure for the first data transfer;
• wherein the data structure is adapted to transfer data from a single table in the data source to multiple tables in the data destination and transfer data from multiple tables in the data source to a single table in the data destination,
• wherein the processor is further adapted to receive the first/and or second information in response to prompting a user for the first and/or second information with a graphical user interface.