David E Swanholm

US Patent:

7051334, May 23, 2006

Filed:

Apr 27, 2001

Appl. No.:

09/843682

Inventors:

Duane L. Porter - Blue Springs MO, US
David E. Swanholm - Stilwell KS, US

Assignee:

Sprint Communications Company L.P. - Overland Park KS

International Classification:

G06F 9/46

US Classification:

719313, 709201

Abstract:

The present invention is a distributed extract, transform and load (ETL) method for delivering information within a computing environment, comprising extracting information from an information source and transforming the extracted information. The transformed information is isolated by wrapping the transformed information into a message envelope having a standard format. The message envelope is routed to at least one information target, unwrapped to reveal the received information, preferably transformed again, and loaded into the information target. The extraction, transformation, and adaptation steps on the source side are isolated from the routing step such that the extraction, transformation, and adaptation steps on the source side may be executed simultaneously for a plurality of information sources distributed across the computing environment to produce a plurality of message envelopes. The routing, unwrapping, mapping, transformation, and loading steps on the target side are repeated for each of the plurality of message envelopes.