# US 2002/0055939 A1 · System for a configurable open database connectivity conduit

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

- Number: US 2002/0055939 A1
- Document ID: US20020055939A1
- Status: Published application
- Kind: A1
- Application number: 09/985,879
- Filed: 2001-11-06
- Published: 2002-05-09
- Earliest claimed: 2000-11-06
- Inventors: Joseph Nardone; Jeffrey Phelps; Mark Wallace
- Web page: https://patentgrep.com/patent/US20020055939A1

## CPC

- G06F 16/273: {Asynchronous replication or reconciliation}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A configurable conduit generator module is utilized to generate customizable conduits. The configurable conduit may be configured to provide the synchronization rules between client databases and corresponding enterprise databases. The configurable conduit generator module may be configured to provide a point-and-click environment to create the configurable conduit. In particular, a graphical user interface (GUI) may be presented to the user to select the client database and to select the enterprise database. Another GUI may be presented to provide the mapping of the fields (or columns) from the client database to the enterprise database. The direction of the synchronization may be also be specified. Once the mapping of the fields is created, the mapping file is saved for execution by the configurable conduit during a synchronization event.

## Claims

### Claim 1

A method of creating conduits for synchronizations, comprising:
generating a first graphical user interface;
selecting a first database and a second database on said first graphical user interface;
mapping at least one field of said first database to a corresponding field of said second database in a map file;
programming a conduit with said map file; and
executing said conduit with said map file in response to a synchronization request, wherein said conduit provides synchronization rules from said map file for said first database and said second database.

### Claim 2 (depends on 1)

The method according to claim 1, further comprising:
browsing for one of said first database and said second database in response to selection of said first database and said second database; and
importing said other one of said first database and said second database in response to selection of said first database and said second database.

### Claim 3 (depends on 1)

The method according to claim 1, wherein said one of said first database and said second database is a client application database and said other one of said first database and said second database is an enterprise application database.

### Claim 4 (depends on 1)

The method according to claim 1, further comprising:
generating a second graphical user interface said mapping of said at least one field of said first database to said respective field of said second database to said map file.

### Claim 5 (depends on 4)

The method according to claim 4, further comprising:
selecting said first database from said second graphical user interface;
importing a plurality of fields of said first database; and
displaying said plurality of fields of said first database.

### Claim 6 (depends on 5)

The method according to claim 5, further comprising:
selecting said second database from said second graphical user interface;
importing a plurality of fields of said second database; and
displaying said plurality of fields of said second database.

### Claim 7 (depends on 6)

The method according to claim 6, further comprising:
generating a third graphical user interface in response to a completion of said display of said plurality of fields of said first database and said plurality of field of said second database;
mapping said plurality of fields of said first database to respective fields of said plurality of fields of said second database by a default rule into a set of rules; and
displaying said initial set of rules for said mapping of said plurality of fields of said first database to respective fields of said plurality of fields of said second database.

### Claim 8 (depends on 7)

The method according to claim 7, further comprising:
selecting a rule from said set of rules; and
deleting said rule from said set of rules.

### Claim 9 (depends on 7)

The method according to claim 7, further comprising:
selecting a mechanism for adding a rule to said set of rules;
generating a fourth graphical user interface for adding said rule to said initial set of rules in response to said selection of said mechanism.

### Claim 10 (depends on 9)

The method according to claim 9, further comprising:
selecting a field from said plurality of fields of said first database from said fourth graphical user interface;
selecting a corresponding field from said plurality of fields of said second database from said fourth graphical user interface; and
mapping said field from said plurality of fields of said first database to said corresponding field from said plurality of fields of said second database.

### Claim 11 (depends on 10)

The method according to claim 10, further comprising:
saving said set of rules as said map file.

### Claim 12

A method of synchronizing databases, comprising:
configuring a conduit for a synchronization between a first database and a second database;
initiating a synchronization request; and
synchronizing said first database and said second database according to said conduit in response to said synchronization request.

### Claim 13 (depends on 12)

The method according to claim 12, wherein said configuration comprises:
generating a first graphical user interface selecting a first database and a second database from said first graphical user interface;
mapping at least one field of said first database to a respective field of said second database to a map file;
linking said conduit with said map file; and
executing said conduit with said map file in response to a synchronization request, wherein said conduit executes said synchronization on said first database and said second database according to said map file.

