Method and computer program product for integrating a first application providing a B2B gateway and one or more second applications

• US 8,850,454 B2
• Filed: 07/11/2011
• Issued: 09/30/2014
• Est. Priority Date: 11/30/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Boullery, Didier, Dumont, Christophe
• Primary Examiner(s): Ho, Andy
• Assistant Examiner(s): Mudrick, Timothy A
• Application Number:
  US13/179,690
• Publication Number:
  US 20120137304A1
• Time in Patent Office: 1,177 Days
• Field of Search: 719/313
• US Class Current: 719/313
• CPC Class Codes: G06F 9/44526 Plug-ins; Add-ons
• CPC Class Codes: G06F 9/54 Interprogram communication
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

The invention provides for a method and computer program product for integrating an e-business service application being provided by a B2B server and one or more other remote applications by means of an Entity-Relationship model.

Claims

1. A computer-implemented method for integration of a first application and a second application, the first application comprising an e-business service application and being provided by a business-to-business (B2B) server, the B2B server being accessible via one or more B2B gateways, the first application running on a first computer system, the second application running on a second computer system, the method comprising:

integrating an Entity-Relationship model of the first application in a plug-in of the second application, the plug-in of the second application communicating with the one or more B2B gateways, the plug-in comprising one or more integrated Entity-Relationship models, one or more mappings, a mapping engine, and one or more plug-in interfaces for communicating with the one or more B2B gateways;

displaying, by the plug-in, graphical user interface components representing elements of the integrated Entity-Relationship model to a user of the second application;

wherein the graphical user interface components;

enable specification of a mapping provided via the mapping engine of the plug-in of one or more placeholders of an electronic document of the second application to one or more elements of the Entity-Relationship model, whereby each placeholder is a container for one or more data values, and

enable flexible adapting of the specified mapping to an updated version of the Entity-Relationship model or to changes in an arrangement of the data values within the electronic document; and

submitting a message, by the plug-in, to the B2B server via one of the one or more B2B Gateways, the message comprising the one or more mapped data values and information regarding which element of the Entity-Relationship model the one or more data values were mapped to.

2. The computer-implemented method of claim 1, wherein the mapping is specified by a user by assigning the graphical user interface components to one or more placeholders being contained in the electronic document.

3. The computer-implemented method of claim 1, further comprising:

receiving the message by a receiver instance, the receiver instance being the B2B server or the first application, and storing the received message to a data storage by the receiver instance;

executing one or more program routines using data of the received message as input, to provide transactional data;

storing the transactional data in association with the message;

receiving a request for the transactional data, the request being submitted by the plug-in and being received by the receiver instance;

sending, in response to the receipt of the request, the requested transactional data from the receiver instance to the plug-in; and

upon receipt of the requested transactional data by the plug-in, automatically updating the electronic document by the plug-in.

4. A computer-implemented method for integration of a first application and a second application, the first application comprising an e-business service application and being provided by a business-to-business (B2B) server, the B2B server being accessible via one or more B2B gateways, the first application running on a first computer system, the second application running on a second computer system, the method comprising:

providing an Entity-Relationship model for integration into a plug-in of the second application, the Entity-Relationship model being provided by the first application, the plug-in of the second application communicating with the one or more B2B gateways, the plug-in comprising one or more integrated Entity-Relationship models, one or more mappings, a mapping engine, and one or more plug-in interfaces for communicating with the one or more B2B gateways;

receiving a model update request from the plug-in;

submitting an updated Entity Relationship model version from the first application to the plug-in in response to the receipt of the model update request; and

receiving a message comprising an Entity-Relationship model instance from the plug-in by the first application, the received Entity-Relationship model instance comprising one or more data values mapped via the mapping engine of the plug-in to elements of the updated Entity-Relationship model version.

5. The computer-implemented method of claim 4, further comprising:

providing a model format specification for integration into the plug-in, the model format specification indicating a model format, the model format being interpretable by the first application, wherein the Entity-Relationship model and the model format specification are provided by the B2B server or the first application;

wherein the received Entity-Relationship model instance is formatted according to the model format specification integrated into the plug-in.

6. The computer-implemented method of claim 4, wherein integrating the Entity-Relationship model into the plug-in comprises:

integrating the Entity-Relationship model in the plug-in and transferring the plug-in after the integration to the second computer system, the second computer system having installed the second application, or by

transferring the plug-in to the second computer system, the second computer system having installed the second application, transferring the Entity-Relationship model from the first application to the plug-in at the second computer system, and integrating the Entity-Relationship model in the plug-in at the second computer system.

7. The computer-implemented method of claim 4, further comprising:

storing the received message by a receiver instance, the receiver instance being the first application or the B2B server, to a data storage coupled to the first computer system;

storing transactional data in association with the message, wherein the transactional data comprises one of;

data generated by the receiver instance in response to the receipt of the message, or data generated previously by the receiver instance and identified as requested data by analyzing the received message;

receiving a request submitted by the plug-in for the transactional data, the request being received by the first application; and

sending, in response to the receipt of the request, the requested transactional data to the plug-in.

8. A computer program product stored on a computer readable hardware device, which when executed, performs a method for integration of a first application and a second application, the first application comprising an e-business service application and being provided by a business- to-business (B2B) server, the B2B server being accessible via one or more B2B gateways, the first application running on a first computer system, the second application running on a second computer system, the method comprising:

providing an Entity-Relationship model for integration into a plug-in of the second application, the Entity-Relationship model being provided by the first application, the plug-in of the second application communicating with the one or more B2B gateways, the plug-in comprising one or more integrated Entity-Relationship models, one or more mappings, a mapping engine, and one or more plug-in interfaces for communicating with the one or more B2B gateways;

receiving a model update request from the plug-in;

submitting an updated Entity Relationship model version from the first application to the plug-in in response to the receipt of the model update request; and

receiving a message comprising an Entity-Relationship model instance from the plug-in by the first application, the received Entity-Relationship model instance comprising one or more data values mapped via the mapping engine of the plug-in to elements of the updated Entity-Relationship model version.

9. A computer-implemented method for the integration of a first application and a second application, the first application comprising an e-business service application and being provided by a business-to-business (B2B) server, the B2B server being accessible via one or more B2B gateways, the first application running on a first computer system, the second application running on a second computer system, the method comprising:

displaying, by a plug-in, graphical user interface components representing elements of an Entity-Relationship model to a user of the second application, the Entity-Relationship model comprising an Entity-Relationship model of the first application, the plug-in being interoperable with the second application, the plug-in communicating with the one or more B2B gateways, the plug-in comprising one or more integrated Entity-Relationship models, one or more mappings, a mapping engine, and one or more plug-in interfaces for communicating with the one or more B2B gateways,

wherein the graphical user interface components;

enable specification of a mapping provided via the mapping engine of the plug-in of one or more placeholders of an electronic document of the second application to one or more elements of the Entity-Relationship model, wherein each placeholder is a container for one or more data values; and

enable flexible adapting of the specified mapping to an updated version of the Entity-Relationship model or to changes of an arrangement of the data values within the electronic document; and

submitting a message, by the plug-in, to the B2B server via one of the B2B Gateways, the message comprising the one or more mapped data values and information regarding which element of the Entity-Relationship model the one or more data values were mapped to.

10. The computer-implemented method of claim 9, wherein the plug-in executes model instance integrity checks, the checks comprising at least one of data type correctness checks, data consistency checks, and remote checks.

11. The computer-implemented method of claim 9, wherein n messages are created by the plug-in, n being an integer larger than 0, the method further comprising:

storing, for each n, a mapping by the plug-in, each mapping specifying one or more placeholders of the electronic document and elements of the Entity-Relationship model to which the placeholders were mapped, wherein each placeholder is a container for one or more data values;

for each of the n stored mappings, automatically executing a parsing step, each parsing step specifying a message by determining one or more placeholders and data values contained therein having been mapped to one or more elements of the Entity-Relationship model according to the stored mapping, the parsing being executed by the plug-in; and

submitting, for each of the n stored mappings, a message from the plug-in to the first computer system, each message comprising the at least one mapped data value and information to which element of the Entity-Relationship model the data value was mapped to according to the stored mapping.

12. The computer-implemented method of claim 9, wherein the plug-in is operable to transform an Entity-Relationship model instance into one or more different model formats, the method further comprising:

reading, by the plug-in, one predefined model format identifier from plug-in configuration data;

providing the read model format identifier to a mapping engine of the plug-in, the mapping engine being operable to transform the Entity-Relationship model instance into one or more different model formats; and

transforming the Entity-Relationship model instance into a model format identified by the provided model format identifier, the model format being interpretable by the first application.

13. The computer-implemented method of claim 9, the method further comprising:

submitting a request for transactional data stored in association with the message, the request being submitted by the plug-in to the first application or the B2B server;

receiving, by the plug-in, the requested transactional data from the first application; and

upon receipt of the requested transactional data by the plug-in, automatically updating, by the plug-in, the first electronic document, wherein the updating comprises adding, modifying, or deleting data values of the first electronic document in dependence on the received transactional data.

14. The computer-implemented method of claim 13, wherein the plug-in stores the received transactional data in the electronic document, and wherein a copy of the submitted message is stored in the electronic document.

15. A computer program product stored on a computer readable hardware device, which when executed, performs a method for integration of a first application and a second application, the first application comprising an e-business service application and being provided by a business-to-business (B2B) server, the B2B server being accessible via one or more B2B gateways, the first application running on a first computer system, the second application running on a second computer system, the method comprising:

displaying, by a plug-in, graphical user interface components representing elements of an Entity-Relationship model to a user of the second application, the Entity-Relationship model comprising an Entity-Relationship model of the first application, the plug-in being interoperable with the second application, the plug-in communicating with the one or more B2B gateways, the plug-in comprising one or more integrated entity relationship models, one or more mappings, a mapping engine, and one or more plug-in interfaces for communicating with the one or more B2B gateways,

wherein the graphical user interface components;

enable specification of a mapping provided via the mapping engine of the plug-in of one or more placeholders of an electronic document of the second application to one or more elements of the Entity-Relationship model, wherein each placeholder is a container for one or more data values; and

enable flexible adapting of the specified mapping to an updated version of the Entity-Relationship model or to changes of an arrangement of the data values within the electronic document; and

submitting a message, by the plug-in, to the B2B server via one of the B2B Gateways, the message comprising the one or more mapped data values and information regarding which element of the Entity-Relationship model the one or more data values were mapped to.