Learn PeopleSoft Integration Tools

About This Course

In this course you'll learn all the skills needed to do PeopleSoft Integration easily and effectively.With over 53 lectures and 5 hours of content to walk you through each and every aspect of PeopleSoft Integration Tools, this is the course you needed to learn Integration Tools.

Learn how to use integration to synchronize data between two systems, expose PeopleSoft functionality to third party applications using web services, understand SOAP and REST, understand XML and JSON.

This training course is in form of a tutorial, which means you learn and practice at the same time. You will receive code-samples at the end of each project. You'll have the opportunity to work along the lectures building the integration projects.

The course was created for PeopleTools 8.53, but you should be able to work with any tools version above 8.50 and even with the latest release PeopleTools 8.55.

What is Inside this Course?

PeopleSoft Integration teaches PeopleSoft’s Integration broker. Using a project-build approach, you will see actual applications being built using the different integration and messaging protocols

Section 1 - Getting Started

In this section, we gain an understanding of XML documents, and XML Schema documents. Using a simple example of an Employee, we describe that employee in a simple XML document. Then we go to the PeopleSoft system to explore the different message types that can be used in an integration system.

Section 2 - Publish Subscribe

The first project we build in this course is a Publish/Subscribe method of synchronizing changes across two databases. We first look at the finished project, where we make a change to a record on an HCM instance, and see the same change reflected in the FIN instance. We then start building this project, starting with defining rowset-based messages, services and service operations, publishing peoplecode, nodes and routing, subscribing peoplecode, and testing. This foundational project will give you a great understanding of asynchronous messaging withing PeopleSoft

Section 3 - Provide a Web Service

We start this section again with a demonstration of the finished project - an Excel workbook that communicates with PeopleSoft using web services. Within Excel, we see how we can search for specific records in PeopleSoft, and return the details of the record we are searching for.

We create to web services for this project - one to provide a list of events, and one to provide details of a specific event. We create a WSDL for these operations, and test them using a third party tool. This project provides a comprehensive skill of providing web services that third-party systems can consume

Section 4 - Document Technology

Documents are a way of creating the message structure shared between two services. In this section, we teach the parts of a document - primitives, compounds, and collections. The relationship between documents and document-based messages is explained.

Section 5 - Consume a Web Service

In this project, we explore the use of consuming a third-party web service. In this case, we use a Weather Service which returns the current weather for a given postal code. We demonstrate the finished product - we change the postal code of an address, and the current weather for that postal code is displayed on the page. Using a free web service tester, we import the WSDL learn how the web service works. We them import the WSDL into PeopleSoft, and inspect the objects the Web Service Import Wizard creates. We then work to build and test. At the completion of this project, you will be able to consume web services from third-party providers

Section 6 - REST Services

In this section, we introduce REST based services, REST methods, and compare JSON vs. XML. We show how a REST URI is constructed, and offer some tips on how to design a meaningful URI scheme. Then we proceed to build PeopleCode handlers for the REST methods - we show how implement GET, DELETE, and PUT methods, recognizing variances in the URI structure. At the end of this section, you will be able to provide RESTful Web Services.

Section 7 - REST Consume

In our final project, we expand on our REST knowledge and consume a third-party REST service. We use a Postal Code service which returns a City/State based on a postal code. In our project, we will update the City and State on the screen upon a change in the postal code.

At the completion of this course, you will have solid integration skills, and will be capable of providing solutions to all types of integration requirements.