|Publication number||US7685562 B2|
|Application number||US 10/120,031|
|Publication date||23 Mar 2010|
|Filing date||9 Apr 2002|
|Priority date||28 Sep 2001|
|Also published as||US20070226682|
|Publication number||10120031, 120031, US 7685562 B2, US 7685562B2, US-B2-7685562, US7685562 B2, US7685562B2|
|Inventors||William Bruce Kilgore, Daniel Kearns|
|Original Assignee||Siebel Systems, Inc.|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (28), Non-Patent Citations (9), Classifications (7), Legal Events (2)|
|External Links: USPTO, USPTO Assignment, Espacenet|
The present patent application is a continuation of prior application Ser. No. 09/968,458 filed Sep. 28, 2001 now abandoned, entitled METHOD AND CODE GENERATOR SYSTEM FOR USING INTEGRATING DIFFERENT ENTERPRISE BUSINESS APPLICATIONS.
This invention relates to computer systems, and more specifically to a method and code generator for integrating different enterprise business applications.
According to one observer, if the lifeblood of today's corporations is information, then their arteries are the “inter-application interfaces” that facilitate movement of data around the corporate enterprise. This has more recently become known as an “application network”.
For the typical organization, the application network has grown organically into a collection of ad hoc application integration programs. This menagerie has had a very serious impact on businesses as it increases the time for implementing new applications, prevents senior management from getting a clear picture of the business and, in short, clogs the corporate arteries. In spite of the fact that application integration has become crucial to a competitive corporation's survival, it has nevertheless been acceptable in the prior art to handcraft or “hack” custom code for such purposes at enormous long-term cost to the corporation. Long-term application integration decisions have, likewise, been made at the lowest possible levels based solely on individual project criteria. Because of the decidedly difficult nature of these problems, an effective enterprise application integration (EAI) solution has yet to be found.
The advent of the Internet, client/server computing, corporate mergers and acquisitions, globalization and business process re-engineering, have together forced corporate information technology (IT) departments to continually seek out new, and often manual, ways to make different systems talk to each other—regardless of how old some of those systems may be. In the ensuing chaos, inadequate communications systems have had a debilitating effect on IT's abilities to move as fast as the business needs it to.
On the other hand, typical ERP systems are essentially large, integrated packaged applications that support core business functions, such as payroll, manufacturing, general ledger, and human resources. Implementing an ERP system, however, can be an overwhelming process for a number of reasons.
First and foremost, the corporation is buying a product and not building a solution. This means that business units within the corporation must adapt to the product and how it works, not the other way around. Furthermore, today's ERP systems cannot replace all of a corporation's custom solutions. They must, therefore, communicate effectively with other legacy systems in place. Finally, it is not atypical for a corporation to employ more than one and completely different ERP system because a single vendor cannot usually meet every organizational need.
As a result, the options for getting data into and out of an ERP system preclude known approaches used for data warehousing. Each ERP system has a proprietary data model that is constantly being enhanced by its vendor. Writing extract or load routines that manipulate such models is not only complicated, but is also discouraged by the vendor since data validation and business rules inherent in the enterprise application are likely to be bypassed. Instead, ERPs require interaction at the business object level, which deals with specific business entities such as general ledgers, budgets or accounts payable.
In today's rapidly changing environment, the concerted efforts of thousands of developers worldwide are focused on developing a system that satisfies the need for disparate applications to communicate with each other, without the necessity of embedding multiple, customized application-specific translation schemes. This as yet unfulfilled need is grounded in the imperative of the global economy.
The accompanying drawings, which are included as part of the present specification, illustrate the presently preferred embodiment of the present invention and together with the general description given above and the detailed description of the preferred embodiment given below serve to explain and teach the principles of the present invention.
A method and code generator system for integrating different enterprise business applications is disclosed. In one embodiment, a method for integrating a local business system with an external business system, comprises using a code generator to generate integration source code, wherein using a code generator comprises; interrogating a repository containing integration data by an introspector; and using the integration data with a code filter, wherein the filter generates the integration source code.
In the following description, for purposes of explanation, specific nomenclature is set forth to provide a thorough understanding of the present invention. However, it will be apparent to one skilled in the art that these specific details are not required in order to practice the present invention.
Some portions of the detailed descriptions, which follow are presented in terms of algorithms and symbolic representations of operations on data bits within a computer memory. These algorithmic descriptions and representations are the means used by those skilled in the data processing arts to most effectively convey the substance of their work to others skilled in the art. An algorithm is here, and generally, conceived to be a self-consistent sequence of steps leading to a desired result. The steps are those requiring physical manipulations of physical quantities. Usually, though not necessarily, these quantities take the form of electrical or magnetic signals capable of being stored, transferred, combined, compared, and otherwise manipulated. It has proven convenient at times, principally for reasons of common usage, to refer to these signals as bits, values, elements, symbols, characters, terms, numbers, or the like.
It should be borne in mind, however, that all of these and similar terms are to be associated with the appropriate physical quantities and are merely convenient labels applied to these quantities. Unless specifically stated otherwise as apparent from the following discussion, it is appreciated that throughout the description, discussions utilizing terms such as “processing” or “computing” or “calculating” or “determining” or “displaying” or the like, refer to the action and processes of a computer system, or similar electronic computing device, that manipulates and transforms data represented as physical (electronic) quantities within the computer system's registers and memories into other data similarly represented as physical quantities within the computer system memories or registers or other such information storage, transmission or display devices.
The present invention also relates to apparatus for performing the operations herein. This apparatus may be specially constructed for the required purposes, or it may comprise a general purpose computer selectively activated or reconfigured by a computer program stored in the computer. Such a computer program may be stored in a computer readable storage medium, such as, but is not limited to, any type of disk including floppy disks, optical disks, CD-ROMs, and magnetic-optical disks, read-only memories (ROMs), random access memories (RAMs), EPROMs, EEPROMs, magnetic or optical cards, or any type of media suitable for storing electronic instructions, and each coupled to a computer system bus.
The algorithms and displays presented herein are not inherently related to any particular computer or other apparatus. Various general purpose systems may be used with programs in accordance with the teachings herein, or it may prove convenient to construct more specialized apparatus to perform the required method steps. The required structure for a variety of these systems will appear from the description below. In addition, the present invention is not described with reference to any particular programming language. It will be appreciated that a variety of programming languages may be used to implement the teachings of the invention as described herein.
The core of code generator system 200 is code generator 250. Code generator 250 is a business service that provides the ability to yield integration code for customers to embed into their development environment for the purpose of integrating a local and external business system. Code generator 250 introspects (interrogates) repository 260 for pertinent information and depending on user inputs 270, generator 250 yields integration source code 280. Source code 280 is capable of being embedded in local system 205. Code generator 250 provides for the seamless (transparent to the user) integration of the services of external business system 225 into local business system 205. Although not required, code generator 250 may integrate systems, such as SIEBEL® Integration Objects and SIEBEL® Business Services into local system 205. SIEBEL® Integration Objects allow external systems (e.g., SAP®) to obtain or provide data to or from the SIEBEL® Application Environment. SIEBEL® Business Services provide standard or custom-built services for enterprise business. For example, SIEBEL® Business Services provide business logic based on a service's input and data maintained within SIEBEL®'s database.
Code generator 250 includes an introspector 251 and a code filter 252. The introspector 251 is responsible for interrogation of repository 260 and code filter 252 is responsible for generating source code 280. Repository 260 contains all the pertinent information (metadata) required for the integration. Metadata is information that describes the format and content of data stored in repository 260. Interrogation of repository 260 provides the metadata needed to produce source code 280 in the form of an adapter, including any necessary supporting structures. Through the interrogation of repository 260, a canonical form of the selected object (external service) may be produced by introspector 251. The canonical form allows the compression and joining of repository information into a single release to be used by code filter 252.
The following Table 1 shows an example of what business services metadata are used and the information (metadata) obtained form the repository.
business service name, activation flags and
Business Service Method
business service methods name, activation
flags, and associated comments.
Business Service Method
business service method arguments name,
type, usage and comments.
Business Service User
business service method's user level
properties name, type, value and comments.
The following Table 2 shows one embodiment of what integration objects are used and the information (metadata) obtained from the repository 260:
integration object name, activation flags
and associated comments.
integration component name, XML name,
activation flags, parent integration
component, and comments.
Integration Component Field
integration field name, XML name,
activation flags, type, and comments.
The following Table 3 shows the canonical representation of the object (business service from external system 225):
Defines the overall object class contains
Version id for the class
Derived Repository name
Is this class an adapter class to native
Environment? Access rights for the
package/namespace/ . . . name for the
The name of the class
Class level comment (pulled from
Property name for the class, normally
the same as the class name
An array of super classes names (i.e.
who are you derived from)
An array of interfaces names you
An array of attribute declarations
(i.e. Declaration definition array)
An array of method declarations (i.e.
Declaration definition array)
Meta data stating if this class
Only exists for Business Services
Array of arguments.
Based on the exemplary attributes of Table 3, multiple language structures and/or environments (i.e. J2EE, C++ Interfaces and C++ Adapters) can be derived. This canonical form (containing each class definition) is passed on to code filter 252.
Code filter 252 uses the canonical form to add in any language/environment dependent idiosyncrasies. Each code filter 252 may be custom built for a given programming language and/or environment. Utilizing this type of implementation allows a code filter 252 to support multiple programming environments concurrently. By way of example only, a JAVA® Code Filter will be described below. All other code filters would be analogous to the JAVA® Code Filter, by adding specific language dependent idiosyncrasies.
In the case of a JAVA® Filter, code filter 252 would convert the canonical form of a business service to a business service adapter (for an external business service of external business system 225) and a set of JAVA® beans. The adapter provides an interface for interacting with the external business service in a strongly typed interface. The adapter utilizes the set of JAVA® beans produced for input and output method arguments. The following Table 4 shows the two methods invoked by code generator 250.
Generates a list of busi-
ness objects and key
attributes based on some
Which type of business
component you are wishing
to obtain a list for.
Repository name to
Generates source code
files for a given business
object with a given code
Which type of business
component you are wishing
to obtain a list for.
Repository name to
A data storage device 327 such as a magnetic disk or optical disc and its corresponding drive may also be coupled to computer system 300 for storing information and instructions. Computer system 300 can also be coupled to a second I/O bus 350 via an I/O interface 330. A plurality of I/O devices may be coupled to I/O bus 350, including a display device 343, an input device (e.g., an alphanumeric input device 342 and/or a cursor control device 341).
The communication device 340 is for accessing other computers (servers or clients) via a network. The communication device 340 may comprise a modem, a network interface card, or other well known interface device, such as those used for coupling to Ethernet, token ring, or other types of networks.
Flow continues to processing block 420 where a introspector 251 constructs a canonical representation of the metadata by using the extracted metadata and user inputs 270. At processing block 430, the canonical form (or canonical code class definitions) is passed on to code filter 252. Flow continues to process block 440, where code filter 252 adds language/environment dependent idiosyncrasies, for example, specifically for the JAVA® environment. At processing block 460, code filter 252 generates source code 280 that local system 205 integrates into itself as an adapter with supporting mechanisms for the specific language or environment. Flow stops at block 499.
Having detailed how integration code is generated, the use of generated integration source code within local system 205 will be described.
Process 500 begins at start block 501. Flow continues to processing block 505, where a client of local system 205 sets input parameter bean properties (i.e. selecting a method or service of external system 225). At processing block 510, the client invokes an external business service by passing the input bean to a data bean representing the source code adapter 280. Flow continues to processing block 515, where the data bean logs into external system 525.
At processing block 525, the data bean invokes the external business system's method or service. Flow continues to processing block 530, where an object/method/service manager for external system 525 executes the requested method or service, with the input bean parameters specified. At processing block 535, the executed external service or method returns some output properties to the object/method/service manager.
Flow continues to processing block 540, where the object/method/service manager returns the output properties to the Data Bean. At processing block 545 the Data Bean logs off the external system 225. Flow continues to processing block 550, where the output properties are converted to maintain the format and idiosyncrasies of the output bean's properties. At processing block 555, the client receives the converted output properties by the data bean and flow terminates at block 599.
A method and code generator system for integrating different enterprise business applications is disclosed. Although the present invention has been described with respect to specific examples and subsystems, it will be apparent to those of ordinary skill in the art that the invention is not limited to these specific examples or subsystems but extends to other embodiments as well. The present invention includes all of these other embodiments as specified in the claims that follow.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US5432925||4 Aug 1993||11 Jul 1995||International Business Machines Corporation||System for providing a uniform external interface for an object oriented computing system|
|US5497491||26 Jan 1993||5 Mar 1996||International Business Machines Corporation||System and method for importing and exporting data between an object oriented computing environment and an external computing environment|
|US5542078||29 Sep 1994||30 Jul 1996||Ontos, Inc.||Object oriented data store integration environment for integration of object oriented databases and non-object oriented data facilities|
|US5809507||1 Jul 1996||15 Sep 1998||Sun Microsystems, Inc.||Method and apparatus for storing persistent objects on a distributed object network using a marshaling framework|
|US5958004||28 Oct 1997||28 Sep 1999||Microsoft Corporation||Disabling and enabling transaction committal in transactional application components|
|US6125383||11 Jun 1997||26 Sep 2000||Netgenics Corp.||Research system using multi-platform object oriented program language for providing objects at runtime for creating and manipulating biological or chemical data|
|US6253367||18 Nov 1998||26 Jun 2001||Micrografx, Inc.||Method and system for transforming dynamic content for use on the internet|
|US6378003||5 Apr 1993||23 Apr 2002||International Business Machines Corporation||Method and system for deriving metaclasses in an object oriented system|
|US6453356||15 Apr 1998||17 Sep 2002||Adc Telecommunications, Inc.||Data exchange system and method|
|US6574635||3 Mar 1999||3 Jun 2003||Siebel Systems, Inc.||Application instantiation based upon attributes and values stored in a meta data repository, including tiering of application layers objects and components|
|US6601072||21 Jun 2000||29 Jul 2003||International Business Machines Corporation||Method and system for distribution of application data to distributed databases of dissimilar formats|
|US6633889||17 Jan 2001||14 Oct 2003||International Business Machines Corporation||Mapping persistent data in multiple data sources into a single object-oriented component|
|US6654801||4 Jan 1999||25 Nov 2003||Cisco Technology, Inc.||Remote system administration and seamless service integration of a data communication network management system|
|US6668254||21 Dec 2000||23 Dec 2003||Fulltilt Solutions, Inc.||Method and system for importing data|
|US6742175 *||27 Nov 2000||25 May 2004||Codagen Technologies Corp.||Component-based source code generator|
|US7051316 *||20 Apr 2001||23 May 2006||Borland Software Corporation||Distributed computing component system with diagrammatic graphical representation of code with separate delineated display area by type|
|US7257820||9 Apr 2002||14 Aug 2007||Siebel Systems, Inc.||Method and system for using integration objects with enterprise business applications|
|US20020091990 *||4 Oct 2001||11 Jul 2002||Todd Little||System for software application development and modeling|
|US20020095651 *||10 May 2001||18 Jul 2002||Srihari Kumar||Interactive funds transfer interface|
|US20020116698 *||3 May 2001||22 Aug 2002||Marc Lurie||Method for distributing, integrating, and hosting a software platform|
|US20020133812 *||4 Oct 2001||19 Sep 2002||Todd Little||System and method for computer code generation|
|US20040015832 *||25 May 2001||22 Jan 2004||Michael Stapp||Method and apparatus for generating source code|
|US20040015857 *||31 Aug 2001||22 Jan 2004||Accenture Llp.||Remotely managing a data processing system via a communications network|
|US20040060036 *||15 Sep 2003||25 Mar 2004||Kabushiki Kaisha Toshiba||Method for constructing enterprise system|
|US20050160398 *||22 Nov 2004||21 Jul 2005||Bjornson Robert D.||Method and apparatus for dataflow creation and execution|
|US20060015862 *||20 Sep 2005||19 Jan 2006||National Instruments Corporation||Reconfigurable measurement system utilizing a programmable hardware element and fixed hardware resources|
|EP1030254A1||18 Feb 1999||23 Aug 2000||sd&m, Software design & management GbmH & Co. KG||Method and system to manage documents|
|EP1122652A1||30 Jan 2001||8 Aug 2001||Mitsubishi Denki Kabushiki Kaisha||Data Integration system|
|1||*||"An agent-based approach for building complex software systems", N. Jennings, Apr. 2001, pp. 35-41. Online retrieved at .|
|2||*||"Difficulties in integrating multiview development systems", S. Meyers, Jan. 1991, pp. 49-51. Online retrieved at .|
|3||*||"The Java syntactic extender (JSE)", Bachrach et al., Dec. 2001, pp. 31-42. Online retrieved at .|
|4||*||"An agent-based approach for building complex software systems", N. Jennings, Apr. 2001, pp. 35-41. Online retrieved at <http://delivery.acm.org/10.1145/370000/367250/p35-jennings.pdf>.|
|5||*||"Difficulties in integrating multiview development systems", S. Meyers, Jan. 1991, pp. 49-51. Online retrieved at <http://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=62932&isnumber=2296>.|
|6||*||"The Java syntactic extender (JSE)", Bachrach et al., Dec. 2001, pp. 31-42. Online retrieved at <http://delivery.acm.org/10.1145/510000/504285/p31-bachrach.pdf>.|
|7||Sybase; "PowerDesigner® WarehouseArchitect(TM) The Model for Data Warehousing Solutions;" Sybase Technical Paper; (Mar. 29, 1999); pp. 2-19.|
|8||Sybase; "PowerDesigner® WarehouseArchitect™ The Model for Data Warehousing Solutions;" Sybase Technical Paper; (Mar. 29, 1999); pp. 2-19.|
|9||V. Y. Lum et al.; "A General Methodology for Data Conversion and Restructuring;" IBM Journal of Research and Development; International Business Machines Corp.; New York, NY; V. 20; No. 5; (Sep. 1, 1976); pp. 483-497.|
|U.S. Classification||717/107, 717/143, 717/114|
|International Classification||G06F9/44, G06F9/45|
|1 Mar 2011||CC||Certificate of correction|
|28 Aug 2013||FPAY||Fee payment|
Year of fee payment: 4