Ca, Inc.

Computer Associates Think, Inc.

Matthew J Schulze

Davanum M Srinivas

Rishi Bhatia

John Michael Tomaszewski

Robert B Kittredge

A method for transforming data includes receiving information defining a transformation of a source file to a target file, wherein the information identifies a web service and generating, based on the received information, a script operable when executed to implement the defined transformation. The script is then stored. The method further includes receiving a request to perform the transformation on a first file and initiating execution of the script. Additionally, as part of executing the script, the method includes transmitting a service request to the web service that includes input data obtained from the first file. Also as part of executing the script, the method includes receiving a service response from the web service, wherein the service response includes output data and writing the output data to a second file.

System and method for providing data manipulation using web services

A method for transforming data includes creating an array and initializing a value in each array element of the array. The method also includes storing data in the array from data components in a source file by, for each data component in the source file, detecting a beginning of the data component and determining whether an array element corresponding to the detected data component is included in the array. If an array element corresponding to a particular data component is included in the array, a value of the corresponding array element is set based on data in the detected data component. If an array element corresponding to that data component is not included in the array, the detected data component is discarded. Additionally, the method includes writing at least a portion of the data stored in the array to a target file.

System and method for data manipulation

In one embodiment of the invention, a system for data manipulation includes a mapper module operable to receive a first data format of a source file, receive a second data format of a target file, and automatically generate a script to represent a movement of data from the source file to the target file. A server is operable to execute the script, a first interface module is coupled to the source file and is operable to load the data in accordance with the script, and a second interface module is coupled to the target file and is operable to store the data in accordance with the script.

In one embodiment of the invention, a method for designing data movement from a source file to a target file includes receiving a first data format of a source file via a graphical user interface, receiving a second data format of a target file via the graphical user interface, receiving mappings from a user via the graphical user interface to represent a desired movement of data from the source file to the target file, and automatically converting the mappings into a script to represent a movement of data from the source file to the target file.

Growing community of inventors

Glen Ellyn, IL, United States of America

Matthew J Schulze