PeopleSoft: Integration Tools Rel 8.48

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

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

Skills Gained

• 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

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 Outline

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

Follow On Courses

• Application Engine Rel 8.48
• PeopleCode Rel 8.44
• Workflow Rel 8.44

PeopleSoft: Integration Tools Rel 8.48 / D17637GC30