Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-10-21
2001-10-23
Alam, Hosain T. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C709S225000, C709S241000, C717S152000, C717S152000
Reexamination Certificate
active
06308178
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates generally to Enterprise Application Integration “EAI”) software, and more particularly to a configurable software system for providing migration of data among heterogeneous applications without requiring the development of code to accommodate the specific requirements of the heterogeneous applications present in a particular environment.
BACKGROUND OF THE INVENTION
EAI software is generally designed to address the need of business to integrate various business software applications employed by the diverse operating sectors of a single business organization (for example, financial operations, human resources, shipping and receiving, etc.), or by such operating sectors of multiple organizations. Over time, many organizations incorporate disparate software applications, each designed to manage a specific business function or set of functions. Accordingly, data related to these business functions is dispersed across the organization, and resides separately within the various software applications.
Unfortunately, various software applications maintain data according to different data models, such as hierarchical networks, relational models, spreadsheets, multimedia databases, knowledge databases and other types of data models. Eventually, as more and more such applications are added to an organization, the need for data synchronization (or updating) and migration among applications grows. Thus, intelligent management, manipulation, and maintenance of organization-wide data requires an integration system capable of providing data transfer interfaces among the various heterogeneous applications employed throughout the organization (or across various organizations).
One product commonly found in modem business enterprises falls within the broad category of Enterprise Resource Planning “ERP”) software which generally provides packaged suites of business applications. Examples of such ERP software include offerings by Oracle Corporation, SAP, PeopleSoft, and Baan. These ERP products may replace many individual business function applications with a single, integrated suite of applications, encompassing business operations including accounting, purchasing, shipping and receiving, human resources, etc. Notwithstanding a proliferation of such consolidated products, many organizations also maintain a variety of disparate applications as described above. Additionally, many organizations employ similar or identical ERP products at geographically diverse locations. Thus, integration among these heterogeneous applications and consolidated ERP products, as well as integration among ERP products, is desirable.
Various methods of meeting the above-described integration needs presently exist. One method is the development of custom integration software to interface, for example, an organization's specific set of heterogeneous applications with the applications within the organization's ERP product. The custom integration method employs a traditional software development model wherein custom code is written specifically to operate with a fixed group of heterogeneous applications and integrate them with an ERP product of a particular version. This method is time consuming, labor intensive and expensive to implement. Moreover, after the custom code is written, implemented, and tested, it provides the required integration only so long as the environment remains unchanged. When, for example, an updated version of the organization's ERP product is released, the custom integration software must be updated to correspond with the new version. This maintenance is also time-consuming and expensive. Additionally, because the timing of such maintenance depends entirely upon the new ERP product's release date, the associated costs are unpredictable and, therefore, difficult to budget.
Off-the-shelf, front-end integration packages, such as those provided by Cross Worlds or Constellar, are also available to address an organization's integration needs. This software is attached to the heterogeneous source applications and is used to query the source applications to obtain the desired data. Whole files are not transferred from a source application to a destination application for manipulation and use. More importantly, this front-end integration software does not directly integrate with the applications at the destination end, but instead requires a software developer to generate custom code to bridge the gap between the front-end package and the destination applications. Accordingly, this software shares some of the costs and inflexibility disadvantages inherent in custom-built interfaces.
Other integration tools, such as products like Smart dB, include templates to connect destination applications with back-end servers and source applications. These templates reduce labor costs by reducing the complexity of the overall integration task. However, such template tools are also undesirable because developers must write custom code to bridge the gap between the source applications and the templates.
SUMMARY OF THE INVENTION
The integration system of the present invention provides a flexible, end-to-end integration solution that manages all mapping, validation, and synchronization of data among heterogeneous source and destination applications within an organization and among the applications of multiple organizations. The system includes an active component (or engine) that performs the underlying communication and data processing functions, and a repository of information used by the active component relating to the characteristics of the source and destination applications. The functionality of the system is expandable through use of modules (or cartridges) that may be added to the repository as the organization's integration requirements expand. The modules are configurable, pre-built integration packages, which may be specific to a particular database application (for example, a particular application within an ERP product such as Oracle Applications). Once the repository is configured with information describing data contained within the organization's heterogeneous source applications, each module defines interface processes or instruction sets which migrate data between the source applications and a particular destination application. The active component is driven by instruction sets associated with the applicable module and other information in the repository to read and process inputs from a source application and perform the transfer of data to a destination application.
In addition to the modules, the repository includes configuration data relating to each installed module. Upon installation or expansion of a particular integration system according to the present invention, a user may activate a configuration interface provided with the system to configure the system to operate with the installed modules. During this process, configuration data is created and stored in the configuration data storage section of the repository within a portion of the configuration data storage corresponding to the applicable module. The active component uses the configuration data to determine which instruction sets (contained within the modules) to access. The modules assemble the instructions by accessing data elements (individual units of re-usable code) stored in a repository library. Since multiple modules may access the same data elements, updates to the library data elements are universally applicable to a variety of modules.
By providing a standard interface methodology that incorporates a collection of rules describing a particular destination application, the integration system of the present invention eliminates the need for custom software and the disadvantages of the development life cycle associated therewith, reduces user learning curves by virtue of the knowledge contained within the repository, eliminates manual data entry, and provides an upgrade path to future releases of the destination application, thereby reducing the
Blackledge Eric
Chang Chia-Pei
Connolly Brian J.
Hoffman Robert John
Homan Bob
Alam Hosain T.
Alam Shahid
Barnes & Thornburg
Darc Corporation
LandOfFree
System for integrating data among heterogeneous systems does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System for integrating data among heterogeneous systems, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for integrating data among heterogeneous systems will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2573733