Interoperabilität zwischen SharePoint 2007 und SAP Anwendungen

2. InteroperabilitätzwischenSharePoint 2007 und SAP Anwendungen Tilo Böttcher, Sr. Program Manager Microsoft CorpMarkus Dopp, Director Sales and Marketing Sitrion

3. Womit wir uns in dieser Session beschäftigen Beispiele aus HR, Dokumenten-Management, Suche und Formularwesen Wie Microsoft intern SAP und SharePoint nutzt Aufbau von Lösungen mit iViewWebParts, dem Business Data Catalog und iQL Studio

4. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

5. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

6. SAP – Business and Roadmap

7. Microsoft and SAP – Best of Two Worlds Process People

8. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

9. Interoperability – building OBA ApplicationsLayersand Options for Connectivity Web Services • Exposed Web Services frommySAP Business Suite • Exposed Web Services from NetWeaver (XI, BW throughWebAS) • Enterprise Services Explorer for SAP in Visual Studio BizTalk Server • BizTalk Server Adapter for mySAP Business Suite V2 • BizTalk Server Adapter for SAP NetWeaver (WCF based) SQLBI • .NET Data Provider for mySAP Business Suite • .NET Data Provider for NetWeaver BI Third Party • Third Party conn. (Theobald Software, Sitrion, ...) • SAP Connector for Microsoft .NET providedby SAPlimitation: Requires Visual Studio 2003 -> buildproxyanduse in VS 2005

10. Office Business Applications (OBA) Office BusinessApplications Duet ISV OfficeApplication MS OfficeApplication SI OfficeApplication CustomerIT Apps ToolsUsers, Designers, Professional Developers MicrosoftOfficeSystem 2007 Office System Clients Open XML File Format Extensible UI 2007 Office Office Sharepoint Server ContentManagement Communication andCollaboration BusinessIntelligence Search Workflow and Process LOB Applications,Data Warehouses, Trading Partner Systems, etc. Business Data Connectivity mySAPERP SAP NetWeaver R/3 BW WebSite and Security Framework

11. Buildorbuy: Duet vs. Custom build OBAs Office Business Applications (OBA) Duet™ - The Standard Solution Customized OBA Solutions • Duet enables the use of Microsoft Office as a front-end to SAP ERP modules including CRM, SCM, and HCM • Jointly developed, marketed and supported by SAP and Microsoft • Rich Set of Line of Business scenarios • 770,000 licenses purchased since June 2006 • 280 enterprise customers • OBAs are a new breed of application that bridge the business data/IW (results) gap • You can customize and extend the Office client using VSTO • You can also integrate WCF, WPF, LINQ and other technologies • You can integrate LOB Systems through SharePoint BDC • Look for further integration of client and server as Office Business Application framework evolves

12. OBA and Microsoft internal SAP Applications v3.5 R/3 - SAP Enterprise Finance: Financial Accounting, (Enterprise) Controlling, Corporate Finance Mgmt., Treasury, Real Estate, Project Systems Human Resources: Benefits, Payroll, Organizational Mgmt., Personnel Time & Administration Supply Chain: Sales and Distribution, Material Management BW - SAP Business Warehouse Finance Accounts Payable Policy Compliance Vendor Spend Org. Spend Treasury-Exchange Asset Management Supply Chain Product ID Recon. Screening Reports v4.7 FI CO EC CFM TR RE PS BN PY OM PT PA SD MM GTS - SAP Global Trade Svc Legal & Logistics ServicesDenied Party Screening NGS – Staffing E-Recruiting v6.0 v7.0 SCM - SAP Supply Chain Management Supply Network Planning Demand Planning, Event Manager v4.1 BW REC EM DP SNP LLS

13. Microsoft’s LOB Architecture eBusiness MSMarket MS Invoice Retail Internet Ordering … Excel based standard reports Mgmt P&L’s, Revsum, Inventory Partners Customers BizTalk EDI SAP R/3 SQL 2005 Legacy & SAP BW SQL AS/RS Employee Self-Service Strategies: All transactions processed in SAP Casual users use Intranet self-service Full-time users use SAP GUI Partners use XML, EDI or Internet self-service Publish master data via a central store Adhoc management reporting via business-owned datamarts Headtrax MS Expense HR WEB …

14. Microsoft internal approach –Reference Architectures Office Applicationor Browser

15. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

16. Text WebPartswithconnectivityto SAP today • iView Consumer WebPart • WSRP WebPart • BDC WebParts • Data Lists • Search • Forms • Custom Build (seeiQL Studio in thispresentation)

