1 / 25

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

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 SOA Suite Components Overview Order Booking Demo Database Integration Demo Applications Integration

rod
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Oracle SOA SuiteHow to Integrate Databases and Applications into SOA David Lundvall Sr. Fusion Middleware Solution Specialistdavid.lundvall@oracle.com

  2. Agenda • SOA • SOA Suite Components Overview • Order Booking Demo • Database Integration • Demo • Applications Integration • Oracle, Peoplesoft, Siebel, SAP • Demo

  3. WS Optimize Richer Experience Business Agility More Interoperable Secure Transport Portal Security Reliability Logging Failover Dynamic Routing Web Application PKI Dashboards Process Flow Logic API MONITORING USER INTERFACE SERVICE BUS BUSINESS SERVICES ORCHESTRATE XML/XML Schema BAM PORTAL JSR-168 BPEL WS-Security WSDL/WSIF JMX Struts/JSF WS-Policy, SAML XSLT/XQuery Web Services Mgmt SOAP JCA JMS Business Rules 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 R&D from MSFT and IBM • Rich Flow Semantics • Optimized Bindings • XPATH+XSLT+XQuery • WS-Security • A Process is a Service Duplicate Number! Billing Router end

  5. ATP Orders Credit Check Shipping Instructions Product Readiness 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 Partner Custom 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 Systems Technology Adapters (JMS, AQ, File, FTP, DB ..) 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 • Natural • Tuxedo • CA-Datacom • Screen Scraping • C-ISAM,D-ISAM,K-SAM, QSAM • 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

  10. facts RulesEngine results Application 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

  11. Operational dashboard ESB Order Booking BPEL PROCESS BAM receive Rule Author Insert Order getCustInfo Rulesrepository EJB 3.0 Customer service RulesEngine DecisionService Manual Review ? SelectMfr RapidMfr invoke invoke 5-15 min receive receive ESB Approval (Rich Workflow) Product Suppliers FedEx USPS Fulfill Order Notify Cust Notification Service Order DB end Order Booking SOA DemoFocus on ESB, Rules, BPEL, Workflow SHOPPING PORTAL Web Services Interface: XML, SOAP, WSDL, WSIF

  12. D e m o n s t r a t i o nSOA Order Booking

  13. Oracle BAM: Demo Scenario: OrderBooking

  14. Database Integration

  15. 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

  16. Query Cache TX 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

  17. 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

  18. D e m o n s t r a t i o nDatabase Integration

  19. Applications Integration

  20. 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

  21. Design Time Introspection View

  22. Other Packaged Application Adapter – Features PEOPLESOFT J.D.EDWARDS SIEBEL SAP • 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 • 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 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

  23. D e m o n s t r a t i o nOrder Import

  24. SOA Customers

  25. Q & Q U E S T I O N S A N S W E R S A http://otn.oracle.com/soa

More Related