System for a configurable open database connectivity conduit

• US 20070150507A1
• Filed: 02/02/2007
• Published: 06/28/2007
• Est. Priority Date: 11/06/2000
• Status: Abandoned Application

• Current Assignee: TeleCommunication Systems Inc (Comtech Telecommunications Corporation)
• Original Assignee: TeleCommunication Systems Inc (Comtech Telecommunications Corporation)
• Inventors: Wallace, Mark, Nardone, Joseph, Phelps, Jeffrey
• Application Number:
  US11/701,366
• Publication Number:
  US 20070150507A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation

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

1-45. -45. (canceled)

46. A method of making conduits, comprising:

providing a configurable conduit; and

providing a mapping rule set;

wherein a single said configurable conduit is modified by said mapping rule set for use with multiple applications.

47. The method of making conduits as recited by claim 46 wherein:

said mapping rule defines mapping of fields between at least two databases.

48. The method of making conduits as recited by claim 46, wherein:

said configurable conduit is created with a configurable conduit generator module.

49. The method of making conduits as recited by claim 48, wherein:

said configurable conduit generator module relies on a graphical use interface (GUI) to create said configurable conduit.

50. The method of making conduits as recited by claim 49, wherein:

said GUI provides a point-and-click environment to create the configurable conduit.

51. The method of making conduits as recited by claim 50, wherein:

said GUI allows selection of at least two databases.

52. The method of making conduits as recited by claim 49, wherein:

said GUI provides allows mapping of fields between at least two databases.

53. The method of making conduits as recited by claim 46, wherein:

said mapping rule set is pre-defined.

54. The method of making conduits as recited by claim 46, wherein:

said mapping rule set is user-defined.

55. A system for making conduits, comprising:

a configurable conduit; and

a mapping rule set;

wherein a single said configurable conduit is modified by said mapping rule set for use with multiple applications.

56. The system for making conduits as recited by claim 55 wherein:

said mapping rule defines mapping of fields between at least two databases.

57. The system for making conduits as recited by claim 55, wherein:

said configurable conduit is created with a configurable conduit generator module.

58. The system for making conduits as recited by claim 57, wherein:

said configurable conduit generator module relies on a graphical use interface (GUI) to create said configurable conduit.

59. The system for making conduits as recited by claim 58, wherein:

said GUI provides a point-and-click environment to create the configurable conduit.

60. The system for making conduits as recited by claim 59, wherein:

said GUI allows selection of at least two databases.

61. The system for making conduits as recited by claim 58, wherein:

said GUI provides allows mapping of fields between at least two databases.

62. The system for making conduits as recited by claim 55, wherein:

said mapping rule set is pre-defined.

63. The system for making conduits as recited by claim 55, wherein:

said mapping rule set is user-defined.

64. Apparatus for making conduits, comprising:

means for providing a configurable conduit; and

means for providing a mapping rule set;

wherein a single said configurable conduit is modified by said mapping rule set for use with multiple applications.

65. The apparatus for making conduits as recited by claim 64 wherein:

said mapping rule defines mapping of fields between at least two databases.

66. The apparatus for making conduits as recited by claim 64, wherein:

said configurable conduit is created with a configurable conduit generator module.

67. The apparatus for making conduits as recited by claim 66, wherein:

said configurable conduit generator module relies on a graphical use interface (GUI) to create said configurable conduit.

68. The apparatus for making conduits as recited by claim 67, wherein:

said GUI provides a point-and-click environment to create the configurable conduit.

69. The apparatus for making conduits as recited by claim 68, wherein:

said GUI allows selection of at least two databases.

70. The apparatus for making conduits as recited by claim 67, wherein:

said GUI provides allows mapping of fields between at least two databases.

71. The apparatus for making conduits as recited by claim 64, wherein:

said mapping rule set is pre-defined.

72. The apparatus for making conduits as recited by claim 64, wherein:

said mapping rule set is user-defined.