Method for service oriented data extraction transformation and load

Abstract

The present invention relates to a method for the configurable real time transformation of dissimilar data sources, the method further consisting of the steps of acquiring real time information pertaining to at least one data source, wherein the information comprises reference information that is associated with the data source, data transformation specification information that is associated with the data source, and scheduled event specification information that is associated with the data source, and maintaining the data source information. The method further comprises the steps of acquiring data from the data source in accordance with a specified scheduled event, converting the acquired data into a predetermined standardized format, performing at least one data transformation function from the real time stream upon the converted data in accordance with the acquired data transformation specification information that was associated with the data source; and transmitting the transformed data to a destination data source.

1 - 5 . (canceled) 
   
   
       6 . A method for the configurable real time transformation of dissimilar data sources in a web service-based environment, the method comprising:
 acquiring real time information pertaining to at least one data source, wherein the information comprises reference information that is associated with the data source, data transformation specification information that is associated with the data source, and scheduled event specification information that is associated with the data source;   maintaining the data source information;   acquiring data from the data source in accordance with a specified scheduled event;   converting the acquired data into a predetermined standardized format using standardized normalization and a conversion format;   performing at least one data transformation function identified from the real time information upon the converted data in accordance with the acquired data transformation specification information associated with the data source;   updating an extraction schedule; and   transmitting the transformed data to a destination data source;   wherein the standardized normalization and conversion format is managed using extensible markup language;   wherein the data sources is stored at a remote location;   wherein the data sources, transformation specification information, and scheduled event specification information associated with the data source are configured to be modified.