Oracle 9iAS Integration - Northeast Ohio Oracle Users Group by suchenfz

VIEWS: 9 PAGES: 47

									                                         ®




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

1. Overview
2. Architecture
3. InterConnect Components
4. Customer Examples
5. Current & Future
6. Adapter Schedule
7. More Information
8. Demo (time permitting)
   Oracle9iAS Application Server
                       One Integrated Product
                                                      J2EE, PL/SQL, etc.
      •Web Services
      •XML support
                                      Transactional                 SSO, Security,
                       Dynamic        Applications                  Manage content
                       Web Sites
                                                       Portals
•DW reporting     Business
•Adhoc reports   Intelligence
•Analysis                                       Wireless
                                Integration



                                                             Access from a
                                                             Portable device
Oracle’s Unique Position
                           Application
                            Vendor
                                A

                            applications
                             messaging
                            middleware
                            developers
                              skill sets

                       Infrastructure
                   B                       C
           EAI                                   System
    Integration Server                         Integrator/
         Vendor                                Consultants
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 !
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
    Integration Platform

              Services:
              Oracle Workflow (BPC), Web Services,
              Business Intelligence
              Message:
              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
Traditional Approach to                                         A2A
Integration
                         A typical example...

                                   Sellable
  Customer        Order            Stock         Inventory
  Order
                  Entry                         Management

             Confirmed
             Orders                Completed
                                   Orders
                                                   Automated
              Work Order         Material Move.
                                                   Shop Floor
                                 Instructions
              Management                            Systems
                                   Job Status
Common Application Model utilized
Enterprise Application Integration
Approach Oracle9iAS InterConnect
In the Hub:                                                                        A2A
       App A                    A
                                                                           App B
                                d                                      A
 Customer         Order         a                                      d
 Order                          p                                      a Inventory
                  Entry         t                          Sellable    p
                                                                       tManagement
                                e        Sellable          Stock
                                r                                      e
                                         Stock                         r
                         Sales
                         Forecast
                                                              Completed
                    Sales             Complex,                Orders
                    Forecast          Difficult to
                                      Integration           Material Move.
               Material Move.             Hub
                                      Maintain              Instructions
 App C         Instructions                                                   App D
                         Job Status                               A
                   A
                   d
                                                     Job Status
                                                                  d
                                                                  a
                                                                      Automated
       Work Order  a
                   p                                              p   Shop Floor
                                                                  t
       Management  t
                   e
                            Completed
                                                                  e    Systems
                            Orders                                r
                   r
e-Business Demands Integration
                 Business
                 Partners
    ASPs
                                   Exchanges
                Internet
    ASP

                     Enterprise
                      Enterprise
   B2B
         A2A
  Integration
Oracle9i: Complete e-Business
Integration Infrastructure

          Oracle9i Integration Services
    Integration Tools        Business
                                             Packaged Integration
                        Process Management



     XML Services        Message Queuing         Connectivity




                            Standards
Oracle’s Integration Tech Stack

                   Oracle9iAS InterConnect
                         Integration Logic
X                                                                Y
                                             Oracle / Actional
                    9i
                                                Adapters
           Plumbing Infrastructure              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)
Oracle9iAS Integration
Connect Applications, Trading Partners, Web Services
                                     Tools                            Back Office
                                                                      Applications
 Trading Partners      Design      Manage       Analyze
 & Web Services

          RosettaNet
                                 Business
        ebXML                    Process
                                Management                        e-Business Suite
      SOAP

                         Profile             Semantic
                       Management         Transformation   Message
                                                           Gateways
      UDDI & JAXR      B2B Protocol                                    Mainframe
                                             Messaging
      Repositories       Engine
                              INSERT
                                Trigger
                                                           Adapters
                                    9iAS
                                                                       3rd Party
                                                                      Applications
Enterprise Application Integration
Integrate Oracle and Non-Oracle Applications

                     Oracle
                                                     Non-Oracle
                   Application
                                                      Adapters
                    Adapters

    Oracle                            Business       Application
                                      Process                      SAP R/3
E-Business Suite                                      Adapters
                                     Management
                     XML/AQ
  XML Gateway        Adapter           Semantic
                                    Transformation   Message       Legacy
                   OAG XML / AQ                                     Apps
                                                     Gateways
    Apps                              Messaging
   Database         Oracle DB
                     Adapter
                                        9iAS            SDK         Other
                   Triggers / SPs
