You are previewing Microsoft® .NET and SAP.
O'Reilly logo
Microsoft® .NET and SAP

Book Description

Get hands-on answers to frequently asked questions about using Microsoft .NET technologies to customize and extend SAP applications. Walk through dozens of real-world examples—from Web Services integration to business intelligence (BI) reporting and Microsoft Office-based solutions—direct from a team of Microsoft–SAP interoperability experts. Learn how to expose back-end SAP data through familiar Microsoft tools and UIs—for better productivity and lower TCO.

Discover how to:

• Navigate the development environment and tools—including Microsoft Visual Studio®, Visual Studio Tools for Office, and BizTalk® Server • Connect .NET and SAP via Web Services, tools like SAP Connector and Enterprise Service Explorer, and .NET Data Provider • Implement BI solutions that unlock SAP data through familiar Microsoft UIs • Expose data from SAP NetWeaver Portal in Microsoft Office SharePoint® Server • Use the Business Data Catalog to display and search SAP content—no coding • Build your own Office Business Applications (OBAs), or put Duet to work • Add Microsoft Office presence functionality and forms solutions to SAP applications • Deliver a single sign-on solution

Table of Contents

  1. Microsoft® .NET and SAP
  2. Foreword
  3. Acknowledgments
  4. Introduction
    1. Who This Book Is For
    2. What This Book Is About
    3. Companion Content
    4. Hardware and Software Requirements
    5. Find Additional Content Online
    6. Support for This Book
      1. Questions and Comments
  5. 1. SAP—Company Overview, Development Tools, and Microsoft .NET Interoperability
    1. SAP History
    2. SAP Product Suite
    3. SAP Development Environments
      1. ABAP Development Environment
      2. Java Development Environment
    4. SAP and Microsoft—History and Products
    5. Summary
  6. 2. Microsoft .NET Development Environment and Tools
    1. The Evolution of Microsoft Visual Studio
    2. Visual Studio Tools for Office
    3. Microsoft BizTalk Server
      1. The BizTalk Server Engine
      2. Connecting Systems Using Adapters
      3. Defining Business Processes
      4. Business Rules Engine
      5. Business Activity Monitoring
      6. BizTalk Server vs. SAP PI/XI
    4. Summary
  7. 3. Connectivity Between Microsoft .NET and SAP
    1. Web Services Communication
    2. SAP NetWeaver Web Service Creation Wizard
    3. SAP Enterprise Services
      1. SAP Enterprise Services Explorer for Microsoft .NET
    4. SAP Connector for Microsoft .NET
    5. Microsoft BizTalk Adapter for SAP Integration
      1. Microsoft Windows Communication Foundation Line-of-Business Adapter SDK
      2. SAP Integration Mechanisms
      3. Overview of BizTalk Adapter 3.0 for mySAP Business Suite
        1. Connecting to an SAP System Using the Adapter
        2. Scenario 1: Using BizTalk Server to connect to SAP
        3. Prerequisites
        4. Create a directory for all projects: C:\SapMsftDevBook
        5. Scenario 2: Using WCF adapter services to connect to SAP
        6. Scenario 3: Developing applications by using the WCF service model
    6. Microsoft .Net Provider for SAP NetWeaver Business Intelligence
      1. Prerequisites
      2. Activating and Testing the SAP BI XML/A Service
      3. Connecting to the XML/A Service Using Microsoft SQL Server Reporting Services
        1. Creating a SAP NetWeaver BI data source with SQL Server 2005 Reporting Services
        2. Single sign-on with SQL Server 2008 Reporting Services
    7. Microsoft .NET Provider for mySAP Business Suite (Preview)
      1. Prerequisites
      2. Connecting to SAP Using the .NET Provider for mySAP Business Suite
    8. Summary
  8. 4. Microsoft Business Intelligence
    1. Introduction to Microsoft BI
      1. SQL Server DBMS
      2. SQL Server Reporting Services
      3. SQL Server Analysis Services
      4. Excel and Excel Services
      5. PerformancePoint Server
      6. SharePoint Server
    2. Common BI Integration Scenarios
    3. SQL Server and SAP
      1. Reporting Scenario
        1. SQL Server 2005 Reporting Services
        2. SQL Server 2008 Reporting Services
      2. Analysis Scenario
        1. SQL Server 2005 Integration Services
        2. SQL Server 2008 Integration Services (Microsoft SAP BI Connector Preview)
        3. SQL Server Analysis Services
      3. Data Warehousing Scenario
        1. SQL Server Integration Services
    4. Office PerformancePoint Server and SAP
    5. Summary
  9. 5. Microsoft Office SharePoint Server: UI Integration
    1. SAP Business Server Pages and SAP Web Dynpro Applications
      1. Business Server Pages
        1. Integration of BSP Applications with SharePoint Server 2007
        2. Integration in SharePoint Portal Server
      2. Web Dynpro
        1. Integration of Web Dynpro Applications with SharePoint Server 2007
    2. The iView Web Part Toolkit
      1. Integration of iViews by Using the iView Web Part Toolkit
        1. Configuration of SAP NetWeaver Portal
        2. Configuration of Microsoft Office SharePoint Server
    3. Web Service for Remote Portlets
      1. Consuming WSRP-Enabled iViews in SharePoint Server 2007
        1. Configuring SAP NetWeaver Portal as the WSRP Producer
        2. Configuring SharePoint Portal Server as the WSRP Consumer
    4. Summary
  10. 6. SharePoint Business Data Catalog and SAP
    1. BDC Architecture
    2. BDC Web Parts
    3. Microsoft Business Data Catalog Definition Editor
    4. InfoPath Integration
    5. Integrating SAP with the BDC
    6. Scenario 1: Using BDC with SAP Web Services
      1. Configure Single Sign-on Settings in SharePoint Server
        1. Creating an Encryption Key
        2. Managing Enterprise Application Definition for SAP
        3. Specifying User Account Mapping for SAP Applications
      2. Create a Web Service Connection by Using the BDC Definition Editor
        1. Configuring the LOB System Settings
        2. Configuring the Customer Entity Name and Identifier
        3. Creating Method Instances
        4. Testing the Method Instances
        5. Exporting the LOB System Instance Metadata
        6. Importing the Application Definition File into the Shared Services Provider
        7. Creating Business Data Web Parts
    7. Scenario 2: Using BDC with the BizTalk SAP Adapter
      1. Configuring the Customer Entity Name and Identifier
      2. Creating Method Instances
      3. Creating Actions
      4. Exporting the LOB System Instance Metadata
      5. Importing the Application Definition File into the Shared Services Provider
      6. Creating Business Data Web Parts
    8. Business Data Search in Microsoft Office SharePoint Server
      1. Setting Up Business Data Catalog Search for SAP
  11. 7. Office Business Applications
    1. Office Business Applications: Integrating SAP with the 2007 Microsoft Office System
      1. The Sample OBA: Building Specialty Travel Packages
      2. Sample OBA Architecture and Technologies
        1. Creating a Web Service
        2. Integrating SAP with Excel 2007 by Using VSTO 3.0
          1. Creating a VSTO 3.0 Project
        3. Integrating SAP with MOSS 2007 by Using the BDC
    2. Duet
      1. Technical Overview of Duet
    3. Summary
  12. 8. Custom Development
    1. The Portal Development Kit for Microsoft .NET
    2. SAP and the Microsoft Office Communication Server
    3. Microsoft Office InfoPath and SAP
      1. Web Service Support in InfoPath 2007
      2. SAP Web Services and InfoPath
      3. Read-Write Integration Scenario
      4. InfoPath Forms Services
    4. .NET Web Services and SAP NetWeaver
      1. Consuming the Web Service in SAP NetWeaver ABAP
    5. Summary
  13. 9. Identity and Security Management
    1. Identity Management
    2. Single Sign-on
      1. Secure Network Communication
      2. SAP Logon Tickets
      3. SAML Token Authentication Profile
      4. Microsoft Enterprise Single Sign-on
    3. Summary
  14. About the Authors
    1. Juergen Daiberl
    2. Steve Fox
    3. Scott Adams
    4. Thomas Reimer
  15. Index
  16. About the Authors
  17. Copyright