COMMUNICATE WITH OTHER SYSTEMS

Configure Integration Broker and Apply Integration Strategies

Available As

On Demand

Watch the videos for 60 days, access the text for life!

$1,497 USD

Live Virtual

5-day Instructor-led course

$5,885 USD


Subscription

All courses, one low price

$6,700 USD

What you will learn

  •  Creating flat files
  •  XML, CSV, Fixed, JSON
  •  Integration Broker
  •  Point-to-point integration
  •  Asynchronous integrations
  •  Web Services
  •  REST
  •  Administration
  •  Feeds
  •  Integration Broker SDK
  •  Application Services Framework
  •  File Layouts
  •  Component Interfaces
  •  Hub and spoke integration
  •  Messages, Nodes, Routings, etc.
  •  Synchronous integrations
  •  Security
  •  SOAP
  •  Providing and Consuming
  •  Query Access Service
  •  Troubleshooting
  •  Best practices

WHO SHOULD ATTEND?

  • PeopleSoft Developers

Certificate

Each course includes a blockchain-enabled digital certificate of achievement to prove your participation in our online course. Since this is a digital certificate, you print it, add it to your LinkedIn profile, or share it on social media!

Duration

Students typically complete this material within 40 hours.

You will have access to the videos for 60 days after purchase and may keep the accompanying hands-on step-by-step lesson guide for life.

System Requirements

This course includes plenty of hands-on activities. To be successful, we recommend keeping a PeopleSoft development, test, demo, or sandbox handy. If you don't have one, you may build your own laptop-hosted VirtualBox instance by following the instructions in the My Oracle Support document 1641843.2.

RECOMMENDED PREREQUISITES

