integration broker peopletools 8.45.18. integration broker steps –introduction & terminologies...
TRANSCRIPT
![Page 1: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/1.jpg)
Integration BrokerPeopleTools 8.45.18
![Page 2: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/2.jpg)
Integration Broker
• Steps– Introduction & terminologies– Application Server PUB/SUB services (Application Server)– Integration Broker -Architecture– Gateway Setup (Integrationgateway.properties) (PIA)– Node Setup (PIA)– Create/Enable Message Channel (AD)– Create/Enable Message (AD)– Security (PIA)– Attach Message to Node (PIA)– Monitor Messages (PIA)– Jolt & Tuxedo– Write Peolpecode (AD) (Appendix - A)– Appendix – B (for reference)
![Page 3: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/3.jpg)
Introduction & terminologies-Integration
Broker Overview• Introduction• Integration Broker Elements
o Integration Gatewayo Integration Engineo Connectorso Gateway Managero Transaction
• Integration Broker Architecture• Integration Scenario• Connector Usage
![Page 4: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/4.jpg)
Introduction & terminologies-Introduction
• Middleware Technology that facilitates synchronous and asynchronousmessaging among internal systems and trading partners
• Modular design – Elements developed for integration can be reused
• Comprises of two high level sub-systems, Integration Gateway andIntegration Engine.
![Page 5: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/5.jpg)
Introduction & terminologies-Integration
Broker Elements• Integration Gateway
• Integration Engine
• Connectors
• Gateway Manager
• Transaction
![Page 6: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/6.jpg)
Introduction & terminologies-Integration
Gateway• Platform that manages the actual receipt and delivery of messages
• Provides the support for the leading TCP/IP protocols used
• Provides the extensible interfaces for the development of newconnectors for communication with legacy, ERP and internet based systems
• Backward compatibility for XML links and Application Messaging
• Maintains basic logging information for message receipt, delivery and errors
• Capable of message format management.
![Page 7: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/7.jpg)
Introduction & terminologies-Integration
Engine• Runs on the PeopleSoft Application Server.• Produces and consumes messages for the application• Receives the messages through one or more separately installed
integration gateways• Treats the gateways as “Black Box” and communicate with them
using standard connectors• Can adapt the elements of existing integration to produce new
integration with minor changes• Handles the messages containing the data in a variety of formats like
PeopleSoft rowsets, XML documents, Simple Object Access Protocol(SOAP) and unstructured data
• Sends and receives the messages synchronously or asynchronously• Applies message transmission type and routing based on specification
defined in PIA component• Transforms message structure and translate data content• Handles the security features
![Page 8: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/8.jpg)
Introduction & terminologies-Connectors
• Two basic type of connectors used in Integration Gateway• Listening Connectors• Target Connectors
• Supports asynchronous, synchronous and polling based message handling
• Connectors are configurable based on user-defined setting at integration gateway and node level
![Page 9: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/9.jpg)
Introduction & terminologies-Gateway
Manager• Processes every message that flows through the integration gateway
• Maintains links among the other major integration gateway components
• Invoked by listening connectors on receiving the message request
• Uses handles on messaging objects, IBRequest and IBResponse todetermine how to route each message
• Uses number of services during each stage of operations
• Invokes the appropriate target connector based on the contents of themessage object and waits for the response from target connector. On receiving the response, it forwards the response to the calling listening connector.
![Page 10: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/10.jpg)
Introduction & terminologies-Gateway
Services• Error Handling: Standard error handling interface that is exposed to each
connector. Provides error handling and error logging for most connectors
• Messaging Objects: There are two objects service in the Integration gateway• IBRequest• IBResponse
• XML Parsing: Used to parse and traverse XML data stored in content section of message
• Message Validation: Used for basic validation such as making sure themessage identifies requestor and message name etc. to ensure thatintegration engine and the target application can process them.
![Page 11: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/11.jpg)
Introduction & terminologies-Gateway
Services• Connector Management: Comprises of several smaller services to
Manage connectors in Integration Gateway.Processes each IBRequestTo determine the appropriate connector to call in each situation. AlsoProcesses the IBResponse returned by each connector.
• Error & Message Logging: Standard logging interface that mostcomponents in the system use. Enables the administrator to quicklydrill-down on problems or review message logs.
• Sample URL for checking errors in development environment. http://peoplesoftsvr.i-flex.com:81/PSIGW/errorLog.html
![Page 12: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/12.jpg)
Introduction & terminologies-Transaction
• Basic unit of work in Integration
• Associated with a specific node
• Used to designate a message that the current node can send or receive
• Defines the message as inbound / outbound message
• Defines transmission type I.e. Synchronous / Asynchronous
• Four basic types of Transaction Outbound Asynchronous (OutAsync) Outbound Synchronous (OutSync) Inbound Asynchronous (InAsync) Inbound Synchronous (InSync)
![Page 13: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/13.jpg)
Application Server - PUB/SUB services
(Application Server)•Resides on the Application Server as a Messaging Server Process
•Sends and receives messages for the application through the IB Gateway
•Consists of Publication Broker, Publication Contractor and Subscription Contractor
![Page 14: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/14.jpg)
Integration Broker -Architecture
Listening Connectors
HTTP PeopleSoft PeopleSoft8.1 JMS
GatewayManager
Target Connectors
POP3 HTTP SMTP PeopleSoft
Gateway Services
Error Handling MessageValidation
MessagingObjects
XML Parsing
ConnectorManagement
Error & Msg.Logging
PeopleSoft8.1 File JMS
![Page 15: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/15.jpg)
Integration Broker –Architecture continuedPeopleSoft 8.4
HR (USA)System
IntegrationEngine
For HR:Local Integration Gateway
For CRM:Remote Integration
Gateway
PeopleSoftListeningConnector
HTTPTarget
Connector
PeopleSoftTarget
Connector
PeopleSoftListeningConnector
Gateway Manager
JOLT
MIME
HTTP
For CRM:Local Integration Gateway
For HR:Remote Integration
Gateway
PeopleSoftListeningConnector
PeopleSoftTarget
Connector
HTTPTarget
Connector
PeopleSoftListeningConnector
Gateway Manager
PeopleSoft 8.4CRM (UK)
System
IntegrationEngine
JOLT
MIME
HTTP
MIMEHTTP
MIME
HTTP
MIME
HTTP
Firewall
ApplicationServer(s)
+Database
ApplicationServer(s)
+Database
![Page 16: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/16.jpg)
Gateway Setup (Integrationgateway.properties)
(PIA)
IB
![Page 17: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/17.jpg)
Gateway Setup (Integrationgateway.properties)
(PIA)
IB
![Page 18: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/18.jpg)
Gateway Setup (Integrationgateway.properties)
(PIA)
IB
![Page 19: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/19.jpg)
Gateway Setup (Integrationgateway.properties)
(PIA)
IB
![Page 20: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/20.jpg)
Node Setup (PIA)IB
![Page 21: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/21.jpg)
Node Setup (PIA)IB
![Page 22: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/22.jpg)
Node Setup (PIA) [Attach Message to Node (PIA)]
IB
![Page 23: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/23.jpg)
Node Setup (PIA)IB
![Page 24: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/24.jpg)
Node Setup (PIA)IB
![Page 25: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/25.jpg)
Node Setup (PIA)IB
![Page 26: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/26.jpg)
Node Setup (PIA)[Attach Message to Node (PIA)]
IB
![Page 27: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/27.jpg)
Node Setup (PIA)IB
![Page 28: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/28.jpg)
Create/Enable Message Channel (AD)
IB
![Page 29: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/29.jpg)
Create/Enable Message Channel (AD)
IB
![Page 30: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/30.jpg)
Create/Enable Message (AD)IB
![Page 31: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/31.jpg)
Create/Enable Message (AD)IB
![Page 32: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/32.jpg)
Create/Enable Message (AD)IB
![Page 33: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/33.jpg)
Create/Enable Message (AD)IB
![Page 34: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/34.jpg)
Security (PIA)IB
![Page 35: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/35.jpg)
Monitor Messages (PIA)IB
![Page 36: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/36.jpg)
Monitor Messages (PIA)IB
![Page 37: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/37.jpg)
Monitor Messages (PIA)IB
![Page 38: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/38.jpg)
Jolt & Tuxedo
![Page 39: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/39.jpg)
Jolt & Tuxedo
• Jolt is an application-layer network protocol that runs over TCP. It is proprietary and owned by BEA and was developed as the means for allowing Java applications to communicate with Tuxedo (also a BEA product).
• Tuxedo is a C-based OLTP monitor that multiplexes user sessions and transactions into a RDBMS and controls transaction execution. In a PeopleSoft system, C++ logic that interprets and executes application business rules and functionality run as services within the Tuxedo domain(s), with Tuxedo managing DB transaction boundaries and queues of requests.
• The role of PIA web servers is to create and manage presentation only.
• At runtime, all business logic executes in Tuxedo.
![Page 40: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/40.jpg)
Appendix-A for publish
------Pub code-------------------------
&MSG = CreateMessage(Message.IF_CUST_MSG);
&MSG.CopyRowsetDelta(GetRowset());
&MSG.publish();------Pub code-------------------------
![Page 41: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/41.jpg)
Appendix-A for subscription------sub code------------------------&msg = GetMessage();
&rec = CreateRecord(Record.IF_CUST_TBL);
&rs = &msg.getrowset();
&rec.setid.value = &rs.getrow(1).IF_CUST_TBL.setid.value;&rec.cust_id.value = &rs.getrow(1).IF_CUST_TBL.cust_id.value;&rec.descr.value = &rs.getrow(1).IF_CUST_TBL.descr.value;If &rs.getrow(1).PsCAMA.audit_actn.value = "A" Then &rec.insert();End-If;
If &rs.getrow(1).PsCAMA.audit_actn.value = "C" Then &rec.update();End-If;
------sub code-------------------------
![Page 42: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/42.jpg)
Appendix-BReference document IB/IB
Microsoft Word Document
![Page 43: Integration Broker PeopleTools 8.45.18. Integration Broker Steps –Introduction & terminologies –Application Server PUB/SUB services (Application Server)](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649e7e5503460f94b82071/html5/thumbnails/43.jpg)
QUESTIONS???