XML configuration technique and graphical user interface (GUI) for managing user data in a plurality of databases

• US 20050038779A1
• Filed: 07/09/2004
• Published: 02/17/2005
• Est. Priority Date: 07/11/2003
• 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: Fernandez, Jesus, Jacobson, Ronald, Qiu, Kejian, Sullivan, Catherine Elizabeth
• Granted Patent: US 7,788,214 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 40/12 Use of codes for handling textual entities
• CPC Class Codes: G06F 40/151 Transformation

Abstract

A system and method for integrating data from a source application to a target application are provided. The system includes an interface module for extracting data from the source application and publishing the data in a first predetermined format; a business transformation logic engine for transforming the formatted data by a series of transformation handlers into a second predetermined format usable by the target application; and a configuration interface for defining the data to be transformed from the source application to the target application.

Claims

1. A system for integrating data from a source application to a target application comprising:

an interface module for extracting data from the source application and publishing the data in a first predetermined format;

a business transformation logic engine for transforming the formatted data by a plurality of transformation handlers into a second predetermined format usable by the target application; and

a configuration interface for defining the data to be transformed from the source application to the target application.

2. The system as in claim 1, wherein the configuration interface formats the data in XML (Extensible Markup Language) format.

3. The system as in claim 1, wherein the configuration interface defines decision tables based on business rules for combining values associated with data elements of the source application and outputting a value associated with at least one data element in the target application.

4. The system as in claim 1, wherein the configuration interface maps data elements from the source application to data elements of the target application.

5. The system as in claim 1, wherein the configuration interface defines an order of execution of the plurality of transformation handlers.

6. A method in a computer system for configuring a transformation of data from a source application to a target application, the method comprising the steps of:

presenting at least one data element to a user from the source application;

presenting at least one data element to the user from the target application; and

presenting means for associating the at least one data element of the source application to the at least one data element of the target application.

7. The method as in claim 6, further comprising the steps of:

presenting a plurality of XSL (Extensible Stylesheet Language) files for transforming the source application data; and

presenting a prompt to the user requesting submission of a sequential order for executing the plurality of XSL files.

8. The method as in claim 6, further comprising the steps of:

presenting a prompt to the user for associating a comparison operator to the at least one data element of the source application; and

presenting a prompt to the user for associating a result of the comparison to the at least one data element of the target application.

9. The method as in claim 8, further comprising the step of presenting a table for selecting a plurality of data elements of the source application to be compared.

10. The method as in claim 6, further comprising the step of presenting a prompt to the user for selecting a node of the source application to be configured.

11. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for configuring a transformation of data from a source application to a target application, the method steps comprising:

presenting at least one data element to a user from the source application;

presenting at least one data element to the user from the target application; and

presenting means for associating the at least one data element of the source application to the at least one data element of the target application.

12. The program storage device as in claim 11, further comprising the steps of:

presenting a plurality of XSL (Extensible Stylesheet Language) files for transforming the source application data; and

presenting a prompt to the user requesting submission of a sequential order for executing the plurality of XSL files.

13. The program storage device as in claim 11, further comprising the steps of:

presenting a prompt to the user for associating a comparison operator to the at least one data element of the source application; and

presenting a prompt to the user for associating a result of the comparison to the at least one data element of the target application.

14. The program storage device as in claim 13, further comprising the step of presenting a table for selecting a plurality of data elements of the source application to be compared.

15. The program storage device as in claim 11, further comprising the step of presenting a prompt to the user for selecting a node of the source application to be configured.