EDI to Enterprise Applications
EDIFACT, X.12 & SWIFT for Oracle and 3rd Party Apps


  Trading                          Business
  Partners                                                  Oracle
                                   Process
               3rd Party                                  E-Business
                                  Management
              Transports                                     Suite
                             Profile        Semantic
                           Management    Transformation    Oracle
               EDIINT
                                                          Exchange
   Internet                   EDI
                     AQ     Adapter          Messaging
               Convert                                       3rd
              EDI to XML                                    Party
                                      9iAS
    VAN

    Private
    Network
Exchange Architecture (e-Hub)
…using Oracle9i Integration

 Oracle 9iAS                            Oracle9i
   Portal    Oracle Exchange Services Integration
 Framework                             Platform




                                                    Transaction Delivery
                • Catalogs
                • Negotiations                                             Customer
                • Design
                  collaboration
                • Demand forecasting                                       Supplier
                • Supply chain
                  planning
                                                                            Partner


       Oracle9i
      Application                      Oracle8i
        Server                         Database
  Trading Partner Transaction Integration
  From Simple Browser Access to ERP
  Integration

               Transaction delivery via
               9i Integration Platform
                                            ERP


  Self-Service
Trading Partner  Oracle
    Profiles    Exchange                  eMail/FAX


           Browser

                                            EDI
             Online Access



                                                      17
Oracle Advanced Queuing (AQ)
Database Integrated Messaging


•   Integrated data, message, and
    message history                                            Workflow
•   Recoverability
    (any point in time recovery)
•   Auditing &Tracking              App                              App
•   Visibility of in-process
    transactions                                   AQ
•   Business Intelligence           App                              App
•   High Performance
    (1000s of Msgs/Sec/Queue)
                                          Reliable Messaging
                                             Point to Point
•   Integrated to Oracle Workflow            Point to Multi-Point
                                             Publish & Subscribe
   Oracle9iAS InterConnect
   Components
• Speeds Integration Design &
  Deployment                                          iStudio
• Visual Design Tools
• Common View Metadata
• Transformation
• Packaged Adapters
• Extensibility
                                 Metadata

  App1        Adapter            Integration         Adapter    App2
                        XML      Services      XML



                                Oracle9i
Oracle Workflow
Business Process Management
                                      Workflow Applications
 Integrated with AQ for
  event-driven workflow
                                         Web &
 Works with                             Email
  InterConnect for
   A2A & B2B                          Collaborative
                           Workflow
                                      Process Integration
                            Engine
                        Business
App1   Adapter                             Adapter        App2
                      Event System
              XML
                             AQ
                                            Integration
                                            Services
Adapter Architecture:
 A2A Implementation


                                    • Business Events       Applications
   Repository                       • Transformations
                                    • Routing Rules
                                                            SAP
                           Adapter                            Peoplesoft
                       Agent                                      Siebel
    AQ          Common              App      Bridge
                  View              View                           Ariba
  To Hub
                                                                  C1

                  Metadata Driven      Transport and/or       Other
                  Transformation       Application Specific
                                       (Manages Conversation)
    Adapter Architecture:
   Technology & B2B Implementation          MQ Series
                                             Queue
                                            Manager

                                              Local
Repository                                    SMTP
                                              Server

                       Adapter
                    Agent                     Remote FTP
 AQ          Common         App    Bridge       Server
               View         View
To Hub
                                             Remote HTTP
                                               Servlet
                                                HTTP/S
                                                Local
                                            Firewall/Proxy
Oracle9iAS InterConnect Adapter
Architecture
• Agent
   • Transformation between
     common view and                                 Adapter
     application view                     Agent
• Bridge                           Common                  App          Bridge
   • Communication with external     View                  View
     application
   • Transformation between
     application view XML and
                                   Metadata driven      Transport and/or
     native data format            transformations     Application Specific
  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
Case Study: CalPERS

•   Company Overview
     • Nation’s 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
CalPERS Integration Solution

                                                  Peoplesoft

     CICS
                                       Peoplesoft               Oracle
   Application
                                        Adapter
VSAM          CICS
             Adapter                                Forte
                         Oracle9iAS               Application
                         Integration
                                        Custom                  Oracle
    OS/390                              Adapter
   Application              Oracle8i
                             (AQ)
Adabas    MitemView                           PowerBuilder
         ScreenScraper                         Application

                                       Oracle DB                Oracle
                                        Adapter
                                                                    Wincor
