Keywords: SAP R/3 4.6c, SQL2005, SharePoint Portal Server 2003, Business Scorecard Manager 2005
In this tip, I will demonstrate how to access SAP via .NET Provider for mySAP and create reports and present on SharePoint page directly.
I set up three servers, one is SAP 4.6c IDES and another two are SQL 2005 and SharePoint server. The components installed in each server are seen in below figure.
Some highlighting installation issues:
The two RFCs installation guide please check the readme.html which is included in the new feature pack download of .NET Provider for mySAP Business Suite.
The Librfc32.dll 6.20 above version should be copied to SQL 2005 server s \windowssystem32.
The librfc32 acts like a messenger between .Net provider and SAP. .Net provider use librfc32.dll to communicate with SAP and acts like an adapter between SQL 2005 and SAP. ?The Provider works like any other managed provider. It implements the ADO .NET classes such as DbConnection and DbCommand. Currently with SQL Server 2005, it is a partial implementation due to limitations on features supported against SAP. For example, the Provider cannot browse the SAP database schema, unlike the Oracle or SQL Server providers. (Microsoft .NET Data Provider for mySAP Business Suite http://msdn2.microsoft.com/en-us/library/ms141761.aspx )
The .NET Provider can invoke three methods to access SAP data: RFC, BAPI, Query Tables.
Now we can use above environment to create a report service project to present SAP tables in three methods: RFC/BAPI/Query Tables.
Create SQL Reports
1. Go to SQL 2005 server
2. Start -> Programs ->Micosoft SQL 2005 -> SQL Business Intelligence Development Studio
3. A standard visual studio screen pop up. File -> New Project
4. The solution explorer has two folders, one is Shared Data Source and another is Reports.
5. Right click the solution name, change the target report server property like below screenshot
6. Right click Shared Data Source folder in solution explorer -> Add a new data source. Name the data source and select SAP from the type dropdown menu.
7. Click the Edit button to define SAP data source properties such as Client, System number, SAP IDES ip address or server name etc.
8. Right click Reports in solution explorer ->Add a new report, a report wizard pops up.
9. Select the data source we just created in step 6-7.
This query invokes a RFC to get customer list from SAP IDES
11. Define the report display style.
12. Name the report
13. Right click the report just created, build and deploy it
14. go to the report server web site to check the report, say, http://yousqlservername/reports/, just as below figure
For other methods, we just change the query in step 10, for example,
Exec BAPI_CREDITCARD_CHECKNUMBER @CREDITCARD_TYPE= VISA , @CREDITCARD_NUMBER= 4346764526349895
Exec RFC_CUSTOMER_GET @NAME1 = *
select * from Mara
1. Microsoft .NET Data Provider for mySAP Business Suite http://msdn2.microsoft.com/en-us/library/ms141761.aspx, accessed in Dec., 2005
2. Configuring ReportingServices to Use the Microsoft .NET Data Provider for mySAP Business Suite , http://msdn2.microsoft.com/en-us/library/ms345256.aspx, accessed in Dec., 2005
3. Download: Feature Pack for Microsoft SQL Server 2005 – November 2005 http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en , accessed in Dec., 2005
4. Configuring Reporting Services to Use Integration Services Package Data http://msdn2.microsoft.com/en-us/library/ms345250.aspx, accessed in Dec., 2005
5. Use SQL2005 to Connect and Present SAP on SharePoint / Business Scorecard Manager Part I, Ted Teng, /people/ted.teng/blog/2005/12/28/use-sql2005-to-connect-and-present-sap-on-sharepoint-business-scorecard-manager-150-part-i, accessed in Dec., 2005.