The Oracle SOA Suite How to Integrate Databases and Applications into SOA - PowerPoint PPT Presentation

About This Presentation
Title:

The Oracle SOA Suite How to Integrate Databases and Applications into SOA

Description:

The Oracle SOA Suite How to Integrate Databases and Applications into SOA David Lundvall Sr. Fusion Middleware Solution Specialist david.lundvall_at_oracle.com – PowerPoint PPT presentation

Number of Views:543
Avg rating:3.0/5.0
Slides: 26
Provided by: nocougOrg
Learn more at: http://www.nocoug.org
Category:

less

Transcript and Presenter's Notes

Title: The Oracle SOA Suite How to Integrate Databases and Applications into SOA


1
The Oracle SOA SuiteHow to Integrate Databases
and Applications into SOA
David Lundvall Sr. Fusion Middleware Solution
Specialistdavid.lundvall_at_oracle.com
2
Agenda
  • SOA
  • SOA Suite Components Overview
  • Order Booking Demo
  • Database Integration
  • Demo
  • Applications Integration
  • Oracle, Peoplesoft, Siebel, SAP
  • Demo

3
SOA Building Blocks
Packaged Legacy
Custom Apps Services
B2B
PROCESS ORCHESTRATION
4
Key Standards BPEL and Process Orchestration
Markup language for composing a set of discrete
services into an end-to-end process flow
SalesDB
start
  • 10 years of RD from MSFT and IBM
  • Rich Flow Semantics
  • Optimized Bindings
  • XPATHXSLTXQuery
  • WS-Security
  • A Process is a Service

Duplicate Number!
Billing
Router
end
5
Orchestrate Services
Oracle
Siebel
SAP
Financial System
Order Entry System
Supply Chain System
A D A P T E R
A D A P T E R
WSDL
Custom
Partner
BPEL
Manufacturing System
Logistics B2BPartners
WSDL
A D A P T E R
Service Bus
Fusion Middleware
Order to fulfillment
6
XSLT Mapper
FUNCTIONALITY
  • Visual XSLT Mapping tool
  • Caching and configurable validation
  • Unit Debugger
  • Code Conversions/Lookups
  • Dictionaries for Smart mapping
  • BPEL, ESB, PeopleSoft Tools

7
The Oracle BPEL Process Manager
  • Enterprise-strength infrastructure for
    designing, deploying and managing BPEL business
    processes.

Eclipse, JDeveloper
  • Comprehensive and native BPEL implementation
  • Easy-to-use modeling tool
  • Scalable and reliable engine
  • Flexible binding framework
  • Rich management and monitoring
  • Support for Oracle, JBoss, WebLogic and
    WebSphere
  • Get up and running in less than 15 minutes!

BPEL Designer
BPEL
BPEL Process Manager
Built-in Integration Services
WSDL Binding
Web Service
Oracle DB
Dehydration Store (Oracle Database)
User Tasks
Notifi- cation
Java, JMS, JCA
XQuery
XSLT
File, FTP
Core BPEL Engine
Database
BPEL Console
iWay
MANAGE
J2EE Application Server (Oracle AS, WebLogic,
JBoss, WebSphere)
8
Oracle BPEL Process Manager
Comprehensive integration platform for connecting
systems, services, people and partners
Eclipse, JDeveloper
B2B Adapter
BPEL Designer
RosettaNet, UCCNet
EDI, AS2
Partners
XML Web Services (Sync. and Async.)
Java Services (EJB, Java ..)
Portal
Services
Data Transformation (XSLT, XQuery)
Rules and Decision Services
Application Server
Technology Adapters (JMS, AQ, File, FTP, DB ..)
Systems
ADF
BPEL PM
Enterprise Application Adapters (Oracle, PSFT,
SAP ..)
Legacy System Adapters (CICS, IMS ..)
BPEL Console
People
Enterprise Data Hub Data Virtualization, Data
Synchronization
Notification Services (Mail, Wireless)
User Workflow
Identity Services (OID, LDAP, JAZN)
9
Some of the Adapters Available for Oracle SOA
Suite
  • Technology
  • SOAP
  • HTTP, HTTP-S
  • Email POP3, SMTP, IMAP
  • FTP, FTP-S
  • Flat File
  • JMS
  • Oracle AQ
  • IBM MQSeries
  • LDAP
  • TIBCO Rendezvous
  • Socket
  • Legacy
  • CICS
  • IMS/DB
  • IMS/TM
  • VSAM
  • CA-IDMS
  • ADABAS
  • Databases
  • Oracle 8i and above
  • IBM DB/2 UDB
  • Informix
  • Microsoft SQL Server
  • Sybase
  • Clarion
  • Clipper
  • Cloudscape
  • DBASE
  • Dialog
  • Essbase
  • FOCUS Data Access
  • Great Plains
  • MUMPS (Digital Standard MUMPS)
  • Navision Financials (ODBC 3.x)
  • Nucleus
  • Paradox
  • Pointbase
  • Applications
  • Oracle Applications
  • SAP R/3
  • Peoplesoft
  • JD Edwards
  • Siebel
  • Clarify
  • Lotus Notes
  • Ariba
  • AXIOM mx/open
  • Baan
  • BroadVision
  • Clarify
  • Commerce One
  • Hogan Financials
  • i2 Technologies
  • Lawson
  • Livelink
  • Manugistics

10
ESB Patterns
  • Virtualized Service
  • 2 way sync
  • Content based responder
  • Static inbound WSDL
  • Operational flexibility
  • Fan In/Out
  • 1 way store and fwd
  • Sync or Async
  • Multiple transactions
  • End to end
  • Response Forward
  • 1 way inbound
  • 2 way outbound
  • Route based on callout response
  • Forward original document

11
Oracle Business Rules Engine
  • Best Practice for SOA Applications
  • Agility
  • Centralization of business rules
  • IT and business user roles
  • Rules are a way to specify conditional actions
  • If salary is less than 30,000 then don't grant
    the loan
  • If miles flown is greater than 50,000 then grant
    platinum status
  • How are Rules Represented
  • Can be represented as simple if-then statements
  • Are declarative, not procedural
  • Can be configured by UI application

Rules de-couple decision services from SOA
applications
12
Order Booking SOA DemoFocus on ESB, Rules, BPEL,
Workflow
SHOPPING PORTAL
Web Services Interface XML, SOAP, WSDL, WSIF
13
D e m o n s t r a t i o nSOA Order Booking
14
Oracle BAM Demo Scenario OrderBooking
15
Oracle BAM Architecture
Event Engine
Event Engine
Message Center
Alerts
Mobile Devices, Email
Active Data Cache
Real time streaming (push) of Incremental updates
Message Queues
API
Fire Event
Enterprise Link
ViewSets
Report Cache
Report Server
Kernel
Data Flow Service
Snapshots ChangeLists
Views
DataSets
Internet
Plan Monitor
Data Formatting
DSE
Memory / Disk
Operational Data
Dashboards combining Real-Time Information,
Historical Information, Alerts Actions
Oracle Database Grid
Data Warehouse
16
Database Integration
17
Database Adapter Overview
  • Enables an activity in a BPEL process to
  • Poll the database at a regular interval, looking
    for new rows to process (inbound)
  • Insert/Update/Merge/Delete/Select (outbound)
  • Execute a stored procedure
  • Execute custom SQL
  • Acts as an X-R mapping engine

18
Database Adapter
  • Leverages proven TopLink technology and performs
    object to relational mapping.
  • Supports a variety of DML operations.
  • Support multiple ways to publish database events.
  • Robust Query Framework
  • Rapid, easy-to-use, JDeveloper wizard-driven
    modeling to map between relational and object
    schemas. Expressions support for visually
    building complex queries
  • Supports JTA transactions
  • Caching for high performance

BAM
Persistence Manager
PORTAL
Object Data Conversion
ESB
W S I F
J C A
TopLink
Mappings
BPEL PM
JDBC 1.x, 2.0
J2EE Applications
Oracle, Informix, DB2, MSSQL, Sybase
19
List of databases supported by Oracle Database
Adapter
DB Adapter supports any JDBC 1.x/2.0 compliant
databases.
  • Informix
  • Cloudscape
  • PointBase
  • Microsoft Access
  • Dbase
  • SQL Anywhere
  • CA-Datacom
  • Oracle Database
  • Oracle Times-Ten Database
  • IBM UDB DB2
  • IBM DB2 on AS/400
  • Sybase
  • Microsoft SQL Server
  • MySQL
  • HSQL

20
D e m o n s t r a t i o nDatabase Integration
21
Applications Integration
22
Oracle Applications AdapterService enables
Oracle Apps
  • Version Awareness
  • Interfaces with Integration Repository
  • Integrates via Open Interfaces and Stored
    Procedures for inserting data into Oracle
    Applications.
  • Bi-directional XML integration with XML and EDI
    Gateway for exchanging OAG based XML/EDI
    documents.
  • Implicit Applications Context

EDI Gateway
Oracle E-Business Suite Adapter
XML Gateway
Workflow BES
Interface Tables, Concurrent Mgr
Stored Procedures
23
Design Time Introspection View
24
Other Packaged Application Adapter Features
PEOPLESOFT
J.D.EDWARDS
SAP
SIEBEL
  • PeopleTools 8.1.x, 8.2.x, 8.4.x
  • Comprehensive support for Component Interface and
    Application Messages/Integration Broker
    technologies
  • Guaranteed event delivery
  • Dynamic design-time introspection
  • Highly scalable
  • JDE OW XE B 7.3.3.3 and B7.3.3.4 (8.0)
  • Comprehensive support for GEN JAVA Business
    Functions
  • Real-time guaranteed event publish.
  • Dynamic design-time introspection
  • SAP R/3 3.1H to 4.7
  • Comprehensive support for RFC, IDOC/ALE and BAPI
  • Real-time guaranteed event publish.
  • Dynamic design-time introspection (SAP
    Integration Repository IFR)
  • Highly scalable
  • Siebel 7
  • Comprehensive support for RFC, IDOC/ALE and BAPI
  • Real-time guaranteed event publish.
  • Dynamic design-time introspection (SAP
    Integration Repository IFR)
  • Highly scalable

25
D e m o n s t r a t i o nOrder Import
26
SOA Customers
27
A
http//otn.oracle.com/soa
Write a Comment
User Comments (0)
About PowerShow.com