Rapid application integration using reusable patterns

• US 7,237,225 B2
• Filed: 12/13/2002
• Issued: 06/26/2007
• Est. Priority Date: 08/29/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Foerg, Karl-Heinz, Kompalli, Prasad, Pauly, Heinz
• Primary Examiner(s): An; Meng-Al T.
• Assistant Examiner(s): Roche; Trenton J.
• Application Number:
  US10/318,369
• Publication Number:
  US 20040044986A1
• Time in Patent Office: 1,656 Days
• Field of Search: None
• US Class Current: 717/108
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

Techniques are provided to integrate two or more application systems by using a declarative approach that describes functions or rules to be performed to integrate application systems. Particular integration functions are defined that may be useful for common integration activities. Integration functions may be defined for particular objects and may be assembled to form a declarative business process flow. The declarative business process flow identifies the objects to be exchanged between two or more systems, the sequence of particular transformation functions, the physical field to field transformations required, and the physical connection to be established between the systems. An application integration workstation is described that provides a framework and tools to design, develop and modify (or maintain) application integration software. Such an application integration workstation may reduce the time required to construct or maintain application integration software, which may be referred to as “rapid application integration.”

Claims

1. A computer-implemented method of designing integration software, the method comprising:

specifying an integration design that accomplishes a data transfer between different specified application software systems, wherein;

each of the application software systems includes a database capable of storing data related to business transactions and instructions that, when executed, cause data related to the business transactions to be processed, and that is made up of at least one integration design pattern,

the at least one integration design pattern comprises at least one functional atom that describes at least one of a data processing functional atom, a data persistency functional atom, or a helper functional atom, and

the integration-design specifying including;

receiving user input indicating a selection, from a repository that identifies a set of processes used in data transfers, of integration design patterns needed to accomplish the data transfer between the different specified application software systems; and

receiving user input that specifies a sequence by which the selected integration design patterns are to be performed; and

generating, from the specified integration design, software code that controls the specified data transfer.

2. The method of claim 1 further comprising associating at least one portion of the generated software code with at least one portion of the integration design, each particular portion of the generated software code being associated with a particular portion of the integration design.

3. The method of claim 2 further comprising:

receiving a second user input that identifies a portion of the integration design to be displayed; and

displaying a portion of the generated software code that is associated with the portion of the integration design identified by the second user input.

4. The method of claim 3 further comprising modifying the displayed portion of the generated software code.

5. The method of claim 1 wherein the generated software code comprises generated executable instructions.

6. The method of claim 1 wherein the generated software code comprises a generated template for integration software.

7. The method of claim 1 wherein the at least one integration design pattern includes at least one of a pattern for validating a data collection for mandatory information, a pattern for splitting data from one data collection into separate data collections, a pattern for invoking a key mapping function, a pattern for invoking a data transformation function, a pattern for invoking a connectivity function for a particular application system, and a pattern for invoking a connectivity function for invoking a particular service.

8. The system of claim 1 wherein the at least one integration design pattern decomposes into at least two integration design patterns.

9. The method of claim 1 wherein the data processing functional atom describes at least one of a transformation functional atom, a branch functional atom, an unbranch functional atom, a split functional atom, or a join functional atom.

10. The method of claim 9, wherein the functional atom comprises a transformation functional atom, further comprising:

receiving a data collection and a data transformation rule;

transforming the received data collection by applying the data transformation rule to the received data collection; and

producing a transformed data collection.

11. The method of claim 10 wherein the data transformation rule comprises a transformation rule having multiple transformation components.

12. The method of claim 9 wherein the functional atom comprises a branch functional atom, further comprising:

receiving a data collection;

transforming the received data collection based in data values within the received data collection; and

producing at least one data collection based on the received data collection.

13. The method of claim 9 wherein the functional atom comprises a unbranch functional atom, further comprising:

receiving at least one data collection; and

producing a data collection based on the data collections received.

14. The method of claim 9 wherein the functional atom comprises a split functional atom, further comprising:

receiving a data collection;

transforming the received data collection based on repeating data within the received data collection; and

producing at least one data collection based on the received data collection.

15. The method of claim 9 wherein the functional atom comprises a join functional atom, further comprising:

receiving at least one data collection with each data collection including a particular type of data; and

producing a data collection based on the at least one data collection received.

16. The method of claim 9 wherein the functional atom comprises a validate functional atom, further comprising:

receiving a data collection and a data validation rule,

validating the received data collection by applying the validation rule to the received data collection; and

producing a validation result.

17. The method of claim 16 wherein the data validation rule comprises a data validation rule having multiple validation components.

18. The method of claim 1 wherein the functional atom comprises one or more of a call atom or an include atom.

19. The method of claim 18, wherein the functional atom comprises a call atom, further comprising:

receiving an identification of executable software; and

executing the identified executable software.

20. The method of claim 18, wherein the functional atom comprises an include atom, further comprising:

receiving an identification of a second functional atom; and

executing the second functional atom.

21. A computer-implemented method of designing integration software, the method comprising:

specifying an integration design that accomplishes a data transfer between different specified application software systems, wherein;

each of the application software systems includes a database capable of storing data related to business transactions and instructions that, when executed, cause data related to the business transactions to be processed, and that is made up of at least one integration design pattern,

the at least one integration design pattern comprises at least one functional atom that describes at least one of a data processing functional atom, a data persistency functional atom, or a helper functional atom, and

the integration-design specifying including;

receiving user input indicating a selection, from a repository that identifies a set of processes used in data transfers, of integration design patterns needed to accomplish the data transfer between the different specified application software systems; and

receiving user input that specifies a sequence by which the selected integration design patterns are to be performed;

generating, from the specified integration design, software code that controls the specified data transfer; and

associating at least one portion of the generated software code with at least one portion of the integration design, each particular portion of the generated software code being associated with a particular portion of the integration design.

22. The method of claim 21 wherein the at least one integration design pattern includes at least one of a pattern for validating a data collection for mandatory information, a pattern for splitting data from one data collection into separate data collections, a pattern for invoking a key mapping function, a pattern for invoking a data transformation function, a pattern for invoking a connectivity function for a particular application system, and a pattern for invoking a connectivity function for invoking a particular service.

23. A computer-readable medium having embodied thereon a computer program configured to design integration software, the medium comprising at least one code segment configured to:

specify an integration design that accomplishes a data transfer between different specified application software systems, wherein;

each of the application software systems includes a database capable of storing data related to business transactions and instructions that, when executed, cause data related to the business transactions to be processed, and that is made up of at least one integration design pattern,

the at least one integration design pattern comprises at least one functional atom that describes at least one of a data processing functional atom, a data persistency functional atom, or a helper functional atom, and

the integration-design specifying including;

receiving user input indicating a selection, from a repository that identifies a set of processes used in data transfers, of integration design patterns needed to accomplish the data transfer between the different specified application software systems; and

receiving user input that specifies a sequence by which the selected integration design patterns are to be performed; and

generating, from the specified integration design, software code that controls the specified data transfer.

24. The medium of claim 23 the at least one code segment is further configured to associate at least one portion of the generated software code with at least one portion of the integration design, each particular portion of the generated software code being associated with a particular portion of the integration design.

25. The medium of claim 23 wherein the at least one integration design pattern includes at least one of a pattern for validating a data collection for mandatory information, a pattern for splitting data from one data collection into separate data collections, a pattern for invoking a key mapping function, a pattern for invoking a data transformation function, a pattern for invoking a connectivity function for a particular application system, and a pattern for invoking a connectivity function for invoking a particular service.

26. A system for designing integration software, the system comprising a processor connected to a storage device and at least one input/output device, wherein the processor is configured to:

specify an integration design that accomplishes a data transfer between different specified application software systems, wherein;

each of the application software systems includes a database capable of storing data related to business transactions and instructions that, when executed, cause data related to the business transactions to be processed, and that is made up of at least one integration design pattern,

the at least one integration design pattern comprises at least one functional atom that describes at least one of a data processing functional atom, a data persistency functional atom, or a helper functional atom, and

the integration-design specifying including;

receiving user input indicating a selection,.from a repository that identifies a set of processes used in data transfers, of integration design patterns needed to accomplish the data transfer between the different specified application software systems; and

receiving user input that specifies a sequence by which the selected integration design patterns are to be performed; and

generating, from the specified integration design, software code that controls the specified data transfer.

27. The system of claim 26 wherein the processor is further configured to associate at least one portion of the generated software code with at least one portion of the integration design, each particular portion of the generated software code being associated with a particular portion of the integration design.

28. The system of claim 26 wherein the at least one integration design pattern includes at least one of a pattern for validating a data collection for mandatory information, a pattern for splitting data from one data collection into separate data collections, a pattern for invoking a key mapping function, a pattern for invoking a data transformation function, a pattern for invoking a connectivity function for a particular application system, and a pattern for invoking a connectivity function for invoking a particular service.

29. A system for designing integration software comprising:

a computing workstation comprising a processor connected to a storage device and at least one input/output device, wherein the processor is configured to enable a user to design integration software to perform data transfers between different application software systems, wherein each of the application software systems includes a database capable of storing data related to business transactions and instructions that, when executed, cause data related to the business transactions to be processed; and

a repository accessible by the computing workstation and comprising a library of integration design patterns, each integration design pattern declaratively describing a standard process used in a data transfer, wherein;

the user is able to select one or more integration design patterns and use them to construct a software design that performs a specified data transfer between different specified application software systems, and

the library of integration design patterns comprises at least one functional atom that describes at least one of a data processing functional atom, a data persistency functional atom, or a helper functional atom.

30. The system of claim 29 wherein the library of integration design patterns comprises at least one of a pattern for validating a data collection for mandatory information, a pattern for splitting data from one data collection into separate data collections, a pattern for invoking a key mapping function, a pattern for invoking a data transformation function, a pattern for invoking a connectivity function for a particular application system, and a pattern for invoking a connectivity function for invoking a particular service.