Sower SAP ABAP Architecture

This tip demonstrates how to use SQL 2005 report server to access SAP existing tables via .NET Provider. The .NET Provider implements the ADO .NET classes such as DbConnection and DbCommand. It uses librfc32.dll to communicate with SAP to get data from SAP. The demo shows you do not need write any codes but just some sql statements to access SAP tables and then present them on SQL report web sites. You can image if your SAP have a quite amount of tables developed in ABAP. Then just a few steps takes you quickly transfer the tables to become a web-enabled presentation. You can get rid of the SAP GUI limitation.

In this tip, I will demonstrate how to extract SAP data via .NET Provider for mySAP into SQL 2005 database and then use SQL2005 business intelligence — analysis service to create cubes and then use reporting service to create report model and finally create reports using report builder and present on reporting service web page.

In this tip, I will demonstrate how to present reports on SQL report server on SharePoint page and explore the possibility of using Business Scorecard Manager to present KPIs based on analysis cubes.

Mobility for SAP provides simple mobile access to ERP, CRM and mobile workflow approval since more than one year. Now with the new AddOn for workflow it is even simpler to implement.

August 21, 2009. Waltham, MA.

Sower’s Technical Director has received the major prize for winning a global innovation challenge. The $USD10,000 Social Networking challenge was posted by German software giant SAP through Innocentive.com. Over 1,200 solvers from around the world registered and 3 prizes were awarded.

› Continue reading