### Claim 14 (depends on 13)

The method according to claim 13, wherein said selection of said first database and said second database comprises:
browsing for one of said first database and said second database in response to selection of said first database and said second database; and
importing said other one of said first database and said second database in response to selection of said first database and said second database.

### Claim 15 (depends on 14)

The method according to claim 14, further comprising:
displaying a plurality of fields of said first database and a plurality of fields of said second database within a display element of said first graphical user interface;
initiating a generation of a second graphical user interface; and
displaying a set of rules for mapping each field of said plurality of field of said first database with a corresponding field of said plurality of fields of said second database.

### Claim 16 (depends on 15)

The method according to claim 15, further comprising:
selecting a rule from said set of rules; and
deleting said rule from said set of rules.

### Claim 17 (depends on 16)

The method according to claim 16, further comprising:
initiating a mechanism on said second graphical user interface for adding a new rule to said initial set of rules;
generating a third graphical user interface for said adding of said new rule;
selecting a field from said plurality of fields of said first database and a corresponding field from said plurality of fields of said second database on said third graphical user interface; and
adding said new rule in response to a completion of said selection of said field and said corresponding field.

### Claim 18 (depends on 18)

The method according to claim 18, further comprising:
saving modified set of rules in a persistent memory storage for access by said conduit.

### Claim 19

A computer readable storage medium on which is embedded one or more computer programs, said one or more computer programs implementing a method of creating conduits for synchronizations, said one or more computer programs comprising a set of instructions for:
generating a first graphical user interface;
selecting a first database and a second database on said first graphical user interface;
mapping at least one field of said first database to a corresponding field of said second database in a map file;
programming a conduit with said map file; and
executing said conduit with said map file in response to a synchronization request, wherein said conduit provides synchronization rules from said map file for said first database and said second database.

### Claim 20 (depends on 19)

The computer readable storage medium in according to claim 19, said one or more computer programs further comprising a set of instructions for:
browsing for one of said first database and said second database in response to selection of said first database and said second database; and
importing said other one of said first database and said second database in response to selection of said first database and said second database.

### Claim 21 (depends on 19)

The computer readable storage medium in according to claim 19, said one or more computer programs further comprises instructions for wherein said one of said first database and said second database is a client application database and said other one of said first database and said second database is an enterprise application database.

### Claim 22 (depends on 19)

The computer readable storage medium in according to claim 19, said one or more computer programs further comprising a set of instructions for::
generating a second graphical user interface said mapping of said at least one field of said first database to said respective field of said second database to said map file.

### Claim 23 (depends on 22)

The computer readable storage medium in according to claim 22, said one or more computer programs further comprising a set of instructions for:
selecting said first database from said second graphical user interface;
importing a plurality of fields of said first database; and
displaying said plurality of fields of said first database.

### Claim 24 (depends on 23)

The computer readable storage medium in according to claim 23, said one or more computer programs further comprising a set of instructions for:
selecting said second database from said second graphical user interface;
importing a plurality of fields of said second database; and
displaying said plurality of fields of said second database.

### Claim 25 (depends on 24)

The computer readable storage medium in according to claim 24, said one or more computer programs further comprising a set of instructions for:
generating a third graphical user interface in response to a completion of said display of said plurality of fields of said first database and said plurality of field of said second database;
mapping said plurality of fields of said first database to respective fields of said plurality of fields of said second database by a default rule into a set of rules; and
displaying said set of rules for said mapping of said plurality of fields of said first database to respective fields of said plurality of fields of said second database.

### Claim 26 (depends on 25)

The computer readable storage medium in according to claim 25; said one or more computer programs further comprising a set of instructions for:
selecting a rule from said set of rules; and
deleting said rule from said set of rules.

### Claim 27 (depends on 26)

The computer readable storage medium in according to claim 26, said one or more computer programs further comprising a set of instructions for:
selecting a mechanism for adding a rule to said set of rules;
generating a fourth graphical user interface for adding said rule to said set of rules in response to said selection of said mechanism.

### Claim 28 (depends on 27)

