Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager — Part II
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.