![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
TIBCO ActiveMatrix Adapter for PeopleSoft uses PeopleSoft application messages as schemas for formatting and processing data between a PeopleSoft application and the TIBCO environment. PeopleSoft application messages must be prepared so the design-time adapter can download them to the adapter’s configuration tool, TIBCO Designer.
• Check the Message definition in PIA to determine the required fields and valid values to be sent to PeopleSoft.
• Eliminate any unnecessary records and fields from the message. The simpler the message, the easier it is to set up and test the adapter.
• The preparation steps given in this chapter assume you know PeopleSoft procedures. For complete information about creating messages and making them available, go to the PeopleSoft website and follow the Peoplebook-PeopleTools link to “Integration Tools: PeopleSoft Integration Broker.”Before configuring the adapter, you must set up the Integration Broker based on the services you will configure in the TIBCO environment.
2. Navigate to PeopleTools > Integration Broker > Configuration > Gateways on the Menu navigation frame. The Gateways pane appears on the right.Figure 4 The Gateways Pane
3. Figure 5 Gateway Information
4. Click the Ping Gateway button to make sure that PeopleSoft Listening Connector is active. In the URL field, enter the specified URL from where Gateway Connectors will be loaded, and then click the Load Gateway Connectors button. All loaded Gateway Connectors are shown in the Connectors area, as shown in Figure 6.Figure 6 Gateway Connectors
5.
a. Connector ID: TIBCOTARGET
b. Connector Class Name: TibcoTargetConnector
6.
Table 2 TIBCOTARGET Connector Properties JMS_Server:port_no
For example 127.0.0.1:7222
HTTPTARGET connector can be used by IB Publication Service, IB Subscription Service and Request-Response Invocation service.TIBCOTARGET connector can be used by IB Publication and Request-Response Invocation Service.Message definitions provide the physical description of the data that is being sent, including fields, field types, and field lengths. Refer to PeopleTools PeopleBook for more information.
2. Navigate to PeopleTools >Integration Broker > Integration Setup > Messages on the Menu navigation frame. The Message Builder pane appears on the right.
3. Click the Find an Existing Value tab on the Message Builder pane. For example, if you want to find a message whose name begins with COUNTRY, enter COUNTRY in the Message Name: begins with field, as shown in Figure 7. If you can not find the desired message, create a new message in the Adding a New Value tab. Refer to PeopleTools PeopleBook for more information.Figure 7 The Message Builder PaneA Message Queue isolates different groups of service operations from each other. It needs to be created exclusively to handle messages meant for the adapter. You can also choose an existing Message Queue. If a message does not exist for a record from which data is to be exported, it needs to be created. Modifications to the existing Messages might be required.PeopleSoft Integration Broker enables you to take an existing component interface and create a service which can be used to invoke the component interface.
2. Navigate to PeopleTools > Integration Broker > Integration Setup > Services on the Menu navigation frame. The Services page appears on the right.
3. Figure 8 Service Information
4. Enter the Description for the Service. To learn how to define Service Operations for the service, refer to Defining Service Operations. See PeopleTools PeopleBook for more information.
5. Click the Save button to save the changes. The specified service is created.A service operation definition consists of general information about an operation, such as its name, description, and so on. It also specifies an operation type, which determines how the operation is to be processed, synchronously or asynchronously. In addition, it contains routings which determine the direction, inbound or outbound, of the service operation. A service operation has one or more handlers, which contain and run the programming logic for sending or receiving the message, manipulating message content, and other functions.
2. Navigate to PeopleTools > Integration Broker > Integration Setup > Service Operations on the Menu navigation frame.
3. Click the Add Service Operation tab on the right page. Enter the Service name and the Service Operation name in the corresponding fields. Next, select an operation type from the Operation Type drop-down list, and then click the ADD button. The information for the service operation needs to be filled in on the next page. Refer to PeopleTools PeopleBook for more information..
If using the Message Subscription Service and Message Publication Service, select Asynchronous - One Way as the Operation Type.If using the Message Request Response Invocation Service, select Synchronous as the Operation Type.
If using the Message Subscription Service and Message Publication Service, select Asynchronous - One Way as the Operation Type.If using the Message Request Response Invocation Service, select Synchronous as the Operation Type.Nodes represent any organization, application or system that will play a part in integrations. For example, nodes can represent customers, business units, suppliers, other trading partners, external or third-party software systems, and so on. Node definitions define the locations to or from which messages can be routed. Because an application can send messages to itself, a default local node definition that represents the application is delivered as part of the integration engine. Each PeopleSoft installation must have one, and only one, default local node.
2. Navigate to PeopleTools > Integration Broker > Integration Setup > Nodes on the Menu navigation frame.
3. Click the Add a New Value tab on the right page. Enter the Node Name, and then click the Add button to open the next page.
4. Figure 9 Node Definitions
5. Click the Connectors tab and define the connectors.
The steps to define a connector are the same for all adapter services. However, the Connector ID will change depending on the adapter service selected. Refer to Configuration Procedure for Adapter Services for detailed information.Based on the adapter service selected, choose the appropriate Target Connector. The Integration Broker allows you to customize target connectors. TIBCOTARGET Connector is a connector defined by TIBCO that is installed on the Integration Gateway. TIBCOTARGET Connector facilitates the exchange of JMS messages between PeopleSoft and the adapter.
While installing the adapter, you need to use an unzip utility, such as Winzip or WinRAR, to extract the TIBCOTARGETConnector.jar file, and then copy the extracted *.class files from the directory Adapter_HOME\data\TibcoTargetConnector\com\peoplesoft\pt\integrationgateway\targetconnector to the following location in the Web Server:
PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSIGW\WEB-INF\classes\com\peoplesoft\pt\integrationgateway\targetconnector.PS_HOME\webserv\peoplesoft\applications\peoplesoftThe JRE version used by the tibjms.jar file must be equal or lower than the JRE version used by PeopleSoft, otherwise, PeopleSoft application cannot send to or receive messages from TIBCO EMS QUEUE or TOPIC.Routing definitions determine the sender and receiver of an integration. Routing definitions allow you to specify inbound and outbound transformations that enable you to transform data structures into those that the sending or receiving systems can understand.
2. Navigate to PeopleTools > Integration Broker > Integration Setup > Routings on the Menu navigation frame.
3. Click the Add a New Value tab on the right page. Enter the Routing Name, and then click the Add button to open the next page.
4. Figure 10 Routing Definitions
5. Click the Save button to save the definition.
1. Navigate to PeopleTools > Integration Broker > Configuration > Quick Configuration on the Menu navigation frame. The Integration Broker Quick Configuration pane appears on the right.
b.
2. Navigate to PeopleTools > Integration Broker > Configuration > Service Configuration on the Menu navigation frame and then make sure that the value in the Target Location field is valid.The basic steps listed in Preparing PeopleSoft Application Messages is the same for all adapter services, but the values assigned to certain parameters will differ based on the adapter services configured. Detailed information for each adapter service will be introduced in this section.If you have selected a subscriber transport type while configuring the adapter, you may perform the following procedure:
2. Load Gateway connectors. Refer to Loading Gateway Connectors for detailed information.
a. If you have selected HTTP transport type in the adapter, you may use the default gateway LOCAL, and then add a connector entry HTTPTARGET into it. Click the Properties link for HTTPTATRGET Connector to open the Connector Properties pane and add the properties listed in Table 3 for the connector.
b. If you have selected JMS transport type, you may use the default gateway LOCAL and then add a connector entry TIBCOTARGET into it. Click Properties of TIBCOTATRGET Connector to open the Connector Properties pane and add the properties listed in Table 2 for the connector.
3. To define a message, refer to Defining Messages. For example, if you have defined a message named COUNTRY_SYNC for the service, you can click on it to see its definition, as shown in Figure 11. Or, you can just use the pre-defined message.Figure 11 COUNTRY_SYNC Message
4. To define services, refer to Defining Services. If you have defined the COUNTRY_SYNC message from step 3, then you can defined a service based on it, as shown in Figure 12. Or, you can just use the pre-defined message and the related service that PeopleSoft delivered, such as COUNTRY_SYNC service.Figure 12 COUNTRY_SYNC Service
5. To define service operations, refer to Defining Service Operations. If you have defined COUNTRY_SYNC service in step 4, enter a service operation name, such as COUNTRY_SYNC, in the Service Operation name and select Asynchronous - One Way from the Operation Type drop-down list. Click the ADD button to create the new service operation, as shown in Figure 13.
6. To define a node, for example TIB_NODE, enter the following Connection Properties. Refer to Defining Nodes for more information.PRIMARYURL: Specify the URL for the HTTP Listening Connector of the adapter. For example, http://127.0.0.1:2002JMSQueue: Use this property only if you have selected Queue to be the Connection Factory Type in the SubscriberOptions tab of the adapter in TIBCO Designer.JMSTopic: Use this property only if you have selected Topic to be the Connection Factory Type in the SubscriberOptions tab of the adapter. The value of JMSTopic in PIA should match the subscriber subject under the SubscriberOptions tab in TIBCO designer.JMSUrl: Enter the URL for the TIBCO Enterprise Message Server (EMS). For example, 127.0.0.1:7222serviceType: Publisher
To configure routings, you need to correctly set the sender node and the receiver node. For example, the sender node can be PSFT_HR in PeopleTools 8.49 and the receiver node can be TIB_NODE defined in the previous step.After performing the configuration for the adapter in PeopleSoft Application, you need to follow these steps in PeopleSoft Application Designer.
2. Select File > Open to open the Open Definition dialog, and then select Component from the Definition drop-down list. Type the component name, such as COUNTRY_TABLE in the Name field and then click the Open button to open the component definition pane.
3. With the component definition open, select View > View PeopleCode.
4. When the PeopleCode Editor appears, leave the component name as is in the left hand side drop-down list and select the SavePostChange event from the right hand side drop-down list.
5. In the PeopleCode Editor, paste the PeopleCode given below. If there are any existing lines of PeopleCode, you should comment them first and then append the code given below.Replace the %message_name% with the corresponding message name without any quotes. (This PeopleCode will go into the SavePostChange event for the required Component)If you have selected a transport while configuring the adapter, you may perform the following procedure:
2. Load Gateway connectors. Refer to Loading Gateway Connectors for detailed information.
a. If you have selected HTTP as the subscriber transport type in TIBCO Designer, you may use the default gateway LOCAL, and then add a connector entry HTTPTARGET into it. Click the Properties link for HTTPTATRGET Connector to open the Connector Properties pane and add the properties listed in Table 4 for the connector.
b. If you have selected JMS as the subscriber transport type in TIBCO Designer, you may use the default gateway LOCAL, and then add a connector entry JMSTARGET into it. Click Properties of TIBCOTARGET Connector to open the Connector Properties pane and configure the properties listed in Table 5 for the connector. The JMSQueue name IBSUB.QUEUE should differ with the queue name of the Message Subscription Service in TIBCO designer.
Note: Ensure that you have created a queue IBSUB.QUEUE in your adapter. For example 127.0.0.1:7222
3. To define a message, refer to Defining Messages. For example, if you have defined a message named CURRENCY_SYNC for the service, you can click on it to see its definition, as shown in Figure 14.Figure 14CURRENCY_SYNC Message
4. To define services, refer to Defining Services. If you have defined a message named CURRENCY_SYNC in step 3, now define a service named CURRENCY_SYNC, as shown in Figure 15.Figure 15 CURRENCY_SYNC Service
5. Define service operations. If you have defined CURRENCY_SYNC service in step 4, enter a service operation name, such as CURRENCY_SYNC, in the Service Operation name and select Asynchronous - One Way from the Operation Type drop-down list. Click the ADD button to create the new service operation, as shown in Figure 16.
Your service operation name has to be the same as your message name. For example, if your message name is CURRENCY_SYNC, your service operation name must also be CURRENCY_SYNC.
6. To define a node, for example TIB_NODE, enter the following Connection Properties. You can also refer to Defining Nodes.
a. If you have selected HTTPTARGET in the previous step, modify the following properties:PrimaryURL: Specify the URL for the HTTP Listening Connector of the adapter. For example, http://127.0.0.1:2002
b. If you have selected JMSTarget in the previous step, modify the following properties:JMSFactory: QueueConnectionFactory or TopicConnectionFactory depending on the Connection Factory Type that you selected in the SubscriberOptions Tab of the message subscription service in TIBCO Designer.JMSProvider: TIBCOJMSUrl: Enter the URL of the TIBCO Enterprise Message Server (EMS). For example, tcp://EMS_Server:7222To configure routings, you need to correctly set the sender node and the receiver node. For example, the sender node can be TIB_NODE as defined in the previous step and the receiver node, which must be a LOCAL node, can be PSFT_HR.After performing the configuration for the adapter in PeopleSoft Application, you need to follow these steps in PeopleSoft Application Designer:
2. Select File > Open to open Open Definition dialog, and then select Message from the Definition drop-down list. Type the message name, such as CURRENCY_SYNC in the Name field and then click the Open button to open the message definition pane.
3.
4. When the PeopleCode Editor appears, leave the message name as is in the left hand side drop-down list and select the Subscription event from the right hand side drop-down list.
5. In the PeopleCode Editor, paste the PeopleCode given below. If there are any existing lines of PeopleCode, you should comment them first and then append the code given below. (This PeopleCode will go into the Subscription event of the PeopleCode for the required Component.)After performing the configuration for the adapter in PeopleSoft Application, you need to modify the content of some files to ensure the adapter works.
1. Modify the integrationGateway.Properties file located in PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSIGW\WEB-INF.
a. In the file, replace the %user_name%, %password% %PeopleSoft_server_name:port_number%, and %EMS_server_name:port_number% with the corresponding value without any quotes.
e. If you want to use JMS in the Topic mode, replace the lines in step d with the following:
• ig.jms.Queue1.URL has the same value as the URL specified in the JNDI URL field in the SubscriberOptions tab in the adapter.
• The subject name contained in ig.jms.Queue1 is the same as the name entered in the IB Subscriber Subject field in the adapter.
2. Modify the web.xml file located in PS_HOME\webserv\peoplesoft\applications\peoplesoft\PSIGW
\WEB-INF.<servlet-class>com.peoplesoft.pt.integrationgateway.listeningconnector.JMSListeningConnectorAdministrator </servlet-class>
3. If you have selected a transport while configuring the adapter, you may perform the following procedure:
2. Load Gateway connectors. Refer to Loading Gateway Connectors for detailed information.
a. If you selected HTTP as the subscriber transport type, use the default gateway LOCAL, and then add a connector entry HTTPTARGET into it. Click the Properties link for HTTPTATRGET Connector to open the Connector Properties pane and add the properties listed in Table 3 for the connector.
b. If you selected JMS as the subscriber transport type, use the default gateway LOCAL and then add a connector entry TIBCOTARGET to it. Click the Properties link for TIBCOTATRGET Connector to open the Connector Properties pane and add the properties listed in Table 2 to the connector.
3. To define message, refer to Defining Messages. For example, you have defined a message named COUNTRY_SYNC for the service, click on it to see it’s definition, as shown in Figure 11.
4. To define services, refer to Defining Services. If you defined the COUNTRY_SYNC message from step 3, then you can now define a service, such as COUNTRY_SYNC_RPCC service defined here, as shown in Figure 17.Figure 17 COUNTRY_SYNC_RPCC Service
a. If you defined a service, such as the COUNTRY_SYNC_RPCC service in step 4, in the General tab, enter a service operation name, such as COUNTRY_RPCC, in the Service Operation name and select Synchronous from the Operation Type drop-down list. Click the ADD button to create the new service operation, as shown in Figure 18.
6. To define a node, such as TIB_NODE, enter the following Connection Properties. Refer to Defining Nodes for detailed information.PrimaryURL: Specify the URL of the HTTP Listening Connector. For example, http://127.0.0.1:2002.JMSQueue: Use this property only if you have selected Queue to be the Connection Factory Type in the SubscriberOptions tab of the adapter. Enter the Subscriber Subject in SubscriberOptions that corresponds to the value of the JMSQueue defined in TIBCOTARGET Connector Properties, refer to Table 2.JMSTopic: Use this property only if you have selected Topic to be the Connection Factory Type in the SubscriberOptions tab of the adapter.JMSUrl: Enter the URL of the TIBCO Enterprise Message Server (EMS). For example, 127.0.0.1:7222serviceType: RPCCLIENT
To configure routings, you need to correctly set the sender node and the receiver node. For example, the sender node can be PSFT_HR that must be a LOCAL node, and the receiver node can be TIB_NODE defined in the previous step.After performing the configuration for the adapter in PeopleSoft Application, you need to follow these steps in PeopleSoft Application Designer:
2. Select File > Open to open the Open Definition dialog and then select Component from the Definition drop-down list. Type the component name, such as COUNTRY_TABLE, in the Name field and then click the Open button to open the component definition pane.
3. With the component definition open, select View > View PeopleCode.
4. When the PeopleCode Editor appears, leave the component name as is in the left hand side drop-down list and select the SavePostChange event from the right hand side drop-down list.
5. In the PeopleCode Editor, paste the PeopleCode given below. If there are any existing lines of PeopleCode, you should comment them first and then append the code given below.Replace the %service_operation_name% with the corresponding message name without any quotes. (This PeopleCode will go into the SavePostChange event of the PeopleCode for the required Component.)
If Request-Response Invocation Service succeeds, the text file will be generated and the response message appears in the file under the following directory specified in the above PeopleCode: c:\temp\sync0.txt.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |