40158 Mohindroo

Slide2: 

Ashish Mohindroo Product Marketing Oracle Corporation

Slide3: 

Seven Basic Concepts of Integration

Slide4: 

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

Why?: 

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

Integration Segments: 

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

Integration ExampleNew Employee Hire: 

Integration Example New Employee Hire Facilities App Telecom App Email App HR App Payroll App Custom File-Based PeopleSoft Oracle DB Legacy On Mainframe Custom On IBM DB2

Integration ExampleNew Employee Hire: 

Integration Example New Employee Hire Facilities App Telecom App Email App HR App Payroll App Custom File-Based PeopleSoft On Oracle DB Legacy On Mainframe Custom On IBM DB2

Integration ExampleNew Employee Hire: 

Integration Example New Employee Hire Facilities App Telecom App Email App HR App Payroll App Custom File-Based Legacy On Mainframe Custom On IBM DB2 Integration Platform PeopleSoft On Oracle DB

Connectivity: 

Connectivity Messaging Bus Custom File-Based PeopleSoft On Oracle DB

Data Translation: 

Data Translation FirstName MiddleInitial LastName Name (LN, FN) Custom SQL Queries / Code

New Employee HirePoint-to-Point Connectivity: 

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

Data Management: 

Data Management FirstName MiddleInitial LastName Name (LN, FN) Prefix FirstName MiddleInitial LastName Suffix SUBSCRIBE

Data Management: 

Data Management

Data Management: 

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

Integration ExampleNew Employee Hire Process: 

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

Business Process ManagementRequirements : 

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

Business Process Management: 

Business Process Management

Process Integration: 

Process Integration

Business Process Management: 

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

Business Activity Monitoring: 

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

Business Activity Monitoring: 

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

Business Process Optimization: 

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

Integration ExampleNew Employee Hire Process: 

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

B2B Integration: 

B2B Integration Trading Partner Management Profiles - 1…N Trading Partners with 1…M Agreements 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 B2B Delivery Channels Collaborations – RNIF, Custom, ebXML, …. Doc. Exchange – XML, OAGIS, RNIF, HL7, EDI, … Packaging & Signing – SMIME 3.0, EDI, SOAP 1.1, 2.0, .. Transport – VAN, HTTP, SMTP, FTP, JMS, ….

Reliability: 

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

SummarySeven Basic Concepts of Integration: 

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 10g Single Integration Platform: 

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

Slide29: 

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

CalPERS: 

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

Tower Limited: 

Tower Limited Customer Product Systems AIA IAC BOA SAS PAS LEO OracleAS Integration DMS PeopleSoft TOWER.NET Adviser WEB Access TOWER Staff Access

Slide32: 

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

Slide33: 

A

Find Out More: 

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

Oracle DEMOGrounds: 

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