Rapid application integration using an integrated development environment

• US 7,213,227 B2
• Filed: 12/13/2002
• Issued: 05/01/2007
• Est. Priority Date: 08/29/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kompalli, Prasad, Pauly, Heinz, Foerg, Karl-Heinz
• Primary Examiner(s): An; Meng-Al T.
• Assistant Examiner(s): ROCHE, TRENTON J
• Application Number:
  US10/318,356
• Publication Number:
  US 20040044985A1
• Time in Patent Office: 1,600 Days
• Field of Search: 717/109, 717/113
• US Class Current: 717/108
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54
• CPC Class Codes: H04L 67/565 Conversion or adaptation of application format or content adding application control or application functional data H04L67/561
• CPC Class Codes: H04L 67/567 Integrating service provisioning from a plurality of service providers
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]

Abstract

Techniques are provided to integrate two or more application systems by using an 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 a service connection over which a data transfer between different application software systems is to occur, 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

the service-connection specifying including;

receiving, at a computer workstation, user input indicating a selection, from a repository accessible by the workstation that identifies a landscape of possible application software systems that may be selected, of a first service and associated application software system to be involved in the data transfer; and

receiving, at the workstation, user input indicating a selection, from the repository, of a second service and associated application software system to be involved in the data transfer;

specifying an integration design that accomplishes the data transfer between the application software systems and that is made up of at least one integration design pattern, 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 specified data transfer between the application software systems via the specified service connection; and

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

generating software code that controls the data transfer via the specified service connection and performs the selected integration design patterns in the specified sequence.

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 a 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 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 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.

10. The method of claim 9 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.

11. The method of claim 10, wherein the functional atom comprises a transformation on 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.

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

13. The method of claim 10 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.

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

receiving two or more data collections; and

producing a data collection based on the two or more data collections received.

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

receiving a data collection;

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

producing two or more data collections based on the received data collection.

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

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

producing a data collection based on the two or more data collections received.

17. The method of claim 10 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.

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

19. The method of claim 9 wherein the functional atom comprises a call atom, an include atom, or both a call atom and an include atom.

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

receiving an identification of executable software; and

executing the identified executable software.

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

receiving an identification of a second functional atom; and

executing the second functional atom.

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

specifying a service connection over which a specified data transfer between different application software systems is to occur, 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

the service-connection specifying including;

receiving, at a computer workstation, user input indicating a selection, from a repository accessible by the workstation that identifies a landscape of possible application software systems that may be selected, of a first service and associated application software system to be involved in the data transfer; and

receiving, at the workstation, user input indicating a selection, from the repository, of a second service and associated application software system to be involved in the data transfer;

specifying an integration design that accomplishes the data transfer between the application software systems and that is made up of at least one integration design pattern, 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 application software systems via the specified service connection; 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 data transfer function via the specified service connection; 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.

23. The method of claim 22 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.

24. The method of claim 22 wherein 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.

25. 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 a service connection over which a data transfer between different application software systems is to occur, 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

the service-connection specifying including;

receiving, at computer workstation, user input indicating a selection, from a repository accessible by the workstation that identifies a landscape of possible application software systems that may be selected, of a first service and associated application software system to be involved in the data transfer, and

receiving, at the workstation, user input indicating a selection, from the repository, of a second service and associated application software system to be involved in the data transfer;

specify an integration design that accomplishes the data transfer, between the application software systems, and that is made up of at least one integration design pattern, the integration-design specifying including;

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

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

generating software code that controls the data transfer via the specified service connection and performs the selected integration design patterns in the specified sequence.

26. The medium of claim 25 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.

27. The medium of claim 25 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.

28. The medium of claim 25 wherein 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.

29. 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 a service connection over which a data transfer between different application software systems is to occur, 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

the service-connection specifying including;

receiving, at a computer workstation, user input indicating a selection, from a repository accessible by the workstation that identifies a landscape of possible application software systems that may be selected, of a first service and associated application software system to be involved in the data transfer; and

receiving, at the workstation, user input indicating a selection, from the repository, of a second service and associated application software system to be involved in the data transfer;

specify an integration design that accomplishes the data transfer between the application software systems and that is made up of at least one integration design pattern, 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 application software systems, via the specified service connection; and

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

generating software code that controls transfer via the specified service connection and performs the selected integration design patterns in the specified sequence.

30. The system of claim 29 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.

31. The system of claim 29 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.

32. The system of claim 29 wherein 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.