Ashish Mohindroo Product Marketing Oracle Corporation Seven

Ashish Mohindroo Product Marketing Oracle Corporation

Seven Basic Concepts of Integration

“ 35% of all IT spending is for application integration” - Gartner Group

Why? Ÿ Regulatory Compliance Ÿ Customer Self Service Ÿ Business Process Flexibility Ÿ Business Visibility

Integration Segments Ÿ Data Integration – Achieve Data Consistency Ÿ Enterprise Application Integration (EAI) – Connecting Disparate Applications and Processes Ÿ Business-to-Business Integration (B 2 B) – Collaborating online with business partners

Integration Example New Employee Hire Custom Facilities File-Based App Email App HR App People. Soft Oracle DB Telecom App Payroll App Custom Legacy On IBM DB 2 On Mainframe

Integration Example New Employee Hire Custom Facilities File-Based App Email App Custom On IBM DB 2 Telecom App HR App Payroll App People. Soft On Oracle DB Legacy On Mainframe

Integration Example New Employee Hire Custom Facilities File-Based App Email App Custom On IBM DB 2 Telecom App HR App Integration Platform Payroll App People. Soft On Oracle DB Legacy On Mainframe

Connectivity Employee Information Office Information Facilities App A D A P T E R Messaging Bus A D A P T E R HR App Custom People. Soft File-Based On Oracle DB

Data Translation First. Name Middle. Initial Name Last. Name (LN, FN) HR App Custom SQL Queries / Code Facilities App

New Employee Hire Point-to-Point Connectivity Custom Facilities File-Based App Email App Custom On IBM DB 2 Telecom App HR App Payroll App People. Soft On Oracle DB Legacy On Mainframe Time Consuming & Costly

Data Management PUBLISH SUBSCRIBE Prefix First. Name Middle. Initial Last. Name Copy First. Name Middle. Initial Last. Name Concat Name (LN, FN) Suffix HR App Create Customer Event Facilities App

Data Management Data Flow Services Application Message HR App Translate Validate Common Message Transform Application Message Transform Facilities App Validate Translate

Data Management Common View Databases Messaging Systems Packaged Apps Files Mainframe Legacy R E S O U R C E Databases R E S O U R C E Data Mapping Data Translation Data Transformation INT. Validation INT. Routing Integration Platform Messaging Systems Packaged Apps Files Mainframe Legacy

Integration Example New Employee Hire Process New Employee Req Enter Employee Confirmed HR App Create New ID Payroll App Confirmed Order Equipment Confirmed Facilities App Set up Email System Confirmed Set up Telephone Confirmed Telecom App

Business Process Management Requirements Ÿ Automate Process Flows Between Systems Ÿ Incorporate Human Interactions Ÿ Manage By Exceptions Ÿ Define Alerts and Events

Business Process Management

Process Integration Process Flow HR Application Process Business Process Application Process Facilities App Data Flow HR Application Message Common Message Application Message Facilities App Services Translate Validate Transform Validate Translate

Business Process Management Databases XML Parse Portal W O R K F L O W R E S O U R C E XML Index/ XML Query XML Filters (Rules) XML Cache XML Transformation Messaging Systems Packaged Apps Web Services INT. XML Processing Integration Platform Files Mainframe Legacy

Business Activity Monitoring New Employee Req Enter Employee Confirmed HR App Create New ID Payroll App Confirmed Order Equipment Confirmed Facilities App Set up Email System Confirmed Set up Telephone Confirmed Telecom App

Business Activity Monitoring Real Time Business Activity Monitoring Create New ID Payroll App Confirmed Set up Email System Confirmed Integration Platform New Employee Req Enter Employee Confirmed HR App Assign Office Confirmed Facilities App Set up Telephone Confirmed • • Telecom App Metadata Model Processes Business Events Transformations

Business Process Optimization Business Activity Monitoring Business Process Integration Packaged Apps Legacy Systems Trading Partners Customers

Integration Example New Employee Hire Process New Employee Req Enter Employee Reference Check Service Confirmed HR App Check Credentials Approved Create New ID Firewall Confirmed Payroll App Assign Office Facilities App Confirmed Set up Telephone Confirmed Telephone App

B 2 B Integration ŸTrading Partner Management – – – – Profiles - 1…N Trading Partners with 1…M Agreements - CPA-based, Export/Import, Negotiation Identity – TP, Role (Buyer, Seller), TP Manager Communication – Protocol to be Used Security – Certificate, CA, Non-repudiation reqts, Key-length, … Document Exchange – Idempotency, Retries, Interval, Security, . . Action – Error Handling Actions, Channels Validity – Duration, Associated Partners ŸB 2 B Delivery Channels – – Collaborations – RNIF, Custom, eb. XML, …. Doc. Exchange – XML, OAGIS, RNIF, HL 7, EDI, … Packaging & Signing – SMIME 3. 0, EDI, SOAP 1. 1, 2. 0, . . Transport – VAN, HTTP, SMTP, FTP, JMS, ….

Reliability Integration Platform Integration Services Single Sign-On Business Process Management Data Management Trading Partner Management Business Activity Monitoring Connectivity Core Services Security CRM Management SFA ERP Clustering MRP Load Balancing SCM Legacy

Summary Seven Basic Concepts of Integration ü Connectivity ü Data Translation ü Data Management ü Business Process Management ü Business Activity Monitoring ü Business-to-Business Integration ü Reliability

Oracle Application Server 10 g Single Integration Platform Customers Suppliers Employees Customers Suppliers Trading Partners Oracle Application Server 10 g Portal Personalization Content Management Portal Components Integration Single Sign-On Business Process Management Data Transformation Trading Partner Management Business Activity Monitoring Web Services Foundation Services Security CRM Management SFA ERP Clustering MRP Load Balancing SCM Legacy

International Paper SAP R/3 Extranet web app Oracle. AS Integration Internet Solaris Order Data thousands of users ODS: Oracle 8 i DB on Alpha Open VMS Proprietary order system VAX VMS

Cal. PERS Two client database applications: RIBS Case management and reporting app RAPS CICS and Adabas DB Oracle. AS Integration Powerbuilder/Jaguar mainframe COMET NT HP-UX CORBA Java app in Sun Forte, and Oracle DB Initial integration Unix

Tower Limited TOWER Staff Access Adviser WEB Access DMS TOWER. NET People. Soft Oracle. AS Integration Customer Product Systems IAC BOA AIA SAS PAS LEO

D E M O N S T R A T I O N

Q & A QUESTIONS ANSWERS

Find Out More Oracle Application Server Integration: Overview and Vision Tuesday, September 9, 3: 30 PM, Room 252 Business Process Management for Beginners Tuesday, September 9, 5: 00 PM, Room 302 Connect Your Business Applications with The Enterprise: A Step-By-Step Guide Wednesday, September 10, 11: 00 AM, Room 302 Streamline Business Processes in Real Time with Business Activity Monitoring Thursday, September 11, 8: 30 AM Room 302

Oracle DEMOGrounds Automate and Optimize Business Processes Integration for DBAs Demo and Hands-on Lab Extend the Oracle E-Business Suite Real-Time Process Monitoring with Oracle Portal