52e4b0d3a33cfb2d3f1050a0c6eb5499.ppt
- Количество слайдов: 29
Incorporating Existing Systems into a SOA Jim Green CEO Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Agenda § § § § § The Concepts of SOA and Data Services Examples Legacy systems and SOA SAP and SOA Reuse across multiple projects An approach Pre-built services Ease of use Deployment issues Who we are Copyright © 2006 Composite Software, Inc. All Rights Reserved.
The Move to SOA Is Important “By 2008, SOA will be the basis of 80% of new development projects” Source: Gartner Group Data Services are a Big Part of SOA “Over 60% of web services will be data services” Source: IDC Data Services are Complicated “Organizations are placing only minor emphasis on understanding the role of data integration in SOA and creation of data services at the foundation of their architectures. . . most organizations appear to be at risk for failure in their SOA efforts” Source: Gartner Group Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Attributes of a Service Oriented Architecture § Modular: Autonomous software modules provide services and data to other autonomous modules § Loosely Coupled: Modules are not tightly coupled to the applications consuming them § Standards Based: Interoperability based on standard interfaces Interface: Cust_Name CC# Expiration_Date PIN# Credit Card Service Copyright © 2006 Composite Software, Inc. All Rights Reserved.
SOA Always Has Extensive Data Requirements Transaction Interface: Cust_Name CC# Expiration_Date PIN# Credit Card Service Copyright © 2006 Composite Software, Inc. All Rights Reserved. Data
An Actual SOA Implementation Transaction Service Charge the Account Data Services: • Get Acct Balance • Get Credit Rating • Get Promotion Info • Check Card Status • Check Fraud Status Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Case Study – Husasmidjan, Inc. § Scandinavian construction materials retailer/wholesaler, 18 stores § Business requirement: detect and address variances between planned and actual payroll expense § Business user: Office of the CFO § Technical requirement: Expose and combine SAP R/3 and in-house budget data Rollup Service § Solution 1. Create service view into SAP payroll information 2. Create service view of other payroll information 3. Build roll-up service for analysis 4. Expose summary info to budget system Local services normalize across different stores and apps Payroll data sources Legacy Files Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Data Shapes: Databases versus XML § XML web service format is hierarchical § Relational data is tabular This is a BIG problem Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Why This Is Hard: SAP Example Challenge: Create a web service that can serve data about general ledger account detail. Problem 1: Finding the information. SAP has thousands of BAPIs. § Which one(s) do you need to access? Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Why This Is Hard: SAP Example Challenge: Create a web service that can serve data about general ledger account detail. Problem 1: Finding the information. In this case the information is distributed across three BAPIs: § BAPI_GL_ACC_GETDETAIL § BAPI_GL_ACC_GETLIST § BAPI_COMPANYCODE_GE TLIST Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Why This Is Hard: SAP Example Problem 2: You need to learn “SAP Speak” to talk with SAP ? ? ?
Why This Is Hard: SAP Example § Problem 3: Data returned in three separate structures and in proprietary format. Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Composite Software: Created To Solve This Problem Access to Packaged Apps: • Oracle • People. Soft • SAP • Salesforce. com • Siebel Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Pre-built views created from: • BAPIs • RFCs • Tables Copyright © 2006 Composite Software, Inc. All Rights Reserved. Cryptic SAP tables in German ABAP code. Deciphered into common recognizable business terms.
Case Study – Global Pharmaceutical § Activity: Discovery, development, manufacture, distribution, and sale of pharmaceuticals. Scientific Workbench § Business requirement: Efficiently discover new drugs. Data Service § Business user: pharmaceutical and chemical scientists. § Technical requirement: on-demand access to scientific data from disparate, multiple platforms. Toxicology Analytical Biology Copyright © 2006 Composite Software, Inc. All Rights Reserved. Genotoxicity Carcinogenicity
Enterprise Data Services Architecture Definition § Single common source for all data § Abstracts format, location, access § Platform for building business solutions Data Services Layer Databases Packaged Apps Files XML Benefits § Single way to access to all data § Reusable data services § Fast, simple deployment of solutions § Protects data § Ensures correctness Copyright © 2006 Composite Software, Inc. All Rights Reserved. DW
New York Banking Example Projects 1. 2. 3. 4. Prime Brokerage Reporting Risk Management Back Office Reconciliation Portfolio Balancing Data Services Layer Databases Packaged Apps Copyright © 2006 Composite Software, Inc. All Rights Reserved. Files XML DW
New York Banking Example Results Projects 1. 2. 3. 4. 1. 2. 3. Prime Brokerage Reporting Risk Management Back Office Reconciliation Portfolio Balancing 4. 40% of work was reused 100% correct data was ensured Applications were protected (75% less impact on applications) Response time to business requests decreased 80% Data Services Layer Databases Packaged Apps Copyright © 2006 Composite Software, Inc. All Rights Reserved. Files XML DW
The Composite Software Approach The Issues 1. Corporate information is stored in non-SOA legacy systems 2. Complex issues in accessing, mapping and transforming legacy data into SOA-compliant form Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Access to a Comprehensive Array of Data Sources The Problem • Non-SOA legacy systems • Transforming legacy data into SOA-compliant XML The Approach A high performance (EII) server that can access, transform, join, data and host SOA data services NA Sales XML Data Services Layer Excel CSV Files SQL Server Oracle 8 i, 9 i, 10 g SOAP/HTTP XML/HTTP DB 2 v 7, v 8 My. SQL Informix Copyright © 2006 Composite Software, Inc. All Rights Reserved. XML Files Sybase Netezza
The Composite Software Approach The Issues § Corporate information is stored in non-SOA legacy systems § Complex issues in accessing, mapping and transforming legacy data into SOA-compliant form The Approach § A high performance (EII) server that can access, transform, join, data and host SOA data services § Hundreds of “pre-built” services for major apps Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Buy Instead of Build § § § Hundreds of pre-built Web Services Expose data in standard business terms Available out of the box Customers Vendors Orders Invoices Company ID Address Phone Status 12 -RG 4 E ABC Carpet 1300 S Ge 415 334 34 Gold 12 -FFE 2 Hansen Win 21 Promen +44 71 771 Base 12 -9 P 5 R Copyright © 2006 Composite Software, Inc. All Rights Reserved. Name Schlumberg Peachtree 707 442 43 Base
Buy Instead of Build Customer (partial list) Customers View (Service) Customer Detail SAP 4. 6, 4. 7, 5. 0 Orders Customer List § Over 100 pre-built Web Services § Expose data in standard business terms § Available out of the box Application Vendors Invoices SAP 4. 6, 4. 7, 5. 0 Customer Sales Area SAP 4. 6, 4. 7, 5. 0 ID Name Sales Activity General Data Address SAP 4. 6, 4. 7, 5. 0 Phone Status 12 -RG 4 E Customer Accounts ABC Carpet Siebel 1300 S Ge 7. 7, 7. 8 7. 5, 415 334 34 Gold Hansen Win Siebel 21 Promen 7. 5, 7. 7, 7. 8 +44 71 771 Base 707 442 43 Base 12 -FFE 2 Customer Accounts by Contact 12 -9 P 5 R Company Schlumberg Peachtree Oracle 8 i, 9 i, 10 g Customer Account Site Uses Oracle 8 i, 9 i, 10 g Customer Account Sites Oracle 8 i, 9 i, 10 g Customer Accounts Oracle 8 i, 9 i, 10 g Account Detail Sales. Force New This Week Copyright © 2006 Composite Software, Inc. All Rights Reserved. Customer Account Roles Sales. Force
Buy Instead of Build Customer Detail Copyright © 2006 Composite Software, Inc. All Rights Reserved. Customer (partial list)
The Composite Software Approach The Issues § Corporate information is stored in non-SOA legacy systems § Complex issues in accessing, mapping and transforming legacy data into SOA-compliant form The Approach § A high performance (EII) server that can access, transform, join, data and host SOA data services § Hundreds of “pre-built” services for major apps § Very easy to use powerful tool to create your own data services Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Composite Studio: Constructing a Data Service Copyright © 2006 Composite Software, Inc. All Rights Reserved.
“To Serve and Protect” 1, 000 users Scalable 1, 000 users Secure 1 SAP access Enterprise Ready Performance SAP Load Users Copyright © 2006 Composite Software, Inc. All Rights Reserved. Performance SAP Load Users
Composite Software § Proven customer-success across industries with over 100 installations § Acknowledged leadership in SOA compliant data services § Included in products from Cognos, Informatica, BMC, and others § Headquarters in San Mateo, CA Financial Services Consumer/Retail Managed Services Technology Managed Services Life Sciences Telecommunications Top 10 IBank Top 10 I-Bank Public Sector Copyright © 2006 Composite Software, Inc. All Rights Reserved.
Thank you for attending our Webcast For more information please: Visit: www. compositesw. com Email: info@compositesw. com Phone: 620 -227 -8200 Copyright © 2006 Composite Software, Inc. All Rights Reserved.


