Interfacing between .Net and SAP R/3

[Former Member]

Hi ,

I want to read the data from SAP and then to display it in the form of report using .Net.

Kindly tell me the List of all option available.

Thanks

Dharmbir Singh

[Former Member · Accepted solution]

Hello,

there are a lots of option depending on the version of your SAP system, do you use SAP BW or NetWeaver BI, do you want to use SQL Server Reporting Services, do you have BizTalk Server or SAP XI/PI in your landscape, ...

If you are using NetWeaver BI or SAP BW you can use the .NET Data Provider for NetWeaver BI and Microsoft SQL Server Reporting Services, if you are running a newer SAP release (on Web AS 6.40 and higher) you can use Web Services, if you are running an older SAP version you can use a connector like the WCF LOB Adapter from Microsoft or the SAP Connector for Microsoft .NET (requires Visual Studio 2003!!). I would recommend reading through this forum and check also http://www.microsoft.com/sap, in the Interoperability area you will find some really useful whitepapers describing the different approaches.

Regards,

Juergen

Edited by: Jürgen Daiberl on Feb 11, 2009 2:23 PM

[Former Member · Accepted solution]

Hello Juergen,

I know little about SAP. I am having SAP R/3 (version 5.0),VS2005 and VS 2008 . I have checked with the sap connector ,they are very expensive and for some of them we require VS 2003.Please guide me which will be best suited for me.

Thanks

Dharmbir Singh

Edited by: Dharmbir Singh on Feb 12, 2009 6:25 AM

[Former Member · Accepted solution]

Hello,

from what I read you are running on ECC 5.0, is this correct? In this case you are running on Web Application Server 6.40 at least so you can use Web Services for communicating between .NET and SAP. Check out the paper about stateful Web Service Communication on http://www.microsoft.com/isv/sap/technology/interop/dotnet.aspx, this will not require any additional licenses for an adapter.

Regards,

Juergen

[Former Member]

You need to create a RFC or a Bapi In SAP and then use it in .net using SAP .NET Connector.

You can also create a webservice in Sap and use it in the .net application.

For details please refer : http://weblogs.sqlteam.com/jhermiz/archive/2007/08/14/60282.aspx

https://websmp103.sap-ag.de/connectors

You can also get the help from help.sap.com for both sap.net connector and webservices