Oracle9iAS Integration

1
Oracle9iAS Integration Brian Lawrence -
Principal Sales Consultant, Applied Technologist
2
Agenda

• Overview
• Architecture
• InterConnect Components
• Customer Examples
• Current Future
• Adapter Schedule
• More Information
• Demo (time permitting)

3
Oracle9iAS Application Server
One Integrated Product
J2EE, PL/SQL, etc.

• Web Services
• XML support

Transactional Applications
SSO, Security, Manage content
Dynamic Web Sites
Portals
Business Intelligence

• DW reporting
• Adhoc reports
• Analysis

Wireless


Access from a Portable device
4
Oracles Unique Position
applications messaging middleware developers skill
sets
Infrastructure
5

• Oracle9iAS Integration Key Messages
• One Solution A2A, B2B, Web Services Integration
• As part of Oracle9iAS, Fully Leverages 9i
  Platform
• Versus programming required using Stand-alone
  solution
• Strong, general- purpose integration solution
• Simplifies Integration by re-focusing the
  integration process on the Business Analyst using
  a Common Application View approach
• also, ideal solution for Oracle Applications
  customers !

6

• Business Drivers for Integration
• Customer Relationship Management -
  Integrated Call Centers
• - Customer Portals
• Supply / Demand Chain Integration - B2B
  standards
• - Trading Partner Portals
• Employee Self Service
• - Integrated Business Processes Applications
• - Enterprise Portals

7
Integration Platform
Services
Oracle Workflow (BPC), Web Services, Business
Intelligence
Message
Integration Tools
Oracle9iAS InterConnect, Oracle AQ, Message
Gateways (AQ MQ, AQ TIBCO)
Data
Oracle Data Replication, Oracle
Gateways (Transparent, Procedural, Generic)
9i Platform High Availability, Security,
Scalability, Flexibility
8
Traditional Approach to Integration
A typical example...
Order Entry
Inventory Management
Sellable Stock
Customer Order
Confirmed Orders
Completed Orders
Automated Shop Floor Systems
Work Order Management
Material Move. Instructions
Job Status
9
Enterprise Application Integration Approach
App A
App B
Order Entry
Inventory Management
Customer Order
Sellable Stock
Sellable Stock
Sales Forecast
Completed Orders
Complex, Difficult to Maintain
Sales Forecast
Material Move. Instructions
Material Move. Instructions
App C
App D
Job Status
Automated Shop Floor Systems
Work Order Management
Job Status
Completed Orders
10
e-Business Demands Integration
11
Oracle9i Complete e-Business Integration
Infrastructure
Oracle9i Integration Services
Standards
12
Oracles Integration Tech Stack
Oracle9iAS InterConnect
Integration Logic
Oracle / Actional Adapters
Non Oracle Connectivity

• X and Y can be any one of the following
• Oracle Application
• Non Oracle Application
• Other Message Oriented Middleware (MQ Series,
  Tibco, etc)
• ASP hosted application
• B2B Protocol (HTTP, HTTP/S, SOAP, etc)

13
Oracle9iAS IntegrationConnect Applications,
Trading Partners, Web Services
Back Office Applications
Tools
Trading Partners Web Services
RosettaNet
BusinessProcessManagement
ebXML
e-Business Suite
SOAP
SemanticTransformation
ProfileManagement
MessageGateways
UDDI JAXR Repositories
Messaging
B2B ProtocolEngine
Mainframe
INSERT Trigger
Adapters
9iAS
3rd PartyApplications
14
Enterprise Application IntegrationIntegrate
Oracle and Non-Oracle Applications
OracleApplicationAdapters
Non-OracleAdapters
SAP R/3
OracleE-Business Suite
BusinessProcessManagement
ApplicationAdapters
XML/AQAdapter
XML Gateway
SemanticTransformation
LegacyApps
MessageGateways
OAG XML / AQ
AppsDatabase
Messaging
Oracle DBAdapter
Other
SDK
9iAS
Triggers / SPs
15
EDI to Enterprise ApplicationsEDIFACT, X.12
SWIFT for Oracle and 3rd Party Apps
TradingPartners
BusinessProcessManagement
OracleE-BusinessSuite
3rd PartyTransports
SemanticTransformation
ProfileManagement
OracleExchange
EDIINT
EDIAdapter
Messaging
Internet
AQ
3rdParty
Convert EDI to XML
9iAS
VAN
PrivateNetwork
16
Exchange Architecture (e-Hub)using Oracle9i
Integration
Oracle Exchange Services

• Catalogs
• Negotiations
• Design collaboration
• Demand forecasting
• Supply chain planning

17
Trading Partner Transaction IntegrationFrom
Simple Browser Access to ERP Integration
Transaction delivery via 9i Integration Platform
ERP
XML via HTTP/S
Self-Service Trading Partner Profiles
Oracle Exchange
SMTP
eMail/FAX
EDI
Browser
EDI
Online Access
18
Oracle Advanced Queuing (AQ)Database Integrated
Messaging

• Integrated data, message, and message history
• Recoverability (any point in time recovery)
• Auditing Tracking
• Visibility of in-process transactions
• Business Intelligence
• High Performance(1000s of Msgs/Sec/Queue)

AQ
App
App
App
App

• Reliable Messaging
• Point to Point
• Point to Multi-Point
• Publish Subscribe

19
Oracle9iAS InterConnect Components

• Speeds Integration Design Deployment
• Visual Design Tools
• Common View Metadata
• Transformation
• Packaged Adapters
• Extensibility

iStudio
App2
App1
Adapter
Adapter
XML
XML
Oracle9i
20
Oracle Workflow Business Process Management
Workflow Applications

• Integrated with AQ for event-driven workflow
• Works with InterConnect for A2A B2B

Web Email
CollaborativeProcess Integration
WorkflowEngine
App2
App1
BusinessEvent System
Adapter
Adapter
XML
IntegrationServices
21
Adapter Architecture A2A Implementation

• Business Events
• Transformations
• Routing Rules

Applications
Repository
SAP
Adapter
Peoplesoft
AQ
Bridge
Agent
Siebel
AppView
CommonView
Ariba
To Hub
C1
Transport and/orApplication Specific(Manages
Conversation)
Other
Metadata DrivenTransformation
22
Adapter Architecture Technology B2B
Implementation
MQ Series Queue Manager
Local SMTP Server
JMS
IMAP/POP3
Adapter

Agent
Remote FTP Server
Bridge
AppView
CommonView
To Hub
Remote HTTP Servlet
HTTP/S
Local Firewall/Proxy
23
Oracle9iAS InterConnect Adapter Architecture

• Agent
• Transformation between common view and
  application view
• Bridge
• Communication with external application
• Transformation between application view XML and
  native data format

Metadata driven transformations
Transport and/or Application Specific
24
Oracle9iAS Integration is a Proven Solution
Examples CalPERS - Links Multiple Call Center
Applications Wincor Nixdorf - Integrates Oracle
CRM with SAP R/3 Belgacom - Deploys Packaged
Solution for Oracle iP with SAP R/3
25
Case Study CalPERS

• Company Overview
• Nations largest public pension fund
• 170B in Assets
• Provide retirement and health benefits
• Serve 1.2 million current and former California
  public employees and their families
• www.calpers.com
• Business and Technology Needs
• Implement an integrated call center to better
  serve customers
• Integrate several proprietary applications
• Leverage existing skills and technology
  investment
• Utilize a cost effective solution

26
CalPERS Integration Solution
CICSApplication
Oracle9iASIntegration
VSAM
CICSAdapter
ForteApplication
Oracle
CustomAdapter
OS/390Application
Oracle8i(AQ)
Adabas
MitemViewScreenScraper
27
Case Study Wincor Nixdorf

• Company Overview
• Leading vendor of IT products and solutions for
  the retail and banking industries (ATMs, POS,
  etc.)
• 1 in Germany
• 2 in Europe
• 3 worldwide
• 3,500 employees in 40 countries worldwide
• Annual Revenue 2.6 Billion DM
• www.wincor-nixdorf.de
• Business and Technology Needs
• Business Goal to be 1 worldwide in 3 years
• Implement new state-of-the-art call center
  software to meet sales and service objectives
• Integrate the new call center system with
  existing SAP systems

28
Wincor Nixdorf Integration Solution
SAP Adapter
SAP
Oracle E-Business Suite
FI
CUSTOMER
CRM 11i
AR
LOOKUP CODE
Sales
INVOICE TRIGGERING
SD
OM
PRICE
QUOTE
LOOKUP CODE
SERVICE CONTRACT
Service
SERVICE ORDER
INSTALLED BASE
ITEM
MM
INV
BILL OF MATERIAL
ATP/ITEM RESERVATION
29
Packaged IntegrationOracle iProcurement / SAP
Interconnect
Pre-builtMapping
SAP Adapter (SAP Certified)
Oracle iP Adapter (uses XML/AQ Adapter)
SAP R/3
SupportedBy Oracle
Status Product / In Production
30
Oracle iProcurement / SAP InterconnectCommon
View Objects
SAP R/3
Oracle iP
Purchase Order
Purchase Order
Unit of Measure
Requisition
Inventory
Receipt
Freight terms
Invoice
Supplier
Journal
Exchange Rates
Chart of Accounts
31
Pre-Packaged Integration

• Oracle CRM SAP R/3
• Oracle Internet Procurement SAP R/3
• Generalized to work with out-of-the-box SAP R/3
• Actional SAP R/3 adapter
• 30 predefined integration points
• Target 30-60 days to implement

32
Oracle9iAS Integration Current ReleaseComplete
Enterprise Application Integration Solution
InterConnect
Workflow
OracleEnterpriseManager
AQ/XML
SemanticTransformation
BusinessProcessManagement
Http/s
Oracle11i
Reliable Messaging
Smtp
SAP
Ftp/s
Peoplesoft
Oracle9iAS
Oracle DB
33
Oracle9iAS (Release 1.0.2.2)Current Release -
OAI 4.1 (Oracle9iAS InterConnect)

• Workflow Integration
• Auditing Tracking
• OEM Integration
• Actional Adapters
• SAP
• Peoplesoft
• CICS
• MQSeries
• Ftp

34
Oracle9iAS Integration Release 2Product
Architecture
InterConnect / Workflow
OracleEnterpriseManager
B2B Services
Oracle9iAS
More
35
Oracle9iAS Release 2

• 9iAS Release 2 Component Compliance
• Installation and Configuration
• Security
• Lightweight Trading Partner Client
• Web browser based
• Oracle CRM Adapters
• iStore, Sales, Service
• Additional Actional adapters certified
• Business Intelligence Reporting

36
Oracle9iAS Release 2

• B2B Protocol Adapter
• RosettaNet, ebXML
• SOAP
• Trading Partner Profile Management
• Web based
• Web Services Adapter
• Expose Applications and Workflow as web services
• Integrate any web service
• EDI Adapter (partner)
• Edifact, X.12
• SWIFT

37
Adapter Schedule
Actional Adapters (Fee Based)
Availability PeopleSoft version 7.5.x
Available SAP R/2 and R/3 thru version 4.6D
Available FTP Available CICS LU6.2
Only Available EDI (X.12, Edifact,
Swift) Oracle 9iAS Version 2 Siebel 2000
Oracle 9iAS Version 2 J.D. Edwards, One
World Oracle 9iAS Version 2 B2B Adapters
(RosettaNet, ebXML, SOAP) Oracle 9iAS Version
2 PeopleSoft version 8.0 Oracle 9iAS Version
3 Commerce One, Market Site Under
Investigation Tuxedo Under Investigation
Lawson Under Investigation Vantive
Under Investigation Baan Under
Investigation Ariba Under Investigation
38
Adapter Schedule
Oracle Adapters (Non Fee Based)
Availability Oracle DB Available AQ / XML
Available HTTP/S Available SMTP (mail)
Oracle 9iAS Version 2.0 FTP (replaces
Actional) Oracle 9iAS Version 2.0 MQ Series
Oracle 9iAS Version 2.0 SAP R/3 version 3.1h
above Available The Actional SAP R/3
adapter will replace the Oracle SAP R/3 adapter
39
Messaging Adapters Gateways

• Messaging
• MQSeries
• MSMQ
• Tibco
• JMS
• Database Gateways
• All Major Relational Databases
• Mainframe DB2, IMS, VSAM

40
Oracle9iAS InterConnect 9.0.2 - Pricing
Information

• Oracle9iAS delivers 360 degrees of integration,
  offering a complete, easy-to-use and low-cost
  solution for enterprise application, business to
  business and Web services integration.
• Interconnect is offered as part of Oracle9iAS
  Enterprise Edition
• Oracle9iAS Enterprise Edition pricing - 20K per
  processor
• Interconnect is bundled with the comprehensive
  set of technology adapters (Oracle RDBMS Oracle
  AQ , SMTP , FTP/s , HTTP/s, IBM MQSeries)
• Additional application adapters can be purchased
  at 30K per adapter per hub (SAP R/3 ,
  PeopleSoft, J.D. Edwards, Siebel 2000, IBM CICS
  LU 6.2 )

41
Proof of ConceptReal World Experience

• How long does it take to install/configure
  Actional adapters?
• only minutes!
• What does a typical integration POC look like?
• Small, fixed set of integration points that prove
  bi-directional integration
• 1-4 weeks end-to-end, depending on integration
  project
• What expertise is needed in a POC or
  implementation?
• Domain knowledge of packaged applications
• Technical knowledge of Oracle9iAS, adapters

42
More Information

• Advanced Queuing
• http//www.oracle.com/ip/deploy/database/oracle9i/
  aq_home.html
• otn.oracle.com/products/aq/
• AQ discussion forum on OTN
• Workflow
• http//technet.oracle.com/products/integration/wor
  kflow/workflow_fov.html
• Workflow discussion forum on OTN
• Oracle Enterprise Manager
• http//technet.oracle.com/products/oem/content.htm
  l
• Oracle9i AS InterConnect
• http//technet.oracle.com/products/integration/con
  tent.html

43
SummaryOracle9iAS Integration

• Single product solution for A2A, B2B, and Web
  Services integration
• Fully integrated feature of Oracle9iAS
• Open, standards-based architecture
• Complete general-purpose enterprise integration
  infrastructure
• Best solution for Oracle E-Business Suite

44
A
45
iStudio - Demo
( If Time Permits )
46
Demo Example mapping with iStudio
PUBLISH New Customer
SUBSCRIBE New Customer
Customer ID
CustID FirstName LastName
Custno
Lastname Firstname
Name (LN, FN)
Common View
47
Demo Example
Workflow Credit Check Application
PUBLISH New Customer
SUBSCRIBE New Customer
Customer ID
CustID FirstName LastName
Custno
Lastname Firstname
Name (LN, FN)
Common View