The computer readable storage medium in according to claim 27, said one or more computer programs further comprising a set of instructions for:
selecting a field from said plurality of fields of said first database from said fourth graphical user interface;
selecting a corresponding field from said plurality of fields of said second database from said fourth graphical user interface; and
mapping said field from said plurality of fields of said first database to said corresponding field from said plurality of fields of said second database.

### Claim 29 (depends on 28)

The computer readable storage medium in according to claim 28, said one or more computer programs further comprising a set of instructions for:
saving said set of rules as said map file.

### Claim 30

An apparatus for creating conduits for synchronizations, comprising:
means for generating a first graphical user interface;
means for selecting a first database and a second database on said first graphical user interface;
means for mapping at least one field of said first database to a corresponding field of said second database in a map file;
means for programming a conduit with said map file; and
means for executing said conduit with said map file in response to a synchronization request, wherein said conduit provides synchronization rules from said map file for said first database and said second database.

### Claim 31 (depends on 30)

The apparatus according to claim 30, further comprising:
means for browsing for one of said first database and said second database in response to selection of said first database and said second database; and
means for importing said other one of said first database and said second database in response to selection of said first database and said second database.

### Claim 32 (depends on 30)

The apparatus according to claim 30, wherein said one of said first database and said second database is a client application database and said other one of said first database and said second database is an enterprise application database.

### Claim 33 (depends on 3)

The apparatus according to claim 3Q, further comprising:
means for generating a second graphical user interface said mapping of said at least one field of said first database to said respective field of said second database to said map file.

### Claim 34 (depends on 33)

The apparatus according to claim 33, further comprising:
means for selecting said first database from said second graphical user interface;
importing a plurality of fields of said first database; and
displaying said plurality of fields of said first database.

### Claim 35 (depends on 34)

The apparatus according to claim 34, further comprising:
means for selecting said second database from said second graphical user interface;
means for importing a plurality of fields of said second database; and
means for displaying said plurality of fields of said second database.

### Claim 36 (depends on 35)

The apparatus according to claim 35, further comprising:
means for generating a third graphical user interface in response to a completion of said display of said plurality of fields of said first database and said plurality of field of said second database;
means for mapping said plurality of fields of said first database to respective fields of said plurality of fields of said second database by a default rule into a set of rules; and
means for displaying said initial set of rules for said mapping of said plurality of fields of said first database to respective fields of said plurality of fields of said second database.

### Claim 37 (depends on 36)

The apparatus according to claim 36, further comprising:
means for selecting a rule from said initial set of rules; and
means for deleting said rule from said initial set of rules.

### Claim 38 (depends on 36)

The apparatus according to claim 36, further comprising:
means for selecting a mechanism for adding a rule to said initial set of rules;
means for generating a fourth graphical user interface for adding said rule to said set of rules in response to said selection of said mechanism.

### Claim 39 (depends on 38)

The apparatus according to claim 38, further comprising:
means for selecting a field from said plurality of fields of said first database from said fourth graphical user interface;
means for selecting a corresponding field from said plurality of fields of said second database from said fourth graphical user interface; and
means for mapping said field from said plurality of fields of said first database to said corresponding field from said plurality of fields of said second database.

### Claim 40 (depends on 39)

The apparatus according to claim 39, further comprising:
means for saving said set of rules as said map file.

### Claim 41

A conduit for synchronization, comprising:
a plurality of mapping files associated with a plurality of databases; and
a configurable conduit, wherein said configurable conduit is programmed to synchronize said each database of said plurality of databases according to a respective mapping file of said plurality of mapping files.

### Claim 42 (depends on 41)

The conduit according to claim 41, wherein each mapping file of said plurality of mapping files is configured to specify a mapping of at least one field of a first database to a corresponding field of a second database.

### Claim 43 (depends on 41)

The conduit according to claim 41, wherein one of said first database and said second database is a client database.

### Claim 44 (depends on 43)

The conduit according to claim 43, wherein other of said first database and said second database is an enterprise database.

### Claim 45 (depends on 41)

The conduit according to claim 41, wherein each mapping file of said plurality of mapping files is configured to specify a direction of overwrite of data between a first database and a second database.