Case Study: Wincor Nixdorf                                          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
                                                  Wincor
Wincor Nixdorf Integration Solution               Nixdorf

                            SAP Adapter
Oracle E-Business Suite                          SAP
                               CUSTOMER
  CRM 11i
                  AR         LOOKUP CODE         FI

                           INVOICE TRIGGERING
    Sales                        PRICE
                  OM             QUOTE
                             LOOKUP CODE         SD
                           SERVICE CONTRACT
                            SERVICE ORDER
                            INSTALLED BASE
   Service
                                  ITEM
                            BILL OF MATERIAL
                  INV                            MM
                          ATP/ITEM RESERVATION
Packaged Integration
Oracle iProcurement / SAP Interconnect


    SAP Adapter              Pre-built      Oracle iP Adapter
    (SAP Certified)          Mapping        (uses XML/AQ Adapter)




                              Oracle9iAS              Oracle
SAP R/3                       Integration            Internet
                                                   Procurement
                             Supported
                             By Oracle
Status: Product / In Production
Oracle iProcurement / SAP Interconnect
Common View Objects


       SAP R/3                Oracle iP
     Purchase Order         Purchase Order

       Requisition          Unit of Measure

        Receipt                 Inventory

        Invoice               Freight terms

        Journal                 Supplier
                            Exchange Rates
                            Chart of Accounts
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
Oracle9iAS Integration: Current Release
Complete Enterprise Application Integration Solution

                      InterConnect            Workflow

                                                               Oracle
                                                              Enterprise
                                                              Manager



     AQ/XML
                                          Business
                         Semantic
                                          Process
  Http/s              Transformation
            Adapter                      Management      Adapter     Oracle11i

 Smtp     Adapter            Reliable Messaging            Adapter      SAP

  Ftp/s     Adapter                                      Adapter     Peoplesoft
                                 Oracle9iAS
  Oracle DB
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
   Oracle9iAS Integration Release 2
   Product Architecture
InterConnect / Workflow
                          Tools                                            Oracle
                                                                          Enterprise
                            Design            Monitor       Analyze
                                                                          Manager
                          Metadata
                            Design Metadata        Run-Time Repository

                          Run-Time / Common Services

                                   Trading Partner Management
    B2B Services                                                               Adapters
        Http/s                                                                     Oracle11i
                                  Business Process Management
        Smtp                                                                       SAP R3
         Ftp                                                                      Peoplesoft
                            Security       Validation    Transformation
        SOAP                                                                      MQSeries
                                                            Reliable
       ebXML                 Logging       Monitoring                                  Siebel
                                                           Messaging
      RosettaNet                                                                       CICS
         EDI                                                                           JMS
                                         Oracle9iAS
                                                                                       More…
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
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
                 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
             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
Messaging Adapters & Gateways

   Messaging
   •   MQSeries
   •   MSMQ
   •   Tibco
   •   JMS


   Database Gateways
   • All Major Relational Databases
   • Mainframe: DB2, IMS, VSAM
    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 )
Proof of Concept:
Real 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
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/workflow/workflow_fo
   v.html
• Workflow discussion forum on OTN
Oracle Enterprise Manager
• http://technet.oracle.com/products/oem/content.html
Oracle9i AS InterConnect
• http://technet.oracle.com/products/integration/content.html
Summary
Oracle9iAS 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
Q U E S T I O N S
 A N S W E R S
iStudio - Demo
          ( If Time Permits )
 Demo Example: mapping with iStudio

PUBLISH:                                        SUBSCRIBE:
New Customer                                    New Customer
Customer ID    Copy                      Copy
                        CustID                       Custno
 Lastname      Copy
                        FirstName
                                            Concat
                                                     Name
               Copy
 Firstname              LastName                     (LN, FN)




                      newCustomerEvent
  Oracle                                                SAP
Application                                          Application
                       Common View
  Demo Example                   Workflow Credit
                                 Check Application



PUBLISH:                                             SUBSCRIBE:
New Customer                                         New Customer
Customer ID    Copy                       Copy
                        CustID                            Custno
 Lastname      Copy
                        FirstName
                                              Concat
                                                          Name
               Copy
 Firstname              LastName                          (LN, FN)




                      newCustomerEvent
  Oracle                                                     SAP
Application                                               Application
                       Common View

								
To top