SNUG June 16, 2006 The Future of PeopleSoft Integration

The Future of PeopleSoft

Integration

Reasons to Use Your Free PeopleSoft

and Fusion Middleware Integration

Tools

SNUG

2

Aims and Ambitions

Web Services and Process Orchestration

Primer

Understand what Oracle is giving you for free

4

Diverse Systems

Barrier to an Information-Driven

Enterprise

Mobile Clients E-Business Suite Business Intelligence Siebel Legacy SAP Web Services Suppliers PeopleSoft

Fragmented information and

processes hurt business

performance

Inability to obtain crucial information

Complex and costly integration

Slow response to change Security breaches

Faster Integration

More Flexible Processes Maximize Value of Existing Investments

Improved Performance Management

Common View of Information

What can provide:

Business Intelligence

Siebel Web Services

Suppliers PeopleSoft Unified Access E-Business Suite

?

6

PeopleSoft’s Solution Prior to the

Acquisition:

App Connect

Portal

Business Intelligence

Integration & Workflow

• BPEL Process Manager

• Enterprise Service Bus

• Services Repository

Identity Management

Key Components:

Business Intelligence

Siebel Web Services

Suppliers PeopleSoft

Unified Access

E-Business Suite

More Robust & Comprehensive:

8

Where PeopleSoft and

Fusion Integration Meet

Oracle is

not

replacing

Integration Broker (IB)

for PeopleSoft

Applications

• PeopleSoft Integration Broker passes

information between PeopleSoft Apps and Fusion Middleware • Fusion Middleware

A [web] service is a unit of discrete business functionality. • Example: Purchase Order

A [web] service operation does only one thing: • Examples: Create Purchase Order

Update Purchase Order Get shipping Quote Get Credit Rating

Generate Return Merchandise Authorization #

Business Process Execution Language (BPEL) is an industry standard for orchestrating processes that uses web services

(think workflow on steroids)

A Service Oriented Architecture (SOA) provides a standards-based platform that allows services to be provided, discovered, and consumed to facilitate the creation of orchestrated business processes.

A service oriented application leverages the power of a service

10

Enterprise Services Bus BPEL Process Manager Composite

Applications

Order to Cash Procure to Pay

The ESB and BPEL PM go through Integration Broker to

get to PeopleSoft business logic

Employee Onboarding

Integration & Orchestration

Orchestration Integration Services Integration Broker Integration Broker XML Gateway Web Services Gateway Other Applications Adapte rs We b S e rv ic e s Presentation

D&B Rating Request dnb.com Web Service PeopleSoft Integration Broker

2

3

1

You can do this with PeopleTools 8.4 and higher

User clicks button to check

current credit worthiness

Consuming a Web Service

12

Providing

a Web Service

Integration Broker Example

PeopleSoft Integration

Broker

2

3

Amazon checks inventory when user clicks on an item

1

You can do this with PeopleTools 8.42 and higher

Amazon.com _{PeopleSoft Inventory}

Process Orchestration

IB and BPEL PM Example

Manual Step:

Create new hire in PeopleSoft HCM

Integration Broker initiates Onborading Process

BPEL PM Orchestrates Web Services:

• Provision office • Provision furniture • Provision phone • Provision computer • Create email account

• Schedule training in PeopleSoft ELM

(via Integration Brokerand ELM Comp. Int.)

BPEL PM Orchestrates Workflow:

• IT to create network account

• Employee to fill out compliance forms

BPEL PM Manages Business Rules

• Don’t order furniture, phone or computer until the office is ready

• Don’t create email account until the network account is ready

• Don’t schedule training without email account • Don’t initiate workflow for compliance forms before

email account exists

Business Activity Monitoring (BAM)

• Escalate if any step is not completed on time

14

BPEL

Beyond Message Brokering

BPEL

BPEL

PeopleSoft PeopleSoft Order Entry Order Entry Integration Broker Integration Broker Application Server Application Server Service Bus Service Bus Manufacturing Manufacturing System System W W S S D D L L Partner Partner System System A A D D A A P P T T E E R R

Cross Application Process Orchestration

Application Task / Activity Controller

•

Long Lived Processes with State Management • Workflow / Tasklist Integration (PT 8.48)

Discover Services

Interactive Services Repository

Reduce the cost to implement integrations by finding the

correct integration points quickly

Interactive Services Repository (ISR)

• Hosted on Customer Connection • Searchable catalog of all PeopleSoft

EIPs

• Available since December 2004

WSIL

• Local listing of services on a server • Part of PeopleTools 8.48

[Oracle] UDDI

• Catalog of web services in your company

• PT 8.48 works natively with [Oracle] UDDI

16 Java/J2EE COM/.NET C/C++ SOAP WSDL Busine ss Logic Presentation Data

Component

_{Component Interface}

Component Interfaces

Component Interface

Excel Integration

Read data from a spreadsheet into PSFT and write back to spreadsheet which rows failed to load and why

Ideal for data conversion

• Example: loading employees or customers

All of the validations and PeopleCode events execute as if you entered the information on a PeopleSoft page

18

Messages

The content or

payload of what

Integration Broker

sends from one

system to another

In Application

Designer messages

are the containers

that hold that

Business Rules XML/HTTP Internet Near real-time (asynchronous) App Messaging SOAP WSDL Internet Real-time (synchronous) Web Services HTML Page Traditional Deferred (batch) App Engine File Layout Object

20

Application Engine and

File Layout

Application Engine (AE) is the preferred file & SQL processing tool

• Schedule via Process Scheduler • Run on-demand / stand-alone

• Run as a daemon (background) process for condition polling

• Part of PeopleTools

• Leverage existing logic and PeopleCode

• Send messages via Integration Broker

File Layout definitionaly maps file format (fixed, CSV or XML) to Record Definition and is used by AE for file processing.

• Click the “AE” button and Application Designer and will write the PeopleCode in an Application Engine with

JDeveloper

Graphical Mapper

Transform from one message format to another

22

JDeveloper

BPEL Designer

Free Products from Oracle

Only for PeopleSoft Users

Integration Broker is free for integrations involving any

release of PeopleSoft

• Available since PeopleTools 8.40

• Free is much less than what Tibco, WebMethods, BEA, IBM and Vitria charge for their EAI tools ($250-500k)

BPEL PM is free* for processes that interact with

PeopleSoft Apps and use PeopleTools 8.48 or higher

• Would otherwise cost $40,000 per CPU

• Can license BPEL PM and ESB for older releases of PeopleSoft

PeopleSoft

PeopleSoft

_PeopleSoft

$

PeopleSoft

_PeopleSoft

PeopleSoft

Non

Non

PeopleSoft

$

Non

Non

PeopleSoft

$

PeopleSoft

PeopleSoft

Non

Non

PeopleSoft

Non

Non

PeopleSoft

$

24

Get Started Now

Reasons to use Integration Broker:

• Good luck synching two PeopleSoft apps without it • Over 1200 delivered integrations ready for use

• Fusion Apps Services Workbench based on Integration Broker Service Designer 8.48

Reason to use Fusion Middleware:

• Easy way for IT dept. to assess Fusion technology and skills required before the apps are even released

• BPEL PM is free* with PeopleTools 8.48 • So is JDeveloper XSLT Graphical Mapper

• PeopleSoft CRM 9.0 will ship with delivered BPEL processes (other 9.0 apps probably will too)

• OC4J is free to use as PeopleSoft Web Server as of PeopleTools 8.47

• XML Publisher (reporting tool) free* – integrated and bundled with PeopleTools 8.48

*Limited use license

From Charles Phillips at

Collaborate 2006

PeopleSoft Enterprise 9.0:

“The releases introduce a number of

additional webservices that will allow the

26

PeopleSoft is already a Service Oriented Application

• Provides [web] services out of the box

• Includes the tools you need to provide and consume additional services

Fusion Middleware and BPEL PM can build on what you’ve

already created with PeopleSoft Integration Broker and take it to the next level with process orchestration

• Web services are building blocks

• Orchestrated processes are the house

If you need it, hiring consulting services to teach you how to use the free tools that Oracle licenses to PeopleSoft customers will cost you much less than the license of 3rd _{party EAI or process} orchestration tools

Q&A / More Information

For Technical Information:

Doron Avizov – Director PeopleSoft Services

[email protected]

To Hire The Burgundy Group:

James Ellis – Director Relationship Management

[email protected]

Telephone: (480) 325-7700

Address: 2420 S. Power Road, Mesa, AZ 85209

Web: www.theburgundygroup.com

Step by step instructions on using Integration Broker with BPEL PM:

28

Develop Orchestrate

Deploy

Access

Integrate

Monitor &

30

Timeline

PeopleTools optimized for Oracle Fusion Middleware

8.48

PeopleTools certified interoperable with Oracle Fusion Middleware

8.47

Integration Broker certified interoperable with Oracle BPEL PM

8.46

Create Web Services from any Application Message

8.44

Create Web Services from any Component Interface

8.42

SOAP WSDL

XML Gateway WSG

SOAP WSDL

Integration Broker

SOAP WSDL

y

All Oracle Applications can expose Web Services

y

No add on products required to get “Services”

Leverage existing application services to create

cross-application service enabled solutions

32

Fusion Middleware

A Proven Middleware Platform

Best of Breed Middleware

• Ranked #1 by Forrester Research • Placed in Gartner’s Magic Quadrant • 145+ Awards

• 220+ Patents

26,000+ customers; 7,500 + partners

• Fastest growing middleware in the industry • Fastest growing product business at Oracle

Based on Open Standards

Benefits

Seamless Integration between applications

• Easier to modify, change and extend your applications

• Adapt Oracle Applications to your Processes

Deeper more Adaptive Applications

• Support for Cross Functional / System Process Flows

Process Insight & Optimization

• Understanding of where you are in a process

34

36

BPEL Process Manager

Uptake PeopleSoft

PeopleSoft CRM 9.0

• First application to natively use BPEL

• Communications and Financial Industries

BPEL integration infrastructure

• End-user process monitor, targeted at a CSR

user

• Worklist integration from BPEL into CRM

• Enable key CRM transactions to instantiate

BPEL Process Manager

Uptake PeopleSoft

Process monitor

• Only show relevant tasks to the end user, not

low-level tasks, through a PSFT monitor

• Display ‘user friendly’ task descriptions

• Show tasks completed, in progress and not yet

started

Worklist integration

• Ability for CRM to receive a manual task from

BPEL

• Ability for CRM user to update task status and

progress the process

38

Oracle Fusion Architecture

Unified Portal

Unified Portal

Business Process Orchestration

Business Process Orchestration

Fusion Service Bus

Fusion Service Bus

Grid Computing Grid Computing Activity Activity Monitoring Monitoring

Fusion Service Registry

Fusion Service Registry

Business Business Intelligence Intelligence Oracle Oracle Apps Apps Custom Custom Apps Apps ISV ISV Apps Apps Lifecycle Management Lifecycle Management

Application Development Framework

Application Development Framework

Leverage and Extend Fusion Middleware to:

Deliver Deep, Adaptable Business Processes

• BPEL for unified system and human orchestration • Process Centric Development Methodology

• Collaborative Design between Analyst and IT

Enable Service Oriented Business Applications

• Provide Standard Based Canonical Model for core components • A business service repository to store, discover and deploy

business services

40

Forrester:

42

Create Order

Inventory Application Check Product Availability

1

Fulfillment Drop Ship Web S ervice

2

3

Save & Publish

4

Sales Order Asynchronous XML / HTTP Sales Order Asynchronous CSV / MQSeries

5

5

PeopleSoft Integration Broker

Q&A / More Information

For Technical Information:

Doron Avizov – Director PeopleSoft Services

[email protected]

To Hire The Burgundy Group:

James Ellis – Director Relationship Management

[email protected]

Telephone: (480) 325-7700

Address: 2420 S. Power Road, Mesa, AZ 85209

Web: www.theburgundygroup.com

Step by step instructions on using Integration Broker with BPEL PM: