PeopleSoft Wiki

Concepts

Integration broker is one of those areas of PeopleSoft that introduces a lot of terminology. You really need to get your head around this terminology before you can really understand what's going on. Unfortunately, the documentation in PeopleBooks can be a little terse. So here's my (limited) understanding of the major concepts (please feel free to comment):

• Gateways are essetially a pathway out of the system. There is always a LOCAL gateway in PeopleSoft which refers to the source PeopleSoft system. Other gateways may exist - for example when there are differences between PeopleTools versions.
• Domains refer to PeopleSoft application server (tuxedo) domains.
• Nodes define what application a message belongs to - any system that integration broker can talk to (including the local system) will have a node.
• Messages define the structure of the XML sent between nodes. The key difference between asynchronous and synchronous messages is acknowledgement - synchronous messages need to be acknowledge by the receiver, aynychronous ones don't. Synchronous messages aren't used much in PeopleSoft, but I believe their main purpose is for reliability.
• Queues are used to manage and group messages so that all messages are sent through the multiple pipes. Queues are used for administration of integration broker to avoid stopping everything when something is wrong. For example you can pause a one queue for messages to the report architecture without say stopping messages to the finance system.
• Service Operations bring together messages, queues, handlers and routings. They essentially define how the message moves between systems.
• Services seem to be used to group service operations.
• Routings are used to link a service operation to a node, and can also specify transformation of a message.
• Handlers contain code and logic for sending/receiving/manipulating mesages.

Messages

Use the following SQL to return the fields for a record in your message that are set to include in your messsage field properties:

select RF.FIELDNAME
from PSRECFIELD RF
where
    RF.RECNAME = 'MESSAGE_RECNAME'
    and not exists (
        select  1
        from    PSMSGFLDOVR MFO
        where   MFO.MSGNAME = 'MSGNAME'
        and     MFO.APMSGVER = 'VERSION_N'
        and     MFO.RECNAME = RF.RECNAME
        and     MFO.FIELDNAME = RF.FIELDNAME
        and     MFO.DONOTPUBLISH = 1
    )
order by RF.FIELDNUM;

Further Information

• Integration Broker Basics (ERP Associates)
• Different ways to integrate with PeopleSoft