The Oracle SOA Suite How to Integrate Databases

The Oracle SOA Suite How to Integrate Databases and Applications into SOA David Lundvall Sr. Fusion Middleware Solution Specialist david. lundvall@oracle. com

Agenda • 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 B 2 B PROCESS ORCHESTRATION ORCHESTRATE SERVICE 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 Sales. DB 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 Logistics B 2 B Partners A D A P T E R *Order to fulfillment Service Bus Shipping Instructions Fusion Middleware Manufacturing System 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, People. Soft 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 Built-in Integration Services • Flexible binding framework Web Service Java, JMS, JCA XQuery XSLT Oracle DB Dehydration Store (Oracle Database) User Notifi. Tasks cation File, FTP Database Core BPEL Engine BPEL Console J 2 EE Application Server (Oracle AS, Web. Logic, JBoss, Web. Sphere) MANAGE i. Way • Rich management and monitoring • Support for Oracle, JBoss, Web. Logic and Web. Sphere • 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 B 2 B Adapter BPEL Designer Rosetta. Net, UCCNet EDI, AS 2 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 Broad. Vision Clarify Commerce One Hogan Financials i 2 Technologies Lawson Livelink Manugistics Microsoft CRM Vantive Walker Interactive Remedy Salesforce. com Databases Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ Oracle 8 i 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 Uni. Verse Technology Ÿ SOAP Ÿ HTTP, HTTP-S Ÿ Email – POP 3, 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 get. Cust. Info Rules repository Rule Author Rules Engine Decision Service Manual Review ? Select. Mfr Rapid. Mfr invoke 5 -15 min ESB receive Web Services Interface: XML, SOAP, WSDL, WSIF Insert Order EJB 3. 0 Customer service Approval (Rich Workflow) Product Suppliers Fulfill Order Fed. Ex USPS Notify Cust end Notification Service

Demonstration SOA Order Booking

Oracle BAM: Demo Scenario: Order. Booking

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 Top. Link BAM Persistence Manager Object Data Conversion PORTAL Query ESB Cache Mappings TX BPEL PM J W C S A I F J 2 EE Applications 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 JDBC 1. x, 2. 0 between relational and object schemas. Expressions support for visually building complex Oracle, Informix, DB 2, 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 DB 2 Ÿ IBM DB 2 on AS/400 Ÿ Sybase Ÿ Microsoft SQL Server Ÿ My. SQL Ÿ HSQL Ÿ Informix Ÿ Cloudscape Ÿ Point. Base Ÿ 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 • People. Tools 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 • JDE OW XE B 7. 3. 3. 3 and B 7. 3. 3. 4 (8. 0) • Comprehensive support for GEN JAVA Business Functions • Real-time guaranteed event publish. • Dynamic design-time introspection • 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 SAP • SAP R/3 3. 1 H 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

Demonstration Order Import

SOA Customers

Q& A QUESTIONS ANSWERS http: //otn. oracle. com/soa