SAP integration with MOSS


There is a lot of really powerful integration between SAP and MOSS and the awareness about this is really, for some reason, quite low. We've talked about integrating LOB data into SharePoint with the Business Data Catalog but there are some specific capabilities to SAP when brought together with SharePoint that make an enterprise solution rich, user-friendly, and seamless.


To give you a quick overview of the BDC, it's a way to bring LOB data into SharePoint without writing any code. You just define your entities with an Application Definition File (ADF – of type XML file) which you upload into the SharePoint Central Administration and then reuse throughout your portal as a shared service. You can then surface that LOB data as SharePoint lists, web parts, enterprise search, lists, user profiles and custom applications. It uses either SOAP to connect to the LOB system if it's a traditional one like SAP, or ADO.NET if it's a database system like SQL. In my previous blog post, I mentioned that the latest version of the SDK made available a tool for authoring the ADF file so that you no longer have to work with straight XML.


How does this register with the SAP web services? The ADF corresponds to the WSDL file of the SAP web service and it must also reference a Single Sign-On application that will manage the credentials of the users. The ADF is then imported into the BDC and once the application is registered, the data can be surfaced in the ways I mentioned above, displaying data from the backend SAP system.


SAPandMOSS


So what's so special about SharePoint integration with SAP? First of all, SharePoint has special page redisplay so you can display SAP data inside WebParts residing in SharePoint or custom ASP pages. iViews in SAP are hosted in WSS iView WebParts.


IntegrationOptions


One application here would be to show employees in their mySites a view of pending SAP expenses reports.


A few other integration options:



  • You can use WSRP if you want to create a custom look and feel to your view. It's preferable to URL wrapping since it's a true web service and not simply another system's HTML.

  • You can display entire BSPs in web parts. HTTP or HTTPS is used to access the application across the network so firewalls and proxy servers can be used. SAP portal is not required to execute BSPs.

  • Accessing SAP data using services and bringing it into WSS or the client (e.g. through Enterprise Search, lists, in the client in a custom task pane or custom apps)

  • Surfacing SAP data for analysis – this involves exporting SAP data into a warehouse and then consuming the warehouse using Excel pivotCharts, Excel Services and dashboards

If you'd like to look into a few more resources on this topic, check out the following:


Resources for Interoperability with MOSS


White paper on Integrating MOSS and SAP


White paper on Integrating SAP BSP into SharePoint


White paper on How to integrate WSS and Exchange into SAP Enterprise Portal


Comments (10)

  1. Some really good information on SAP and MOSS Integration available at the following post: http://blogs.msdn.com/joanna_bichsel/archive/2007/09/25/sap-integration-with-moss.aspx

  2. Well … I need information on SAP integration with VS.NET, Biztalk, MOSS and SQL. Found interesting

  3. Well … I need information on SAP integration with VS.NET, Biztalk, MOSS and SQL. Found interesting

  4. La Integracion de Aplicaciones LOB con Portales es hoy una de las principales preocupaciones de grandes

  5. Soeren Staun says:

    Thanks for a good blog.

    I still haven’t seen any good integration articles between SAP and MOSS where SAP controls at least parts of the page-flow, i.e. using SAP workflows/processes.

    Thanks.

  6. soumya kurup says:

    Can data flow from MOSS to SAP?

  7. Can someone provide me any link or document for SAP PI Integration with MOSS ? Specifically SAP PI

Skip to main content