Title: The Oracle SOA Suite How to Integrate Databases and Applications into SOA
1The Oracle SOA SuiteHow to Integrate Databases
and Applications into SOA
David Lundvall Sr. Fusion Middleware Solution
Specialistdavid.lundvall_at_oracle.com
2Agenda
- SOA
- SOA Suite Components Overview
- Order Booking Demo
- Database Integration
- Demo
- Applications Integration
- Oracle, Peoplesoft, Siebel, SAP
- Demo
3SOA Building Blocks
Packaged Legacy
Custom Apps Services
B2B
PROCESS ORCHESTRATION
4Key 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
5Orchestrate 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
6XSLT Mapper
FUNCTIONALITY
- Visual XSLT Mapping tool
- Caching and configurable validation
- Unit Debugger
- Code Conversions/Lookups
- Dictionaries for Smart mapping
- BPEL, ESB, PeopleSoft Tools
7The 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)
8Oracle 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)
9Some 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
10ESB 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
11Oracle 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
12Order Booking SOA DemoFocus on ESB, Rules, BPEL,
Workflow
SHOPPING PORTAL
Web Services Interface XML, SOAP, WSDL, WSIF
13D e m o n s t r a t i o nSOA Order Booking
14Oracle BAM Demo Scenario OrderBooking
15Oracle 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
16Database Integration
17Database 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
18Database 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
19List 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
20D e m o n s t r a t i o nDatabase Integration
21Applications Integration
22Oracle 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
23Design Time Introspection View
24Other 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
25D e m o n s t r a t i o nOrder Import
26SOA Customers
27A
http//otn.oracle.com/soa