System and method for providing data manipulation using web services
First Claim
1. A method for transforming data, comprising:
- receiving an object definition having one or more elements as a repeating child element and one or more elements as a reusable data transformation;
detecting that a user dragged the repeating child element of a source file to multiple parent elements of a target file;
in response to detecting that a user dragged the repeating child element to multiple parent elements, creating one or more user-specified mappings between the dragged repeating child elements of the source file and the parent elements of the target file,wherein the one or more user-specified mappings are based, at least in part, upon dragging and dropping a source object into a program palette and mapping the source object to the repeating child element;
detecting that the user dragged one or more reusable data transformations to a parent element, wherein the one or more reusable data transformations provide frequently used data outputs from a data source;
parsing a web service description, the web service description providing a transformation of a source file to a target file,wherein the web service description is based, at least in part, upon the object definition, the one or more user-specified mappings, and the one or more reusable data transformations;
creating a repeating child element list upon parsing a repeating element;
generating automatically, based on parsing the web service description, a web service definition that specifies a web service;
generating, based on the information, a script to implement the defined transformation by invoking the web service;
storing the script;
receiving a request to execute the script on the source file;
initiating execution of the script; and
as part of executing the script;
transmitting a service request to the web service, wherein the service request requests transformation of input data obtained from the source file according to the information;
receiving a service response from the web service, wherein the service response includes output data, the output data including transformed input data; and
writing the output data to the target file.
2 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
19 Claims
-
1. A method for transforming data, comprising:
-
receiving an object definition having one or more elements as a repeating child element and one or more elements as a reusable data transformation; detecting that a user dragged the repeating child element of a source file to multiple parent elements of a target file; in response to detecting that a user dragged the repeating child element to multiple parent elements, creating one or more user-specified mappings between the dragged repeating child elements of the source file and the parent elements of the target file, wherein the one or more user-specified mappings are based, at least in part, upon dragging and dropping a source object into a program palette and mapping the source object to the repeating child element; detecting that the user dragged one or more reusable data transformations to a parent element, wherein the one or more reusable data transformations provide frequently used data outputs from a data source; parsing a web service description, the web service description providing a transformation of a source file to a target file, wherein the web service description is based, at least in part, upon the object definition, the one or more user-specified mappings, and the one or more reusable data transformations; creating a repeating child element list upon parsing a repeating element; generating automatically, based on parsing the web service description, a web service definition that specifies a web service; generating, based on the information, a script to implement the defined transformation by invoking the web service; storing the script; receiving a request to execute the script on the source file; initiating execution of the script; and as part of executing the script; transmitting a service request to the web service, wherein the service request requests transformation of input data obtained from the source file according to the information; receiving a service response from the web service, wherein the service response includes output data, the output data including transformed input data; and writing the output data to the target file. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for transforming data, comprising:
-
a memory to store instructions; one or more processors to execute the instructions and the instructions cause the processor to; receive, from a user, through a graphical user interface (GUI) information defining a transformation of a source file to a target file comprising; information identifying a source object definition having one or more elements as a repeating child element and one or more elements as a reusable data transformation; and information identifying a target object definition having one or more parent elements; information identifying a mapping of components in the source object definition to inputs in the web service definition; and information identifying a mapping of outputs in the web service definition to components in the target object definition; parent element; parse the web service description to automatically generate a web service definition that specifies a web service; create a repeating child element list upon parsing a repeating element; generate automatically, based on the received information, a script to implement the defined transformation by invoking the web service; store the script; receive a request to execute the script on the source file; initiate execution of the script; and as part of executing the script; transmit a service request to the web service, wherein the service request requests transformation of input data obtained from the source file according to the information; receive a service response from the web service, wherein the service response includes output data, the output data including transformed input data; and write the output data to the target file. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A system for transforming data, comprising:
-
means for receiving information defining a transformation of a source file to a target file, wherein the information identifies a web service description to provide the transformation, wherein the information is based, at least in part, upon; receiving an object definition having one or more elements as a repeating child element and one or more elements as a reusable data transformation; detecting that a user dragged the repeating child element of the source file to multiple parent elements of the target file; detecting that the user dragged one or more reusable data transformations to a parent element, wherein the one or more reusable data transformations provide frequently used data outputs from a data source; means for parsing the web service description to automatically generate a web service definition that specifies a web service; means for creating a repeating child element list upon parsing a repeating element; means for generating automatically, based on the received information, a script to implement the defined transformation by invoking the web service; means for storing the script; means for receiving a request to execute the script on the source file; means for initiating execution of the script; means for transmitting a service request to the web service, wherein the service request requests transformation of input data obtained from the source file according to the information as part of executing the script; means for receiving a service response from the web service, wherein the service response includes output data, the output data including transformed input data; and means for writing the output data to the target file.
-
Specification