Tilo Böttcher, Sr. Program Manager Microsoft Corp Markus Dopp, Director Sales and Marketing Sitrion Beispiele aus HR, Dokumenten-Management, Suche und Formularwesen Wie Microsoft intern SAP und SharePoint nutzt Aufbau von Lösungen mit iView WebParts, dem Business Data Catalog und iQL Studio 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 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 SAP – Business and Roadmap Microsoft and SAP – Best of Two Worlds Process People 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 Interoperability – building OBA Applications Layers and Options for Connectivity BizTalk Server BizTalk Server Adapter for mySAP Business Suite V2 BizTalk Server Adapter for SAP NetWeaver (WCF based) SQL BI .NET Data Provider for mySAP Business Suite .NET Data Provider for NetWeaver BI Third Party Web Service s Exposed Web Services from mySAP Business Suite Exposed Web Services from NetWeaver (XI, BW through WebAS) Enterprise Services Explorer for SAP in Visual Studio Third Party conn. (Theobald Software, Sitrion, ...) SAP Connector for Microsoft .NET provided by SAP limitation: Requires Visual Studio 2003 -> build proxy and use in VS 2005 Office Business Applications (OBA) ISV Office Application Duet MS Office SI Office Application Application Customer IT Apps 2007 Office System Clients Open XML File Format 2007 Office Office Sharepoint Server Content Management Communication and Collaboration Business Intelligence Search Workflow and Process Business Data Connectivity WebSite and Security Framework LOB Applications, Data Warehouses, Trading Partner Systems, etc. R/3 BW mySAP ERP SAP NetWeaver Tools Microsoft Office System Extensible UI Users, Designers, Professional Developers Office Business Applications Build or buy: Duet vs. Custom build OBAs Office Business Applications (OBA) Duet™ - The Standard Solution Duet enables the use of Microsoft Office as a frontend 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 Customized OBA Solutions 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 OBA and Microsoft internal SAP Applications R/3 - SAP Enterprise v4.7 BW - SAP Finance: Financial Accounting, (Enterprise) Controlling, Business Corporate Finance Mgmt., Treasury, Real Estate, Project Systems Warehouse FI CO EC CFM TR RE PS Human Resources: Benefits, Payroll, Organizational Mgmt., Personnel Time & Administration BN PY OM PT Supply Chain: Sales and Distribution, Material Management SD MM SCM - SAP Supply Chain Management Supply Network Planning Demand Planning, Event Manager v4.1 Finance Accounts Payable Policy Compliance Vendor Spend Org. Spend Treasury-Exchange Asset Management Supply Chain Product ID Recon. Screening Reports EM DP SNP GTS - SAP Global Trade Svc v7.0 NGS – Staffing Legal & Logistics Services Denied Party Screening PA v3.5 v6.0 E-Recruiting LLS REC BW Microsoft’s LOB Architecture eBusiness MS Market MS Invoice Retail Internet Ordering … Partners BizTalk Customers EDI SAP R/3 SQL 2005 Legacy & SAP BW Employee Self-Service Headtrax MS Expense HR WEB … SQL AS/RS Excel based standard reports Mgmt P&L’s, Revsum, Inventory Strategies: All transactions processed in SAP Casual users use Intranet self-service Full-time users use SAP GUI Partners use XML, EDI or Internet selfservice Publish master data via a central store Adhoc management reporting via businessowned datamarts Microsoft internal approach – Reference Architectures iViews via SPS WSRP via SPS Web Client via BSP’s via SPS SPS SPS BDC Office Application or Browser Client SharePoint Portal Server Client SharePoint Portal Server Web Services SAP Application Server SAP Application Server Client SharePoint Portal Server SAP Enterprise Portal SAP Application Server Client SharePoint Portal Server SAP Enterprise Portal SAP Application Server Client SharePoint Portal Server SAP Enterprise Portal SAP Application Server 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 WebParts with connectivity to SAP today iView Consumer WebPart WSRP WebPart BDC WebParts Data Lists Search Forms Custom Build (see iQL Studio in this presentation) iView WebPart Lightweight integration of Portlets MOSS SSO is a prerequisit to iView WebParts No “Drag&Relate” or other inter Portlet communication available Users must be mapped (today) UI/stylesheets apply partly only (hard to apply themes iView WebParts in SharePoint Steps to configure the iView WebPart 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 iView WebPart URL Based on entries in TrustedSAPHosts.Config WSRP WebPart WSRP needs to run NetWeaver Portal WSRP (still 1.0) has lots of limitations WSRP implementations vary from vendor to vendor BDC connecting to 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 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 Forms In The 2007 Office System Applying InfoPath to business process management solutions Form Fill-in Office SharePoint Server 2007 ERP Form Design Business Processes / Workflow - 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 - Complete forms with browsers and mobile devices - Internet Explorer, Netscape, Mozilla, FireFox, Safari supported CRM SAP LOB System - Integrated workflow management - Automatic form template version management - Zero client footprint browser and mobile forms - Centralized administration and deployment of form templates - Complete InfoPath forms inside Outlook 2007 - Scalable InfoPath Forms Services architecture InfoPath Integration to LOB Applications 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 Performing Enterprise Search from MOSS in SAP NetWeaver Portal/KMC Enterprise Search aggregates structured and unstructured data from different data sources mostly 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 provides some WS APIs Performing Enterprise Search from MOSS Architecture Now as WebServic e available from KM Performing Enterprise Search from MOSS BDC Architecture End-to-end Identity Management and SSO Single Sign-On - Based on AD, Kerberos and SAP Logon Tickets. - SAML tokens are not User Management interoperable today 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 Unternehmen Technologie Lösungen Partner • Softwarehersteller • Enge Kooperation mit Microsoft • Internationaler Kundenstamm • Unternehmensfokus: SAP-.NET-Integration • Workshops und Prototypen • Services im Bereich .NET-Entwicklung • iQL Studio • Komplettpaket für die SAP-.NET-Integration • SharePoint, Office, ASP.NET etc. mit SAPAnbindung • 100% .NET 2.0-basiert • Unterstützt Systeme ab Release 4.6c • Testversion erhältlich • Mehr als 60 Lösungen auf Basis von iQL Studio • Employee-Self-Services • Manager-Self-Services • Vertriebsmanagement • Materialmanagement • CATS • Travelmanagement • BANF • Und vieles mehr… • Partner wie Wipro, Avanade, Microsoft, IPI, Trinedy etc. • Internationale Partner • Sitrion als „Back-Office“ für Microsoft-Partner • Partner können Lösungen in zentrales Portfolio stellen • Herstellerunterstützung der Partner 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 Die Zusammenarbeit zwischen den SAP und .NETTeams 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-.NETInteroperabilität eine optimale Technologie dar. Thomas Hucke Leiter Internet/Intranet • SharePoint • Customer Management • Preiskalkulationen • Employee-Self-Service • Manager-Self-Service • Reporting • SharePoint • Word • Outlook • Customer Factsheet • Sales Cockpit • Materialmanagement • Reporting • SharePoint • Employee-Self-Service • Manager-Self-Service • BW Dashboard • Customer Management Wir bieten Ihnen auf Basis unseres Produktes „iQL Studio“ folgende Lösungen an: • Employee Self Services (ESS) • Manager Self Services (MSS) • Travelmanagement • Customer Factsheet • Sales cockpit • Materialmanagement • Angebots- und Auftragswesen • CRM • Zeiterfassung mit CATS • BANF Bestellanforderungen • Und vieles mehr… Beispiellösung „Urlaubsantrag“ mit Anbindung an: • SharePoint Server 2007 • Outlook • Exchange Server • Office Forms Server 2007 • Windows Mobile Device Demo Das iQL Studio-Komplettpaket: • Entwicklung • Schnittstellen • Administrationswerkzeuge • Deployment & Migration Demo Kontakt www.sitrion.com [email protected] 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 Call to action 1 Portal and Information Integration within SAP and Microsoft works today, take away the Portal Interoperability Guide 2 Explore today’s Web Services Interfaces from SAP including Enterprise Services – many things work with existing services 3 Microsoft Forms Server provides a full Forms solution for SAP, test your own flavour 4 SharePoint can be extended with first class Partner Solutions like iQL Studio from Sitrion today 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-9071c15c65f46064/microsoft_sharepoint_sap_portal_interop_V2.zip Forums http://blogs.msdn.com/saptech http://sdn.sap.com: .NET Technologies Forum ASUG Community of Interest (CoI) for Microsoft - SAP Interoperability