Themabijeenkomst 17 april 2003

(1)

Evelyn Gerritsen ([email protected])

Jan Poortinga ([email protected])

Sales Consultants Oracle Nederland

(2)

(3)

Agenda

y

Waarom integratie

y

Diverse vormen van integratie

y

Oracle9

i

AS Interconnect

y

Huidige klanten

y

Klant case (Door Transfer Solutions)

y

Nieuwe functionaliteit in 9.0.4

y

Q & A

(4)

Ideal situation?

Integrated

Sell

side

-

In

side

-

Buy

side

Web Site

E

-

store

Customer

(

Self

) Service

Call

Center

Service

Providers

Suppliers

Partners

Corporate

Systems

(5)

Packaged

Applications,

E-mail, etc..

Mainframe

(Cics, IMS,

IDMS…..)

_{(ORCL, SAP}

ERP

etc..)

Home Grown,

Flat file,ftp,

etc..

Suppliers

(B2B)

Call Center

E-market (B2C)

Reality?

¾Consistent view of data?

¾

Available, Scalable?

¾

Business processes automated?

¾

Flexible?

(6)

Oracle Integration Spectrum

Direct Access

Gateways

Replication

Advanced Queuing

J2EE

Webservices

EAI (9

i

AS Integration)

Business Value

Integration

Complexity

Portal

(7)

Integration

Hub

Packaged

Applications,

E-mail, etc..

Mainframe

(Cics, IMS,

IDMS…..)

ERP

(Sap, Orcl etc..)

Home Grown,

Flat file,ftp,

etc..

Suppliers

(B2B)

Call Center

E-market (B2C)

(8)

Methodology - Hub & Spoke

Common

View

App View 1

(e.g: Financials)

Transformation

App View 2

(e.g: Order Entry)

App View 3

(e.g: Business Partner)

App View 4

(9)

A2A Process

Application

Integration

Hub

Common View OrderID = <nr> Amount = <nr> FirstName = <chr> LastName = <chr> Address = <chr>,<nr> OrderID = <nr> Amount = <nr> FirstName = <chr> LastName = <chr> Street = <chr> Nr = <nr> Application View

(10)

A2A Process

Application

Integration

Hub

OrderID = <nr> Amount = <nr> Name = <chr>,<chr> Address = <chr>,<nr> Application View OrderID = <nr> Amount = <nr> FirstName = <chr> LastName = <chr> Address = <chr>,<nr> Common View

(11)

(12)

Insert Personeel

Database

Adapter

FTP

Adapter

Integration

Hub

Personeel Object (XML)

insert into persoon_t

Business Object = Personeel

Event = Add_Personeel

(13)

Message Queuing and Distribution

Transformation

Application Connectivity

Business Process Coordination

Management Information

(14)

Message Queuing and Distribution

Integrated Database Message Queuing

Advanced Queues

(AQ)

Spoke Spoke Spoke Spoke Spoke Spoke Spoke Spoke

(15)

Messaging Paradigms

y

Publish/subscribe

–

One way communication

–

asynchronous

y

Request/Reply

–

Two way communication

–

Synchronous or asynchronous

y

Point to Point

(16)

DBAPP Oracle9iAS InterConnect

Subscribes to event:

CreatePO

CreateCust

Publishes events:

• CreatePO

• CreateCust

Subscribes to event:

CreateCust

(17)

Distributed Order

Fulfillment Applications

Country = UK Country = CH Country = …

if

ShipToCountry

=

‘

??

’

then route to (

‘

??

’

)

PO Common View

• OrderID

• ShipToCountry

• …

Oracle9iAS InterConnect

Publishes an event

DBAPP

(18)

Design, Transform & Map

Adapter

Metadata

Message

Queue

Integration Hub

Visual Design Tool:

–

Common View

–

Map

–

Transform

–

Route

–

Deploy

Workflow

Modeling

(19)

(20)

Insert Event

FTP

Adapter

FTP

Adapter

Integration

Hub

Input file met Event data : eventnaam, datum deelnemer1,...,...,...; deelnemer2,...,...,...;

Output file met Event data In XML formaat

Business Object = Event

Event = AddEvent

(21)

App

View

Common

View

Bridge

App

Transport and/or

Application Specific

Agent

Adapter

Metadata Driven

Transformation

Connectivity, transformation &

mapping

File/ftp

smtp

http(s)

MQ

AQ

DB

CICS

SAP

Siebel

Psft

JDE

SDK

(22)

Integration Hub

Workflow

Process Coordination/Approval

Order Entry

_Shipping

if order_amount > 5000 Then ask_approval New Order New Order approved

(23)

(24)

Insert Purchase Order

AQ Adapter

DB Adapter

Integration

Hub

Insert Purchase Order

Workflow

Approve Purchase Order > 50

Insert Purchase Order Orders < 50 +

goedgekeurde orders > 50

Business Object = Purchase_Order

Event = Create_PO

(25)

Insert Personeel

Database

Adapter

FTP

Adapter

Integration

Hub

Personeel Object (XML)

insert into persoon_t

Business Object = Personeel

Event = Add_Personeel

(26)

Automatically Audit, Track and Correlate every message

Business Process Intelligence

•Identify Bottlenecks

•Allocate resources intelligently

•Improve process Efficiency

•Discover process Patterns (Re)Modeling

Feedback Loop

Management Information

(27)

APPLICATION S E R V E R

J2EE and

Internet Applications

Information

Portal

Multi-Channel

Business

Intelligence

Application &

Process

Integration

Management &

Security

Fast & Reliable

(28)

(29)

Customers in NL

y

ALH B2B portaal

y

LNV Buro Heffingen

y

Boskalis

y

Urenco

y

CWI

y

Wehkamp

y

Port Infolink R’dam

y

Cadans

y

D-Reizen

y

ROC’s

y

CTB

y

KPN Pensioenfonds

y

Hermes Groep

y

Digitenne

y

Connexxion

y

Gemeenten:

Den Haag

Apeldoorn

Dordrecht

Maastricht

Tilburg

(30)

Case ALH

(31)

TKP CGEY Proof of Concept

“ Korte inleercurve, stabiel en goed

uitgewerkt product, 90% van de techniek

is al aanwezig en daarmee meer tijd

over voor het oplossen van het business

vraagstuk”

(32)

Release

(9

i

AS 9.0.4)

(33)

9

9 i

i

AS

InterConnect

Oracle9

i

AS Integration

Data

Integration

Application

Integration

Process

Integration

9

9 i

_i

AS

ProcessConnect

Business

Value

Integration

Complexity

(34)

Oracle9

i

AS Integration

Single Solution for A2A, B2B,

and Web Services

Business Process Management

B2B Integration Web Service Integration Enterprise Application Integration Single Integration Tool

Oracle9iAS Oracle E-Business Suite Packaged Applications Legacy Systems Trading Partners Suppliers Service

(35)

Oracle9

i

AS ProcessConnect

y

Single Standards-based Solution

y

Integrating Processes

y

Within and Outside the Enterprise

y

Monitor & Streamline Business Processes

y

Get a Consistent View of Information

(36)

Process-Based Integration Model

Context Partner Application Agreement Validate Transform Services Translate Translate Validate Transform

Data Flow RosettaNet_Message Application_Message Common_Message Application_Message _iDocSAP

Process Flow Application

Process SAP Seller Business Process Application Process PIP3A4 Buyer

(37)

Collaborations

B2B Services

Transports Packaging & Signing Document Exchange Collaboration • Http/s • Smtp • Ftp/s • MQ Series • Oracle AQ • JMS • … • SMIME 3.0 • SOAP 1.1 • … • XML • OAGIS • RNIF 2.0 • … • RosettaNet • Custom Party A Party B Parties/Roles Buyer Seller Seller Buyer RN3A4 – Request PO RN3A4 – Request PO

Agreement

B2B Services

Specifies B2B Collaboration and Communication Options Validates / Ensures Compliance with Agreements

(38)

Oracle’s RosettaNet Solution

y

Supply Chain Trading

Connector for RosettaNet

–

Uses XML Gateway to

Deliver/Consume OAG BODs

–

Notification Processing &

History Recording

y

Oracle9iAS Integration

–

PIP Choreography

–

Secure Communication

–

Document Validation

–

Document Transformation

–

Trading Partner Management

…. Supply Chain

Trading Connector

Oracle E-Business Suite

Internet Procurement Order Management XML Gateway Trading Partners RosettaNet Internet Oracle9iAS Integration RNIF 1.1/2.0 Process