400 likes | 784 Views
Milton Wan Director Product Management Oracle Corporation. Connect Your Business Applications with the Enterprise: A Step By Step Guide. Agenda. eBusiness Demands Integration Oracle E-Business Suite connectivity to 3rd party applications, and B2B standards
E N D
Milton WanDirector Product Management Oracle Corporation
Connect Your Business Applications with the Enterprise: A Step By Step Guide
Agenda • eBusiness Demands Integration • Oracle E-Business Suite connectivity to 3rd party applications, and B2B standards • Oracle Application Server Integration • A Step-By-Step Guide
TradingPartners OracleE-BusinessSuite BusinessProcesses Customers PackagedApplications Internet ServiceProviders LegacySystems Web Services Business Application Integration Business to Business (B2B) Enterprise Application Integration (EAI)
Legacy Legacy Legacy Your Integration Burden Grows With Each Additional Application • Multiple Vendors • Multiple Interfaces • Complex Support
But You Are Not Alone “35% of all IT spending is for application integration” Gartner Group “60% of the implementation cost of an ERP package is spent on integration.” Meta Group “50% of my IT budget is spent on interfacing.” CIO, Major Insurance Company Forrester Research
Deploying Oracle E-Business SuiteIntegration Challenges How to connect to: • Non-Oracle packaged applications (SAP, Peoplesoft, etc.)? • Proprietary legacy applications? • Trading partners via emerging business-to-business protocols? • Service providers (Web Services)?
Oracle Integration is Based Entirely on Open Standards • Delivers Messages thatare Immediately Usable • Less Integration Investment • Bring More Partners Online, Faster, Cheaper Oracle E-Business Suite OracleApplication Server 10g Standards-Based
Data XML Documents Web Services Open Access to Business Flows All OracleApplications Oracle E-Business SuiteOpen, Standards-based Communication Service-EnabledBusiness Flows Standards-BasedInterfaces Exploit OracleASConnectivity • 3rd Party Applications • B2B Standards • Web ServicesStandards
Applications Technology Infrastructure Open InterfaceTables XML Gateway, SCTC WebServices Oracle E-Business SuiteHigh Level Integration Architecture Oracle E-Business Suite Service-EnabledBusinessFlows Order Management Manufact Procurement Planning Financial Standards-basedInterfaces
Workflow System A P P L I C A T I O N Application Business Event System • New Order • Update Order • Cancel Order AQs Inbound Message Application Outbound Message A ‘Business Events’ Driven Integration Infrastructure • Exposes integration points as OAG XML documents on a JMS queue, or as Web Services
Oracle eBusiness Suite Applications Technology Infrastructure Open InterfaceTables XML Gateway, SCTC WebServices Standards-Based InterfacesOracle Delivers a Full Spectrum of Interfaces • Data Level • Stored Procedures • Tables • Document Level • XML Based • Asynchronous • Functional Level • Web Services Standards • SOAP
Service-Enabled Business FlowsIntegration Enabled Oracle Applications Oracle E-Business Suite • Open Interface points • All Key Interactions • Inbound • Outbound • Standards-based • OAG BODS Mfg PDX iP APS … ... Order Product Forecast Customer • OAG Open Applications Group • BOD Business Object Documents
Standards-Based MessagesSample of OAG XML BODs Oracle E-Business Suite • Name Direction • Sync ECO O • Sync BOM O • Sync Routing O • Payment Orders* O • WIP Move* I • WIP Complete* I • Inv Issue* I • WIP Split/Merge* I • WIP Bonus* I • WIP Create Order* I • WIP Sync Order* I • WIP Process Resource* I • Name Direction • Process PO I & O • Ack PO I & O • RFQ I & O • Show Catalog (4) I • Price List I • Show Shipment I & O • Confirm BOD I & O • Sync Plan Schd I & O • Sync Ship Schd I & O • Sync Seq Schd I • Process Invoice I & O
Oracle XML Gateway Manages XML Document Exchange • Message Designer Create ‘Message Maps’ between Oracle eBusiness Suite and OAG XML message formats • Execution Engine Create or consume well-formed and valid XML messages Oracle E-Business Suite XML Gateway ... Order Invoice Product Customer
Web ServicesWeb Service Integration with E-Business Suite Oracle E-Business Suite • Function Interfaces • Uses Web Services Standards • UDDI: Universal Description, Discovery & Integration • SOAP: Simple Object Access Protocol • WSDL: Web Services Description Language • Transports • Synchronous: Http • Asynchronous: AQ Web Services WebServices WS Client Application
Business Application Integration TradingPartners OracleE-BusinessSuite Oracle Application Server 10g Customers PackagedApplications Internet ServiceProviders LegacySystems Web Services Business to Business (B2B) Enterprise Application Integration (EAI)
Oracle E-Business Suite Oracle Application Server IntegrationComprehensive Standards Based Integration Oracle Application Server 10g Business Activity Monitoring Customers Packaged Applications Business Process Management Managers and Administrators Legacy Systems Transformation B2B Web Services EAI Data Sources Enterprise Users Trading Partners
Applications Technology Infrastructure Open InterfaceTables XMLGateway WebServices Oracle E-Business Suite + Oracle Application ServerHigh Level Integration Architecture Oracle E-Business Suite Service-EnabledBusinessFlows Order Management Manufact Procurement Planning Financial Standards-basedInterfaces Oracle Application Server 10g BroadConnectivity XML SOAP RosettaNet EDI SAP Peoplesoft ...
Oracle Application Server Integration • EAI, B2B, Web Services Integration • Business Process Management • Business Activity Monitoring • Transformation • Complete Lifecycle Support • Standards-Based • Packaged Adapters • Extensible Through SDKs
Features • Model and Metadata Driven • Model Endpoints, Business Process, Transformations • Single Metadata Repository • Business Activity Monitoring and Optimization • Business level monitoring of all integration activity • Alerts, document tracking, pre-built reports • Analytic reporting on integration history
Features • Enhanced Secure Communication • Digital Certificates, Digital Signatures • Guaranteed exactly-once delivery • Non-repudiation • Support for B2B protocol standards • RosettaNet 1.1 & 2.0 • EDI • Trading Partner Management • Manage profiles, parties, agreements • Support for Web Services • All key standards: SOAP 1.1, WSDL, UDDI • Invoke web services from business processes
AdaptersBroad Connectivity To Applications & Technologies • Applications • Oracle 11i • Oracle 10.7 • SAP R/3 • PeopleSoft • JD Edwards • Siebel • Any JCA Application • B2B Protocols • RosettaNet • HL7 2.3 / 3.0 • EDI • Databases • Oracle7.3, 8.0, 8i, 9i • MS SQL-Server • IBM DB/2 • Sybase • Informix • JDBC • Messaging • Oracle AQ • MQSeries • TIBCO • JMS • Transports • SOAP • HTTP, HTTP-S • SMTP • FTP • Web Services • Generic DB • Flat File • Legacy • CICS • Tuxedo • IMS • VSAM • 3270 Screen Scraping
Connection Services- Adapter Framework • Supports J2EE Connector Architecture (J2CA) 1.0 • Extensions to overcome current limitations in JCA 1.0 • Bi-directional • Asynchronous • Metadata Interface • Actively involved in the enhancing the standard Standards Based Connectivity for Rapid Deployment
Connection Services Support for Multiple Standards and Protocols • B2B: • High Technology: RosettaNet 1.1 & 2.0 • Retail: UCCnet • Healthcare*: HL7, HIPAA • EDI*: X12, EDIFACT • Internet transports: http/s, smtp, ftp • Packaging: SOAP 1.1, SMIME 3.0 • Security Digital Certificates, X.509 • Trading Partner: CPP/CPA • Web Services: SOAP, WSDL, UDDI • J2EE: J2CA, JMS, JDBC Ensure Interoperability, Drive Out Cost * Planned
B2B Integration Run-Time HTTP/S Trading Partner Management SMTP Business Process Management FTP SOAP Security Validation Transform XML RosettaNet Logging Monitoring TrxMgmt TCA EDI Extending the Oracle E-Business Suite Adapters OpenInterfaceTables DBMS Web Services WebServices BusinessFlows XML/AQ XMLGateway SAP Peoplesoft Siebel Oracle Application Server 10g E-Business Suite
Web Service EAI Receive Order Get Mgr. Approval Credit Check Service Approved Get Credit Approval Approved Place Order B2B Part Not in Inventory Trading Partners Trading Partners Trading Partners Trading Partners Send Part Request Customer Suppliers Accepted Bill Customer Approved Notify Customer Done Notification Sent Step-By-Step ExampleOrder to Cash Business Flow
Order to Cash Integration Components Credit Check Web Service Web Services Adapter Oracle Application Server Integration SAP SAP Adapter Trading Partner B2B Siebel RosettaNet Adapter Siebel Adapter Oracle E-Business Suite Oracle Apps Adapter Microsoft Exchange COM Adapter
Adapter Adapter XML Gateway OracleAS Integration Look At Two Integration Points AQ Adapter SAP Adapter OracleE-Business Suite SAP Adapters Transformation BPM Routing
2 1 1 2 3 3 PO 4 SAP Adapter 5 5 Apps Adapter BOD IDOC Modeling the Endpoints OracleAS Integration Back-end System Back-end System Oracle iStore SAP • 6 Steps • Define endpoints • Select Interactions (Browse the Interfaces) • Select or Define Native View of Data • Define Common View of Data • Map Native to Common View (Transformation) • Define agreements
Oracle to SAP R/3Example Mapping Oracle SAP R/3 Order Purchase Order Customer ID Customer DUNS Last, First Name Name No. of Units Quantity Unit of Measure Type Notes Comments
SAP Adapter 2 2 Value Approve 1 Apps Adapter Adding a Business Process OracleAS Integration Back-end System Back-end System Oracle iStore SAP PO Steps • Define Internal / Common Business Process • Define Notification or Exception Handling
3 Retry 4 Alert 5 XML Gateway B2B with Supplier OracleAS Integration Host: Buyer Seller Trading Partner: 1 B2B B2B Gateway Backend System Oracle Procurement Steps • Define Trading Partner • Define Trading Partner Agreement • Map Native Data to Common Data • Define B2B Process and map to Application Process • Define error processing, if any 2 Internet
Oracle E-Business Suite InternetProcurement OrderManagement Supply Chain Trading Connector ... … XML Gateway RosettaNet OAG XML Oracle + RosettaNet • Supply Chain Trading Connector • Uses XML Gateway to Deliver & Consume OAG XML Messages • Notification Processing & History Recording Oracle Application Server Integration ProcessManagement DocumentTransformation ProfileManagement RNIF 1.1/2.0 • OracleAS Integration • Secure Communication • PIP Choreography • Document Validation • Document Transformation • Trading Partner Management Trading Partners
What are FastForward Flows? Rapid Business Flow based implementation • Solutions have been pre-tested and pre-certified • Quickly automate critical end-to-end business processes • Leverages leading practices built into Oracle’sE-Business business flows • Provides necessary flexibility to quickly customize
Summary • eBusiness Demands Integration • Oracle E-Business Suite is “service-enabled” via open, standards-based interfaces • Oracle Application Server 10g provides a complete solution for EAI, B2B, and Web Services Integration • OracleAS enables E-Business Suite connectivity to 3rd party applications, and B2B standards
Extending E-Business SuiteOracle Allows You To … • Adopt E-Business Suite Incrementally • Integrate E-Business Suite with Legacy Systems • Extend E-Business Suite Flows to Trading Partners • Add Systems Incrementally
…. And Provides Flexibility To Do So • Business Flow Accelerators for Lower Risk, Rapid Deployment • Standards-Based Extension to Minimize Cost of Custom Development