PeopleSoft to PeopleSoft Integration through Integration Broker

Before you begin reading this article, you must know - Fundamentals of PeopleSoft Integration Broker

In this we will see what are the steps to integrate one PeopleSoft Application with another one and will do it for the same scenario we talked about in the article Fundamentals of PeopleSoft Integration Broker. In this example, the PeopleSoft FIN system is the source system and the PeopleSoft HCM system is the destination system.

On a very broad level, this is what we are going to configure:

• The integration gateway.

• The PeopleSoft Finance system.

• The PeopleSoft HR system.

Configuring the Integration Gateway

The only required property that you must set for the local gateway is the Oracle Jolt connect

strings that enable the gateway to find the PeopleSoft HR system. Set this property in the

integrationGateway.properties file.

So, open the integrationGateway.properties file on Web Server and update the Jolt Connect String. You can open this file from below highlighted link on Gateway Component in PeopleSoft Finance System.

Configuring the PeopleSoft Finance System

Perform the following tasks on the PeopleSoft Finance system:

Local Gateway

Define the local integration gateway in the PeopleSoft Finance system by using the

Gateways component.

Any integration gateway that you've installed and configured to find the PeopleSoft HR system can

serve this role. Specify the gateway's PeopleSoft listening connector as the gateway's URL.

Note that the Local Gateway setup will be same in both Finance and HR system.

Related Articles:

Fundamentals Of PeopleSoft Integration Broker

PeopleSoft to Third Party Integration Through Web Services

Message

Define the message from the navigation PeopleTools - Integration Broker - Integration Setup - Message. This should reflect the rowset structure of Bank Account component in HR system because this structure will be used to transmit data to HR.

Handler

Define the handler using Application Designer. Since in our case the Finance System is a sender and there is only one way communication so only a dummy Application Package and Class is required with no Processing Logic written in it.

Routing

Routing is where we define the following:

• One way communication or two way (In our case its One Way)
• Synchronous or Asynchronous (In our case its Asynchronous)
• The sender and receiver nodes (In our case PS Finance is Sender and PS HR is Receiver)

Navigation: PeopleTools -Integration Broker - Integration SetUp - Routing

Service Operation

It ties previous three elements - Message, Handler and Routing together and forms a mechanism for integration. Define the service operation and add those three elements in it.

Navigation: PeopleTools -Integration Broker - Integration SetUp - Service Operation

Node

Define two nodes, one for HR system and another for Finance system. The Finance Node in this case would be local and HR Node would be remote.

• Also mention followings in node definition:
• Connectors (Gateway and Target Connector)
• Portal URLs (PIA URL)
• Routing (Add the routing definition defined above)

The node definition can be same across PS to PS integration because it represents the whole system.
Navigation - PeopleTools -Integration Broker - Integration SetUp - Node

Configuring the PeopleSoft HR System

Perform the following tasks on the PeopleSoft HR system:

Local Gateway

As already mentioned, the Local Gateway in both systems will have same configurations.

Message 

Define the message from the navigation PeopleTools - Integration Broker - Integration Setup - Message. This should reflect the rowset structure of Bank Account component in Finance system because this structure will be used to read data sent from Finance system.

Handler

The handler in HR system would contain the actual processing logic since it has to read data sent from Finance and load into tables.
Its basically an application package containing a class definition which has the processing logic written in PeopleCode to read the data (Bank Account Changes).

Routing

Routing is where we define the following:

• One way communication or two way (In our case its One Way)
• Synchronous or Asynchronous (In our case its Asynchronous)
• The sender and receiver nodes (In our case PS Finance is Sender and PS HR is Receiver)

Navigation: PeopleTools -Integration Broker - Integration SetUp - Routing

Service Operation

It ties previous three elements - Message, Handler and Routing together and forms a mechanism for integration. Define the service operation and add those three elements in it.

Navigation: PeopleTools -Integration Broker - Integration SetUp - Service Operation

Node

Define two nodes, one for HR system and another for Finance system. The HR Node in this case would be local and Finance Node would be remote.

• Also mention followings in node definition:
• Connectors (Gatway and Target Connector)
• Portal URLs (PIA URL)
• Routing (Add the routing definition defined above)

The node definition can be same across PS to PS integration because it represents the whole system.
Navigation - PeopleTools -Integration Broker - Integration SetUp - Node

Related Articles:

Fundamentals Of PeopleSoft Integration Broker

PeopleSoft to Third Party Integration Through Web Services