Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisIntroducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Below is a quick reference of the PeopleSoft tables used by Integration Broker. This is not a complete list, but it should help you get started with your own queries. There are some nuanced ones that I have left off that might provide functionality that no one uses or is not directly tied to integration broker functionality. For example, Nodes are used for other things like linking between PeopleSoft systems for PIA. Any “language” records are removed.
Node Related:
Services:
Service Operation:
Service Operation Routings:
Service Operation Handlers:
Message Related:
Integration Broker Queues:
Synchronous Tables:
Archive Tables:
Others: