System and method for providing data manipulation using web services

• US 10,032,130 B2
• Filed: 03/07/2006
• Issued: 07/24/2018
• Est. Priority Date: 03/07/2005
• Status: Active Grant

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Inventors: Bhatia, Rishi, Schulze, Matthew J., Tomaszewski, John M., Kittredge, Robert B., Srinivas, Davanum
• Primary Examiner(s): Thomas, Ashish K
• Assistant Examiner(s): CHOJNACKI, MELLISSA M
• Application Number:
  US11/369,397
• Publication Number:
  US 20060200747A1
• Time in Patent Office: 4,522 Days
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06Q 10/10 Office automation; Time management

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.

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.

2. The method of claim 1, wherein:

receiving information defining a transformation comprises receiving a uniform resource identifier (URI) associated with the web service; and

generating the script comprise generating a script that includes the received URI.

3. The method of claim 1, wherein:

receiving information defining a transformation comprises receiving a source object definition and a target object definition; and

generating a script comprises generating a script to read input data from a source file structured in accordance with the source object definition and to write output data to a target file structured in accordance with the target output definition.

4. The method of claim 1, wherein:

transmitting the service request comprises transmitting a Simple Object Access Protocol (SOAP) message to a web server offering the web service, wherein the transmitted SOAP message includes the input data; and

receiving the service response comprises receiving a SOAP message from the web server, wherein the received SOAP message includes the output data.

5. The method of claim 1, wherein the source file is a flat file and the target file is an extensible markup language (XML) file.

6. The method of claim 5, wherein:

the web service definition comprises a Web Service Definition Language (WSDL) file; and

generating the script comprises parsing the WSDL file and generating the script based on information parsed from the WSDL file.

7. The method of claim 1,

wherein the user-specified mappings comprise a connection indicator indicating a dependency and a direction of the dependency between the parent elements and repeating child elements.

8. The method of claim 7, wherein the information is further based, at least in part, upon:

receiving user-specified web service mappings between the source object definition and a web service input; and

receiving user-specified target mappings between a web service output and the target object definition.

9. The method of claim 1, wherein receiving information defining a transformation of a source file to a target file comprises

receiving, from a user, through a graphical user interface (GUI) information identifying a source object definition;

receiving, from the user, through the GUI information identifying a target object definition;

receiving, from the user, through the GUI information identifying a web service description;

receiving, from the user, through the GUI information identifying a mapping of components in the source object definition to inputs in the web service definition; and

receiving, from the user, through the GUI information identifying a mapping of outputs in the web service definition to components in the target object definition.

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.

11. The system of claim 10, wherein the instructions further cause the processor to:

receive information defining a transformation by receiving a uniform resource identifier (URI) associated with the web service; and

generate the script by generating a script that includes the received URI.

12. The system of claim 10, wherein the instructions further cause the processor to:

receive information defining a transformation by receiving a source object definition and a target object definition; and

generate a script by generating a script to read input data from a source file structured in accordance with the source object definition and to write output data to a target file structured in accordance with the target output definition.

13. The system of claim 10, wherein the instructions further cause the processor to:

transmit the service request by transmitting a Simple Object Access Protocol (SOAP) message to a web server offering the web service, wherein the transmitted SOAP message includes the input data; and

receive the service response by receiving a SOAP message from the web server, wherein the received SOAP message includes the output data.

14. The system of claim 10, wherein the instructions further cause the processor to:

receive information defining the transformation by receiving a web service description associated with the web service; and

generate the script by generating the script based on the web service definition.

15. The system of claim 14, wherein the web service definition comprises a Web Service Definition Language (WSDL) file;

and wherein the instructions further cause the processor to generate the script by parsing the WSDL file and generating the script based on information parsed from the WSDL file.

16. The system of claim 10, wherein the source file is a flat file and the target file is an XML file.

17. The system of claim 12, further comprising instructions to cause the processor to, in response to detecting that a user dragged the repeating child element to multiple parent elements,

create 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, and wherein the user-specified mappings comprise a connection indicator indicating a dependency and a direction of the dependency between the parent elements and repeating child elements.

18. The system of claim 17, wherein the information is further based, at least in part, upon:

receiving user-specified web service mappings between the source object definition and a web service input; and

receiving user-specified target mappings between a web service output and the target object definition.

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.