Integration Tools Rel 8.48

What you will learn

This course covers the PeopleSoft Integration tools used to integrate with other PeopleSoft databases and third-party systems, the tools include Integration Broker, component interfaces, Excel to CI utility, and file interfaces. The course also covers Send Master and the Handler Tester Utility Tester utility to test the integrations.

In this course students create and code service operations including transformation programs using Oracle XSL Mapper. They use the Service Operations Monitor to monitor the service operations and performance. Students will also create and test component interfaces, Excel to CI, and file interface integrations.

Learn to:
  • Configure PeopleSoft Integration Broker
  • Send and Receive Service Operations
  • Integrate data using component interfaces
  • Provide and consume web services with third-party systems.
  • Test connector and message processing using Send Master
Audience
 Database Designers
System Analysts
Technical Consultant

Prerequisites
 Working knowledge of the Application Designer
Working knowledge of PeopleCode
PeopleCode Rel 8.44
PeopleTools I Rel 8.48
PeopleTools II Rel 8.48

Course Objectives
 Describe the PeopleSoft integration technologies
Configure PeopleSoft Integration Broker
Send and receive service operations using PeopleSoft Integration Broker
Create integrations requiring transformations, translations, and filtering
Test connector and message processing using the Send Master utility
Integrate data with PeopleSoft and third-party systems using component interfaces
Provide and consume web services with third-party systems
Use flat files to integrate PeopleSoft data with PeopleSoft and third-party systems

Course Topics
Course Overview
 Course Objectives
Course Agenda

Technology Overview
 Describing PeopleSoft Integration Technologies
Describing Web Services
Describing PeopleSoft Integration Broker
Describing Services and Service Operations
Describing Component Interfaces
Describing File Interfaces

Introducing PeopleSoft Integration Broker Architecture
 Describing the PeopleSoft Integration Broker Architecture
Describing the PeopleSoft Integration Gateway
Describing Connectors
Describing the Gateway Services
Describing the Integration Engine
Explaining the Flow of Inbound Requests to PeopleSoft Integration Broker
Explaining the Flow of Outbound Requests from PeopleSoft Integration Broker

Configuring PeopleSoft Integration Broker
 Configuring PeopleSoft Integration Broker
Configuring an Integration Gateway
Describing Nodes
Renaming the Default Local Node
Creating Remote PeopleSoft Nodes
Configuring Integration Gateway Properties

Creating Messages
 Describing Services and Service Operations
Defining Service Configuration
Describing Messages
Creating a Rowset-based Message
Creating a Nonrowset-based Message
Using Message Parts

Creating Service Operations
 Adding Service Operations
Creating and Configuring Queues
Securing Service Operations
Adding Routings
Adding Synchronous Service Operations

Sending and Receiving Service Operations
 Describing Application Classes
Describing Asynchronous Service Operation Methods
Working with Rowsets in Service Operations
Implementing INotification Handler
Describing Synchronous Service Operation Methods
Implementing IRequestHandler
Adding Handlers
Describing Other Operation Types

Monitoring Service Operations
 Describing Service Operations Monitor and Statuses
Monitoring Asynchronous Services
Monitoring Synchronous Services
Administering Service Operations
Monitoring Performance
Setting Up Error Notification
Archiving Monitor Data

Using Service Utilities
 Describing Service Utilities
Administering Services
Using the Handler Tester
Building and Validating Service Schemas
Describing Metadata Backport

Using the Oracle XSL Mapper
 Installing And Configuring JDeveloper
Describing Transformation Programs
Creating an Application Engine Transform Program
Using Oracle XSL Mapper
Testing Transform Programs
Adding Transformation to a Routing
Versioning and Logically Transforming Service Operations

Applying Translations and Filtering
 Describing Data Translation
Describing Codesets
Creating a Codeset Group
Creating a Codeset
Creating Codeset Values
Writing a Transformation Program for Data Translation
Describing Filtering
Writing a Transformation Program for Filtering

Testing Connector and Messages Using Send Master
 Testing FILEOUTPUT Connector
Describing the Send Master Utility
Identifying the Send Master Project Types
Creating an Integration Broker Project
Testing SOAP Messages

Creating and Testing Component Interfaces
 Describing PeopleSoft Component Interfaces
Describing the PeopleSoft Component Interface Architecture
Describing the Elements of a Component Interface Definition
Creating Applications That Use Component Interfaces
Creating Component Interfaces
Setting Component Interface Security
Testing Component Interfaces

Implementing Component Interfaces
 Describing Component Interface Instantiation
Adding Component Interface PeopleCode to an Application
Modifying Component Interface PeopleCode

Working with Component Interface Collections
 Describing Component Interface Collections
Writing PeopleCode for Component Interface Collections
Working with Effective-Dated Data

Enabling Component Interfaces as Services
 Describing Component Interfaces as Web Services
Service Enabling a Component Interface
Describing the Generated Service Operations
Describing Changing Component Interfaces

Providing and Consuming Web Services
 Integrating with Third-Party Systems
Providing Web Services
Integrating with BPEL where PeopleSoft is the Provider
Viewing Gateway Logs
Consuming Web Services
Integrating with BPEL where PeopleSoft is the Consumer
Securing Web Services

Using the Excel to Component Interface Utility
 Describing the Excel to Component Interface Utility
Connecting to PeopleSoft
Creating a Template
Entering Data
Submitting Data
Deploying the Excel Workbook

Importing Data into the PeopleSoft System Using Flat Files
 Describing File Layouts
Creating File Layout Definitions
Importing Data Using File Layouts
Describing the Generated Application Engine PeopleCode
Running the Application Engine Program
Adding Field Attributes to a File Layout
Using the Inbound File Loader Utility

Writing Data to Flat Files
 Listing the Methods Used to Read from and Write to Plain Text Files
Writing to Files Defined by a File Layout
Creating Application Engine Programs to Export Data to Flat Files
Creating Multilevel File Layouts
Using PeopleCode with Multilevel File Layouts
Creating and Using Segments in File Layouts

Suggested Next Courses
 Application Engine Rel 8.48
PeopleCode Rel 8.44
Workflow Rel 8.44