CON8430_Shanmugamx - ACTIVEevents.com

joeneetscompetitiveSecurity

Nov 3, 2013 (3 years and 7 months ago)

165 views

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

1

Web Services and SOA
Integration Options for
Oracle E
-
Business Suite

Veshaal

Singh

Senior Director, Application Technology


Vijay
Shanmugam
,

Senior Manager, Application Technology

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

3

Program Agenda


SOA in Oracle E
-
Business Suite


Oracle Applications Adapter


Integrated SOA Gateway


What is New in Release 12.2?


Road map

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

4

SOA in Oracle E
-
Business
Suite


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

5

SOA in Oracle E
-
Business Suite

Adopting New Technologies … Evolving Functionalities

1

Integration Repository
:
Catalogue of Integration
interfaces

Oracle Applications Adapter
:
Database related interfaces
exposed as Web Services from
Fusion Middleware

Web Service Provider
:

BSO, XML Gateway interfaces
exposed as Web Services

Integrated SOA Gateway
:

Web Service Management, Monitoring
from Integration Repository

5

SOA Suite 11g
Uptake for Service
Provisioning

2

3

4

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

6

SOA based Integration Options

Fusion Middleware

Oracle SOA Suite

Oracle E
-
Business
Suite Adapter

Applications Unlimited

Oracle E
-
Business
Suite

Integrated SOA
Gateway

All Supported E
-
Business
Suite Releases

R12.1+

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

7

Oracle E
-
Business Suite
Adapter


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

8

Oracle E
-
Business Suite Adapter


Multiple Oracle EBS versions supported


Leverages Integration Repository


Customization Support


Secured and Trusted Connection


Functional Security Enabled


Application Context Ready


Transaction Support

Key Features

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

9

Integration Solution Overview

XML & e
-
Commerce

Gateway

Open Interface Table &

Concurrent Programs

PL/SQL API, Views,
Business Events

Integration Repository

Oracle SOA Suite

EBS

Adapter

ESB

B2B

BPEL PM

BAM

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

10

Oracle E
-
Business Suite Adapter Life Cycle

JDeveloper

Develop

SOA Composite
/
OSB

Orchestrate / Event

Oracle EBS Security


Access Control

Adapter Framework

Integrate: Technology

Enterprise Manager

Monitor & Manage

Integration Repository

Integrate: Content

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

11

Oracle E
-
Business Suite Adapter from BPEL

Run Time

Design Time

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

12

Oracle E
-
Business Suite
Integrated SOA Gateway

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

13

Oracle EBS Integrated SOA Gateway

SOA
-
based integration infrastructure that helps organizations to provide, consume and monitor Web services for
integrations in a heterogeneous ecosystem.

Bi
-
directional SOA

Out
-
of
-
the
-
box SOA Enablement

Integration Repository

Service Invocation
Framework

Service
Provider

Register

Find

Provide Service

Consume Service

Generate

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

14

Catalogue of EBS Integration Interfaces

Standardized Documentation

Search & Browse Interfaces

Web Service Management

Seeded + Custom Interfaces

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

15

Service Provider


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

16

Expose EBS & Custom Interfaces as Web
Services

XML
Gateway

PL/SQL
APIs

Business
Event

Business Service
Objects

Java APIs for
Forms

Oracle E
-
Business Suite
Web Services can be
consumed by standard
web service client

Service Provider

Web Services

Concurrent
Program

Custom interfaces

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

17

Simple UI Steps to Expose Interface as Secure
Web Service

Life Cycle

1. Upload API to


Integration Repository

2. Generate

3. Deploy

4. Authorize

5. Invoke

6. Monitor Service



Invocations

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

18

Generate Service

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

19

Deploy Service

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

20

Deployed Service

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

21

Authorize Service

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

22

Invoke Service


EBS Web service

PROCESS_ORDER_1037895

InvokeProcessOrder

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

23

Service Monitor

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

24

Service Invocation
Framework


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

25

Invoke & Consume Web Services from EBS

PL/SQL
APIs

Forms

SOAP based standard web
services

Service Invocation
Framework

