Transcript Oracle SOA Suite - How to Integrate Databases and

The Oracle SOA Suite
How to Integrate Databases and Applications into SOA
David Lundvall
Sr. Fusion Middleware Solution Specialist
[email protected]
Agenda
• SOA
• SOA Suite Components Overview
• Order Booking Demo
• Database Integration
• Demo
• Applications Integration
• Oracle, Peoplesoft, Siebel, SAP
• Demo
SOA Building Blocks
Optimize
Richer Experience
Business Agility
Secure Transport
More Interoperable
Packaged &
Legacy
Portal
Web Application
PKI
Dashboards
Process Flow
Logic
Security
Reliability
Logging
Failover
Dynamic Routing
Custom Apps
& Services
WS
API
MONITORING
USER INTERFACE
B2B
PROCESS
ORCHESTRATION
ORCHESTRATE
SERVICE BUS
BUSINESS SERVICES
BAM
PORTAL JSR-168
BPEL
WS-Security
XML/XML Schema
JMX
Struts/JSF
XSLT/XQuery
WS-Policy, SAML
WSDL/WSIF
Business Rules
Web Services Mgmt
SOAP
JCA
JMS
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 R&D from
Duplicate
Number!
MSFT and IBM
• Rich Flow Semantics
• Optimized Bindings
Billing
• XPATH+XSLT+XQuery
• WS-Security
• A Process is a Service
Router
end
Orchestrate Services
Oracle
Siebel
SAP
Financial
System
Order Entry
System
A
D
A
P
T
E
R
Supply Chain
System
ATP
Orders
WSDL
A
D
A
P
T
E
R
Credit Check
Partner
Custom
BPEL
Manufacturing
System
Logistics B2B
Partners
A
D
A
P
T
E
R
*Order to fulfillment
Service Bus
Shipping
Instructions Fusion Middleware
W
S
D
L
Product
Readiness
XSLT Mapper
FUNCTIONALITY
• Visual XSLT Mapping tool
• Caching and configurable validation
• Unit Debugger
• Code Conversions/Lookups
• Dictionaries for “Smart” mapping
• BPEL, ESB, PeopleSoft Tools
The Oracle BPEL Process Manager
Enterprise-strength infrastructure for designing,
deploying and managing BPEL business processes.
Eclipse, JDeveloper
• Comprehensive and native
BPEL Designer
BPEL implementation
BPEL
• Easy-to-use modeling tool
• Scalable and reliable engine
BPEL Process Manager
WSDL Binding
• Flexible binding framework
Built-in Integration Services
Web Service
Java, JMS, JCA XQuery XSLT
Oracle DB
Dehydration
Store
(Oracle Database)
User NotifiTasks cation
File, FTP
Database
Core BPEL Engine
BPEL Console
J2EE Application Server
(Oracle AS, WebLogic, JBoss, WebSphere)
MANAGE
iWay
• Rich management and
monitoring
• Support for Oracle, JBoss,
WebLogic and WebSphere
• Get up and running in less
than 15 minutes!
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
User Workflow
Enterprise Data Hub
Data Virtualization, Data Synchronization
Notification Services (Mail, Wireless)
Identity Services (OID, LDAP, JAZN)
Some of the Adapters Available for
Oracle SOA Suite…
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
Microsoft CRM
Vantive
Walker Interactive
Remedy
Salesforce.com
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
PROGRESS
Red Brick
RMS
SAS Transport Format
Teradata
Unisys DMS 1100/2200
UniVerse
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
Natural
Tuxedo
CA-Datacom
Screen Scraping
C-ISAM,D-ISAM,K-SAM,
QSAM
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
facts
Rules
results Engine
Application
Rules de-couple decision services from SOA applications
Operational dashboard
Order Booking SOA Demo
Focus on ESB, Rules, BPEL, Workflow
SHOPPING PORTAL
ESB
Order Booking BPEL PROCESS
BAM
receive
Order DB
getCustInfo
Rules
repository
Rules
Engine
Rule Author
Decision
Service
Manual
Review
?
SelectMfr
RapidMfr
invoke
invoke
5-15 min
ESB
receive
receive
Web Services Interface: XML, SOAP, WSDL, WSIF
Insert Order
EJB 3.0
Customer service
Approval
(Rich Workflow)
Product
Suppliers
Fulfill Order
FedEx
USPS
Notify Cust
Notification
Service
end
Demonstration
SOA Order Booking
Oracle BAM: Demo Scenario:
OrderBooking
Database Integration
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
Database Adapter
• Leverages proven TopLink
BAM
TopLink
Object Data
Conversion
Persistence
Manager
Query
Cache
Mappings
TX
technology and performs
object to relational mapping.
J W
C S
A I
F
PORTAL
ESB
BPEL PM
J2EE
Applications
• 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
JDBC 1.x, 2.0
between relational and object
schemas. Expressions support
for visually building complex
Oracle, Informix, DB2,
MSSQL, Sybase
queries
• Supports JTA transactions
• Caching for high performance
List of databases supported by
Oracle Database Adapter
DB Adapter supports any JDBC 1.x/2.0 compliant
databases.








Oracle Database
Oracle Times-Ten Database
IBM UDB DB2
IBM DB2 on AS/400
Sybase
Microsoft SQL Server
MySQL
HSQL







Informix
Cloudscape
PointBase
Microsoft Access
Dbase
SQL Anywhere
CA-Datacom
Demonstration
Database Integration
Applications Integration
Oracle Applications Adapter
Service enables Oracle Apps
 Version Awareness
 Interfaces with Integration
EDI Gateway
Repository
 Integrates via Open
XML
Gateway
Oracle
E-Business
Suite
Adapter
Interfaces and Stored
Procedures for inserting
Workflow
BES
Interface
Tables,
Concurrent
Mgr
Stored
Procedures
data into Oracle
Applications.
 Bi-directional XML
integration with XML and
EDI Gateway for exchanging
OAG based XML/EDI
documents.
 Implicit Applications
Context
Design Time Introspection View
Other Packaged Application Adapter –
Features
PEOPLESOFT
• PeopleTools 8.1.x,
8.2.x, 8.4.x
• Comprehensive
support for
Component
Interface and
Application
Messages/Integrati
on Broker
technologies
• Guaranteed event
delivery
• Dynamic designtime introspection
• Highly scalable
J.D.EDWARDS
SIEBEL
SAP
• 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 designtime introspection
• Siebel 7
• Comprehensive
support for RFC,
IDOC/ALE and BAPI
• Real-time
guaranteed event
publish.
• Dynamic designtime introspection
(SAP Integration
Repository – IFR)
• Highly scalable
• SAP R/3 3.1H to 4.7
• Comprehensive
support for RFC,
IDOC/ALE and BAPI
• Real-time
guaranteed event
publish.
• Dynamic designtime introspection
(SAP Integration
Repository – IFR)
• Highly scalable
Demonstration
Order Import
SOA Customers
QUESTIONS
ANSWERS
http://otn.oracle.com/soa