17. iViewWebPart Lightweight integration of Portlets MOSS SSO is a prerequisit to iViewWebParts No “Drag&Relate” or other inter Portlet communication available Users must be mapped (today) UI/stylesheets apply partly only (hard to apply themes

18. iViewWebParts in SharePoint Steps to configure the iViewWebPart Set up SSO in SharePoint Edit TrustedSAPHosts.Config in the SharePoint directory and add the URL of the SAP Portal Separate the URL of the iView in the Portal and copy it to the iViewWebPart URL Based on entries in TrustedSAPHosts.Config

19. WSRP WebPart WSRP needs to run NetWeaver Portal WSRP (still 1.0) has lots of limitations WSRP implementa-tions vary from vendor to vendor

20. BDC connectingto SAP WebServices For SAP we choose WebServices connectivity only BDC Definition Editor (part of SharePoint SDK download) creates service description Import XML description file to SharePoint as Shared Application Create Actions if needed

21. Business Data Catalog • Reduces the need for custom front-end code • Makes use of SOA investments already in place • Optimized, manageable reuse of data • Centralized deployment, security • Low latency • Designed for portal & collaboration scenarios • Data query, indexing, personalization • Not limited to Web Parts • The BDC is not about: adapters, workflow, transactions, transformation, precomposition

22. Business Processes / Workflow Forms In The 2007 Office SystemApplying InfoPath to business process management solutions Office SharePoint Server 2007 ERP Form Fill-in Form Design CRM SAP • Pre-built template parts and data connections • Design a single form for browser and clients • Apply IRM permissions to InfoPath client forms • Develop forms solutions using Visual Studio 2005 LOB System • Complete forms with browsers and mobile devices • Internet Explorer, Netscape, Mozilla, FireFox, Safari supported • Zero client footprint browser and mobile forms • Complete InfoPath forms inside Outlook 2007 • Integrated workflow management • Automatic form template version management • Centralized administration and deployment of form templates • Scalable InfoPath Forms Services architecture InfoPath Integration to LOB Applications

23. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

24. Performing Enterprise Search from MOSS in SAP NetWeaver Portal/KMC • Enterprise Search aggregates structured and unstructured data from different datasourcesmostly in the INTRANET • MOSS WebParts are capable to front end aggregated search within Microsoft and SAP • MOSS can consume WebServices as well as provide API level functions through WS(20 services classes today) • Today‘s SAP NetWeaver TREX engine providessome WS APIs

25. Performing Enterprise Search from MOSS Architecture Nowas WebService availablefrom KM

26. Performing Enterprise Search from MOSS BDC Architecture

27. End-to-endIdentity Management and SSO Single Sign-On - Based on AD, Kerberosand SAP Logon Tickets. - SAML tokensare not interoperable today User Management

28. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

31. Unser Fokus liegt auf der Anbindung von SAP an: • Microsoft Office 2003/2007 • Microsoft SharePoint Server 2003/2007 • ASP.NET Webapplikationen • Windows Mobile Devices • Allgemeinen .NET-Applikationen • Unsere Mitarbeiter haben Skills in: • Microsoft .NET 1.0 – 3.5 • C# und VB.NET • SAP ABAP/4 • SAP ABAP Objects • SAP Workflows • SAP HR, SD, MM, BW und FI/CO

32. Die Zusammenarbeit zwischen den SAP und .NET-Teams wurde sehr vereinfacht und die internen Entwicklungs- und Administrationsaufwände konnten deutlich optimiert werden. Deshalb stellt iQL Studio für unsere aktuellen und zukünftigen Projekte im Bereich SAP-.NET-Interoperabilität eine optimale Technologie dar. Thomas HuckeLeiter Internet/Intranet

33. SharePoint • Customer Management • Preiskalkulationen • Employee-Self-Service • Manager-Self-Service • Reporting

34. SharePoint • Word • Outlook • Customer Factsheet • Sales Cockpit • Materialmanagement • Reporting

35. SharePoint • Employee-Self-Service • Manager-Self-Service • BW Dashboard • Customer Management

36. Wir bieten Ihnen auf Basis unseres Produktes „iQL Studio“ folgende Lösungen an: • EmployeeSelf Services (ESS) • Manager Self Services (MSS) • Travelmanagement • Customer Factsheet • Sales cockpit • Materialmanagement • Angebots- und Auftragswesen • CRM • Zeiterfassung mit CATS • BANF Bestellanforderungen • Und vieles mehr…

37. Beispiellösung „Urlaubsantrag“ mit Anbindung an: • SharePoint Server 2007 • Outlook • Exchange Server • Office Forms Server 2007 • Windows Mobile Device

38. Demo

39. Das iQL Studio-Komplettpaket: • Entwicklung • Schnittstellen • Administrationswerkzeuge • Deployment & Migration

40. Demo

41. Kontakt www.sitrion.com mdopp@sitrion.com

42. Demo

43. Agenda SAP and Microsoft System Landscape Interoperability – building OBA Applications WebParts and Forms connecting to SAP Search, Security and Single Sign-on Building end to end solutions with iQL Summary and further links

44. Call to action Portal and Information Integration within SAP and Microsoft works today, take away the Portal Interoperability Guide Explore today’s Web Services Interfaces from SAP including Enterprise Services – many things work with existing services Microsoft Forms Server provides a full Forms solution for SAP, test your own flavour SharePoint can be extended with first class Partner Solutions like iQL Studio from Sitrion today 1 Microsoft 2 3 4

45. Further Information • Evidence • There are dozens of references for SAP/MS Interoperability • www.microsoft.com/casestudies/ • White papers • www.microsoft.com/isv/sap -> Interoperability • http://sdn.sap.com -> SAP NetWeaver-> Platform and Operations -> .NET Interop • http://msdn.microsoft.com/library • technet.microsoft.com/en-us/interopmigration/bb544954.aspx • http://download.microsoft.com/download/f/1/4/f1439ea3-e87c-43d7-9071-c15c65f46064/microsoft_sharepoint_sap_portal_interop_V2.zip • Forums • http://blogs.msdn.com/saptech • http://sdn.sap.com: .NET Technologies ForumASUG Community of Interest (CoI) for Microsoft - SAP Interoperability

46. Herzlichen Dank für IhreAufmerksamkeit!