(Web Service Consumer)

Java APIs

Workflow

Concurrent
Programs

(Java/ PLSQL)

OAF pages

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

26

Event driven Service Invocation

Developer Experience

2. Security
Credentials

3. Prepare
Input Message

5. Test Service

6. Raise
Invoker Event

1.
Service


Metadata

1. Define Service
Metadata

4. Consumption &
Exception Logic

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

27

Define Invoker Event

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

28

Define Invoker Subscription

Select Action Type

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

29

Wizard based WSDL Parser

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

30

Wizard based WSDL Parser

Select Service Operation

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

31

Wizard based WSDL Parser

Enter Additional Parameters

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

32

Test Service Invocation from BES

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

33

What happens at Run
-
time?

External Web
Service

Oracle E
-
Business Suite

Service Invocation Framework

Invocation Source

Firewall

Consumption
Destination

Callback
Event

Event
Payload

To Service
Endpoint

SOAP
Request

Embed custom
SOAP Headers

Embed WS
-
Security headers

XSL
Transformation

Service
Metadata

SOAP
Response

XSL
Transformation

Invoker
Event

Event
Payload

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

34

EBS & Fusion General Ledgers Coexistence

Through Hyperion DRM

Oracle E
-
Business Suite

General Ledger

Oracle Fusion Applications
General Ledger

Hyperion Data Relationship Management

Chart of Accounts
Values

Chart of Accounts
Hierarchies

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

35

EBS General Ledger with Hyperion DRM

Oracle Hyperion DRM

Oracle E
-
Business Suite

(3) Invoke Web Service to initiate
data export process

(1) Update
CoA

Values
and Hierarchies

DRM Web Service

Service Consumer

Service Provider

(2) Load Segment Values and
Hierarchies Request

(5) Validate and
move data

Base
Tables

ISG

SIF

Java

CP

DRM
Tables

Interface
Tables

(4) Export
CoA

Values / Hierarchies to
EBS Interface Tables

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

36

Integrated SOA Gateway
for EBS Mobile Application
Services


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

37

Mobile Application Development for EBS

High Level Architecture

Clients

Security

Data Services

Native


iOS
, Android

HTML5

Hybrid


ADF Mobile

Authentication

Authorization

Access Control

Integrated SOA Gateway

SOA Suite / EBS Adapter

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

38

Architecture

What’s Inside?

PL/SQL
APIs

BSO

Interface
Tables

Java
APIs

CP

Interface
Views

EC
Gateway

XML
Gateway

Integration Repository

Integrated SOA Gateway

Username
Token

Authentication
Services

Access
Control

Oracle E
-
Business Suite

Business Logic Layer

User Interface Layer

SOAP Web Services

SOAP/XML

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

39

ADF Mobile and E
-
Business Suite

How to put them all together?

Identify EBS APIs

Develop New APIs

Publish in IREP

Generate SOAP Service

Secure Service

Latest ADF Mobile 1.1

Task Flows, Pages

Create SOAP DCs

SOAP Provider

Create Page Bindings

Test in Simulator

Setup Authentication

Setup Authorization


Apps Context Header

Credential

Key

Deploy and
Configure

Develop App

Secure

Develop Services

Design

Build

App

Test on Device

Release App

Host Configuration Files

Deploy to User Devices

Document and Train

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

40

EBS Security Services

Login Service

SOAP Service 1

SOAP Service 2

Logout Service

Access Control Service

Capture Username and
Password

Security

Security

Data Services

HTTP
BasicAuth

Load Roles and Privileges

Header (
UsernameToken
, EBS Context)

Body (Payload


XML)

EBS Session Cookie

Integration
Repository

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

41

What is New in Release
12.2?


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

42

What is New in Release 12.2?


Service Provider


Built on top of Oracle SOA Suite 11g


Support for Asynchronous Web Services


Service Invocation Framework


Built on top of JAX
-
WS from
WebLogic

Server 11g


Improved customization & extension support


Configure Username Token security from UI

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

43

Architectural Changes in Release 12.2

Integrated SOA Gateway

Service Provider

Adapter
Framework

JAX
-
RPC

Service Invocation
Framework

Business Event System

Oracle Application Server 10g for E
-
Business Suite

WSIF

E
-
Business Suite R12.1.3

Integrated SOA Gateway


WebLogic

Server 11g for
SOA Suite

Service Provider

Oracle Applications
Adapter

Oracle SOA Suite 11g

Service Invocation
Framework

Business Event System

WebLogic

Server 11g for E
-
Business Suite

JAX
-
WS

E
-
Business Suite R12.2

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

44

Decoupled & Scalable Architecture

EBS WLS Installation

Domains

EBS Domain

Managed
Servers

Applications & Shared
Libraries

oa core

oafm

ISG JMX
Client

SOA Suite WLS Installation

Oracle E
-
Business Suite

Oracle SOA Suite

Over
HTTP

Over
T3

EBS
Database

SOA Suite
Database

Domains

EBS SOA Domain

Managed
Servers

Applications & Shared
Libraries

ISG

SOA
Infra

Adapters

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

45

Extend Business Service Portfolio

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

46

Support for Asynchronous Web Services

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

47

Roadmap


Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

48

EBS Integration Interfaces as REST Services

Beyond R12.2

Oracle E
-
Business Suite

Application Logic

(HR,

Projects, Finance, Order, Procure, Shipping)

Integration Interfaces

PL/SQL

Business
Service Object

XML Gateway

Concurrent
Program

Open
Interface

Java

Integrated SOA Gateway

(SOAP & REST Web Services)

SOAP

REST

Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

49

UI Experience for REST Services

Roadmap

One Step Deploy

Described in WADL

Service Alias for Simplified
End Point

Pre
-
Configured Setup

Support for JSON & XML

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

50

REST Services described in WADL

Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

51

Roadmap


Service Provider


Service enable Java APIs, Open Interface Tables/ Views


Transaction support in distributed processing


Advanced Web Service Standards


Reliable Messaging, MTOM


Advanced Interface Management


Monitor, analyze change impact


Enhanced custom interface management


Custom categorization of custom interfaces

Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

52

Roadmap


Service Invocation Framework


Support for Asynchronous Web Services


Support for REST Services


Monitor Service Invocations


Advanced Web Service standards


SAML, MTOM, Reliable Messaging


Enhanced Service Invocation Framework UI


Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

53

ADF Mobile and E
-
Business Suite

Towards a better Mobile Platform

Identify EBS APIs

Develop New APIs

Publish in IREP

Generate SOAP Service

Secure Service

Latest ADF Mobile 1.1

Task Flows, Pages

Create SOAP DCs

SOAP Provider

Create Page Bindings

Test in Simulator

Setup Authentication

Setup Authorization


Apps Context Header

Credential

Key

Deploy and
Configure

Develop App

Secure

Develop Services

Design

Build

App

Test on Device

Release App

Host Configuration Files

Deploy to User Devices

Document and Train

Patterns

Reference
Flows

REST Service

JSON

Mobile SDKs

Sample Apps

Cookie, Token

Basic Auth

Configuration Server

Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

54

Architecture

PL/SQL
APIs

BSO

Interface
Tables

Java
APIs

CP

Interface
Views

EC
Gateway

XML
Gateway

Integration Repository

Integrated SOA Gateway

Username
Token

Authentication
Services

Access
Control

Oracle E
-
Business Suite

Business Logic Layer

User Interface Layer

SOAP

Roadmap

REST

EBS SDK for Mobile

SOAP/XML

REST/JSON

BC4J

Security
Services

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

55

Worklist

Roadmap

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

56

Worklist

App
-

Demo

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

57

Key Takeaways


Web Service based integration


Embrace EBS’s native Web Service enablement:


Service Provider


Service Invocation Framework


Agile design
-
to
-
deploy Web Service integration


Integrated SOA Gateway for EBS mobile application services


Re
-
use existing investment in EBS customizations

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

58

Copyright

©

2012, Oracle and/or its affiliates. All rights reserved.

Insert Information Protection Policy Classification from Slide 12

59