Course curriculum

  • 1
    Introduction
    • © Copyright
    • 💡 Hints and Definitions
    • How to use this course
  • 2
    Creating the Sample Module
    • Creating the Sample Module
    • Activity: Create Fields
    • Activity: Create Records
    • Activity: Create Pages
    • Activity: Create Components
  • 3
    1. Tools Overview
    • Chapter Overview
    • Integration Overview
    • Introduction
    • PeopleCode and File Layout Definitions
    • Component Interfaces
    • The Integration SDK
    • Integration Broker
    • Summary
  • 4
    2. Batch Integrations
    • Chapter Overview
    • Introduction
    • Command Line Utilities
    • External Tables and Database Links
    • Database Triggers
    • SQR
    • App Engine
    • Batch versus Real-time Integrations
    • Summary
  • 5
    3. Working with Flat Files
    • Chapter Overview
    • Flat File Input and Output
    • Working with Flat Files: SQR vs PeopleCode
    • What is a File Layout?
    • Creating a Sample Data Record
    • Walkthrough 3-1: Creating a Sample Data Record
    • Creating a File Layout
    • Walkthrough 3-2: Creating a File Layout
    • Importing Data Using a File Layout
    • Walkthrough 3-3: Importing Data Using a File Layout and PeopleCode
    • Exporting Data Using a File Layout
    • Walkthrough 3-4: Exporting Data using a File Layout and PeopleCode
    • Summary
  • 6
    4. File Layouts
    • Chapter Overview
    • File Layout Properties
    • File Layouts in Detail
    • File Layout Definition Properties
    • Inserting Record Definitions
    • File Layout Record Properties
    • Inserting Segments and Field Definitions
    • File Layout Field Properties
    • Field Inheritance
    • Special Considerations for Different File Types
    • Printing File Layouts
    • Summary
  • 7
    5. PeopleCode and File Layouts
    • Chapter Overview
    • PeopleCode File Class
    • The GetFile Function
    • File Objects and Plain Text Files
    • File Objects and File Layouts
    • Importing Data into One Table
    • Exporting Data from One Table to a Flat File
    • Exporting Data from Multiple Tables to One Flat File
    • Importing a Hierarchical Flat File into Three Tables
    • Importing with a File Layout and PeopleCode
    • Summary
  • 8
    6. Generating XML and JSON
    • Chapter Overview
    • File Formats
    • About File Formats
    • Using the XmlDoc Class to Create XML Files
    • Documents Module
    • Walkthrough 6-1: Documents Module
    • Walkthrough 6-2: Testing Documents
    • Documents and PeopleCode
    • Walkthrough 6-3: Populating Documents with PeopleCode
    • Documents with Collections
    • Walkthrough 6-4: Documents with Collections
    • JsonBuilder
    • Walkthrough 6-5: The PeopleCode JsonBuilder Class
    • Walkthrough 6-6: The PeopleCode JsonObject and JsonArray
    • More JSON Options
    • Creating JSON Files (Activity Introduction)
    • Activity 6-7: Create JSON Files
    • Creating JSON Files (Activity Review)
    • Parsing JSON
    • Walkthrough 6-8: Parsing JSON Using PeopleTools JSON Classes
    • Summary
  • 9
    7. Component Interfaces
    • Chapter Overview
    • About Component Interfaces
    • Steps to Implement a Component Interface
    • About Component Interfaces
    • Walkthrough 7-1: Defining a Component Interface
    • Working with a Component Interface
    • The Four Primary Elements of a Component Interface
    • Walkthrough 7-2: Component Interfaces w/o Default Properties
    • Editing Properties
    • Validating the Component Interface
    • Methods
    • Component Interface Security
    • Setting Component Interface Security
    • Walkthrough 7-3: Controlling Access to a Component Interface
    • Walkthrough 7-4: Testing a Component Interface
    • Component Interfaces and PeopleCode
    • Component Interface PeopleCode Templates
    • Walkthrough 7-5: Invoking a Component Interface from an App Engine
    • Component Interface App Engine Review
    • Summary
  • 10
    8. Integration Broker Overview
    • Chapter Overview
    • About Integration
    • About Integration Broker
    • Integration Broker Overview
    • Strategies for Integration
    • Integration Broker
    • Integration Broker Components
    • What is a Service?
    • What is a Service Operation?
    • What is a Message?
    • What is a Queue?
    • What is a Node?
    • What is a Routing?
    • Integration Gateway
    • Integration Broker Configuration Checklist
    • Summary
  • 11
    9. Integration Broker Metadata
    • Chapter Overview
    • Configuring the Gateway
    • Gateway Node Configuration
    • Gateway Setup
    • Service Configuration
    • Setting Up Target Locations
    • Examining a Message
    • Integration PeopleCode
    • Examining a Queue
    • Examining a Service Definition
    • Examining a Service Operation
    • Service Operation Security
    • Examining Message Nodes
    • PeopleSoft Node Configuration
    • Trusted Node Configuration
    • Examining Routings
    • Node Configuration Checklist
    • Summary
  • 12
    10. Incremental Sync (Publish)
    • Chapter Overview
    • Introduction
    • Chapter Scenario
    • Creating a Message
    • Walkthrough 10-1: Creating a Message Definition
    • Creating a Queue
    • Walkthrough 10-2: Creating a Queue
    • Creating Additional Metadata Definitions
    • Walkthrough 10-3: Create a Service Definition
    • Walkthrough 10-4: Create a Service Operation
    • Walkthrough 10-5: Define Service Operation Security
    • Walkthrough 10-6: Creating a Routing Definition
    • Publishing a Message
    • Walkthrough 10-7: Publishing PeopleCode
    • Subscribing Database Changes
    • PeopleCode for Sending Messages
    • PeopleCode for Receiving Messages
    • Self Subscriptions
    • Activity 10-8: Self-subscriptions
    • Walkthrough 10-9: Migrating Integration Definitions
    • Migrating Integration Definitions
    • How to Rename and Delete Integration Definitions
    • Summary
    • Renaming and Deleting Integration Definitions
  • 13
    11. Service Operations Monitor
    • Chapter Overview
    • About the Service Operations Monitor
    • Security for Service Operations
    • The Service Operations Components
    • The Asynchronous Services Component
    • Synchronous Services
    • Queue Status
    • Node Status
    • Domain Status
    • Statistics
    • Error Notification and Archiving Monitor Data
    • The Asynchronous Details Component
    • Summary
  • 14
    12. External Subscribers
    • Chapter Overview
    • Scenario Overview
    • Configuring an External Node
    • Walkthrough 12-1: Configuring an External Node
    • Transformation Programs
    • Walkthrough 12-2: Transformation Programs
    • Configuring Transformation Routings
    • Walkthrough 12-3: Configuring Transformation Routings
    • Publishing from Delivered Components
    • Activity 12-4: Publishing from Delivered Components
    • Summary
  • 15
    13. Full Sync Messages
    • Chapter Overview
    • About the Full Sync Process
    • What is a Full Sync Message?
    • Creating the Enrollments Sample Record
    • Activity 13-1: Create the Enrollments Component
    • Setting Up a Full Table Synchronization
    • Full Sync Operation Metadata
    • Walkthrough 13-2: Full Sync Message
    • Walkthrough 13-3: Queue Definition
    • Walkthrough 13-4: Service Definition
    • Walkthrough 13-5: Service Operation
    • Walkthrough 13-6: Routing Definition
    • Target Configurations
    • Walkthrough 13-7: Target/Receiver Node Configurations
    • Full Sync Batch Publish Rules
    • Walkthrough 13-8: Full Table Publish Rules
    • Walkthrough 13-9: Running the Full Data Publish Process
    • Other Delivered Publish Processes
    • PSCAMA
    • PSCAMA Record Definition
    • Audit Action Codes
    • Activity 13-10: Creating Your Own Full sync
    • Summary
  • 16
    14. Consuming a Web Service
    • Chapter Overview
    • Web Service Terminology
    • SOA and Web Services Terminology
    • Consuming an External Web Service
    • Testing a WSDL with SoapUI
    • Activity 14-1: Testing a WSDL with SoapUI
    • Consuming an HCM Cloud Web Service from PeopleSoft
    • Activity 14-2: Consuming an HCM Cloud Web Service from PeopleSoft
    • Parsing the XML Response
    • Solution to 14-2 Challenge
    • Reference: Testing a WSDL with SoapUI
    • Reference: Testing a WSDL with SoapUI
    • Testing a WSDL Using Send Master
    • Reference: The Consume Web Service Wizard
    • Activity Introduction: Consuming a Web Service
    • Activity 14-3: Consuming a Web Service
    • Web Service Consumption Activity Review
    • Summary
  • 17
    15. Providing SOAP-Based Services
    • Chapter Overview
    • Watch: Providing SOAP-Based Services
    • Exposing Message-Based Web Services with PeopleSoft
    • Watch: Schema-based Messages
    • Walkthrough 15-1: Creating the Request Message
    • Activity 15-2: Creating the Response Message
    • Watch: SOAP OnRequest Handler
    • Walkthrough 15-3: On Request Handler
    • Watch: Defining the SOAP Service and Operation
    • Activity 15-4: Defining the Service
    • Walkthrough 15-5: Defining the Service Operation
    • Watch: Provide Web Service Wizard
    • Walkthrough 15-6: Provide Web Service Wizard
    • Watch: SOAP Tester
    • Walkthrough 15-7: Testing with the SOAP Tester
    • Walkthrough 15-8: Testing with SoapUI
    • Watch: PeopleSoft WSDL
    • Watch: WS-Security
    • Activity 15-9: Understanding our Service
    • Activity 15-10: Changing the Schema
    • Multiple Elements in an XML Response
    • Activity 15-11: Multiple Response Elements
    • Summary
  • 18
    16. CI-Based Services
    • Chapter Overview
    • Watch: CI-based SOAP Services
    • CI-Based Web Services with PeopleSoft
    • Walkthrough 16-1: Creating a CI-based Web Service
    • Walkthrough 16-2: Testing in SoapUI
    • Activity 16-3: Get Operation
    • Walkthrough 16-4: Web Service Security
    • Watch: CI-based REST Services
    • Walkthrough 16-5: CI-Based REST Services (8.57+)
    • Summary
  • 19
    17. PeopleSoft as a REST Provider
    • Chapter Overview
    • Watch: What is REST?
    • About REST
    • Watch: Review a Delivered REST Service
    • Walkthrough 17-1: Testing a Delivered REST Service
    • Walkthrough 17-2: Reviewing a REST Service Operation
    • Watch: Creating REST Documents
    • Walkthrough 17-3: Creating REST Documents
    • Watch: Creating a REST Service and Service Operations
    • Walkthrough 17-4: Creating a REST Service and Service Operation
    • Watch: REST Handler PeopleCode
    • Walkthrough 17-5: REST Handler PeopleCode
    • Watch: Server Faults
    • Walkthrough 17-6: Server Faults
    • Watch: Unstructured Responses
    • Activity 17-7: Unstructured Responses
    • Watch Multiple URL Templates
    • Activity 17-8: Multiple URL Templates
    • Watch: Content Negotiation
    • Activity 17-9: Content Negotiation
    • Watch: Custom HTTP Headers
    • Activity 17-10: Custom Response Headers
    • Watch: Handling REST Verbs
    • Activity 17-11: Handling REST Verbs
    • Summary
  • 20
    18. Application Services
    • Chapter Overview
    • About Application Services
    • About the Scenario
    • Watch: Application Services
    • Walkthrough 18-1: App Class Stub
    • Walkthrough 18-2: Create an Application Service
    • Walkthrough 18-3: Creating Base Parameters
    • Walkthrough 18-4: Create a Root Resource
    • Walkthrough 18-5: Security
    • Watch: Application Services PeopleCode
    • Walkthrough 18-6: Completing the PeopleCode
    • Walkthrough 18-7: Testing
    • Activity 18-8: Handling REST Verbs
    • Watch: Exporting OpenAPI Descriptors
    • Walkthrough 18-9: Exporting an Application Service
    • Walkthrough 18-10: Securing an Application Service
    • Consuming REST Services Through PeopleSoft's Application Services Framework
    • Walkthrough 18-11: REST Consumption with PeopleSoft's Application Services Framework
    • Summary
  • 21
    19. Consuming REST
    • Chapter Overview
    • About REST Consumption
    • Watch: Testing REST Consumption
    • Walkthrough 13-1: Test Using SoapUI
    • Watch: Generating the REST Request Structure
    • Activity 13-2: Generate the Request Structure
    • Watch: Review: Generating the REST Request Structure
    • Watch: REST Service Metadata
    • Walkthrough 13-3: REST Service Metadata
    • Watch: REST Consumption PeopleCode
    • Walkthrough 13-4: Consumption PeopleCode
    • Walkthrough 13-5: POSTing to a REST End Point
    • Watch: Metadata-less Requests
    • Activity 13-6: Metadata-less Integrations
    • Watch: Programatically Setting the Authorization Header
    • Walkthrough 13-7: Programmatically Setting the Authorization Header
    • Watch: Twilio Activity Introduction
    • Walkthrough 13-8: URL Encoded Form Data
    • Watch: Review: Twilio Activity
    • Summary
  • 22
    20. Feeds
    • Chapter Overview
    • Watch: Feeds
    • About Feeds
    • Activity 14-1: Creating a Query
    • Walkthrough 14-2: Understanding Restricted Services
    • Walkthrough 14-3: Feed Publish Wizard
    • Summary
  • 23
    21. Query Access Service
    • Chapter Overview
    • Watch: Query Access Service
    • About Query Access Service
    • Walkthrough 15-1: REST: Invoking Query Access Service (No Prompts)
    • Walkthrough 15-2: REST: Using Prompts
    • Walkthrough 15-3: REST: Choosing Result/Output Fields
    • Walkthrough 15-4: REST: Image/Binary Data and QAS
    • Activity 15-5: REST: Invoking a Query Access Service
    • Walkthrough 15-6: SOAP: Invoking a Query with Prompts
    • Summary
  • 24
    22. Integration Broker SDK
    • Chapter Overview
    • Watch: Integration Broker SDK
    • SDK Overview
    • About Connectors
    • Summary
  • 25
    23. Archiving
    • Chapter Overview
    • Archiving Service Operation Instances
    • Archiving Service Operation Instances One at a Time
    • Retrieving Archived Messages
    • Archiving Service Operation Instances in Batch
    • Purging the Service Operation Instance Tables
    • Activity 23-1: Archiving
    • Summary
  • 26
    24. Troubleshooting and Testing
    • Chapter Overview
    • Troubleshooting and Debugging Techniques
    • Service Operations Administration
    • Using the Service Operations Monitor
    • Common Publication Problems
    • Common Subscription Problems
    • Miscellaneous Problems
    • Checking Your Integration Broker Configuration
    • Setting Up Error Notification
    • Querying the Message Monitor Tables
    • Tracing Application Engine Programs
    • The Application Engine Debugger
    • Tracing PeopleCode and SQL
    • Summary
  • 27
    25. JSON Web Tokens
    • Chapter Overview
    • Watch: JSON Web Tokens
    • Pluggable Encryption Technology Overview
    • JSON Web Tokens (JWT) Overview
    • Steps to Create a JWT in PeopleCode
    • Walkthrough 25-1: Create an Algorithm Keyset
    • Walkthrough 25-2: Create an Algorithm Chain
    • Walkthrough 25-3: Create an Encryption Profile
    • Walkthrough 25-4: Test the Encryption Profile
    • Walkthrough 25-5: Generate a JWT
    • Summary
  • 28
    26. Final Exam
    • Chapter Overview
    • Activity 26-1: Creating an Application Service
    • Summary
  • 29
    Final Words
    • Course Survey

Instructor

  • Jim Marion

    Principal Instructor

    Jim Marion

    Jim Marion is an Oracle Ace, prolific and popular blogger, and a highly sought, dynamic public speaker who regularly shares his knowledge at user group conferences and private training events. Feedback is off the charts and we know you will enjoy your time spent with him through this course.