# US 2005/0038779 A1 · XML configuration technique and graphical user interface (GUI) for managing user data in a plurality of databases

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2005/0038779 A1
- Document ID: US20050038779A1
- Status: Published application
- Kind: A1
- Application number: 10/888,366
- Filed: 2004-07-09
- Published: 2005-02-17
- Earliest claimed: 2003-07-11
- Assignees: Computer Associates International, Inc.
- Inventors: Jesus Fernandez; Catherine Sullivan; Kejian Qiu; Ronald Jacobson
- Web page: https://patentgrep.com/patent/US20050038779A1

## CPC

- G06F 40/151: Transformation
- G06F 16/258: {Data format conversion from or to a database}
- G06F 40/12: Use of codes for handling textual entities
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 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.

### Claim 2 (depends on 1)

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

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 1)

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

### Claim 5 (depends on 1)

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

### Claim 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.

### Claim 7 (depends on 6)

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.

### Claim 8 (depends on 6)

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.

### Claim 9 (depends on 8)

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.

### Claim 10 (depends on 6)

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.

### Claim 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.

### Claim 12 (depends on 11)

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.

### Claim 13 (depends on 11)

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.

### Claim 14 (depends on 13)

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.

### Claim 15 (depends on 11)

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.
