Obtaining Data From SAP

How can you obtain data from a SAP system using ASP.NET or VB.NET ?
Who is Participating?
TwisteddkConnect With a Mentor Commented:
My appologies.... I read your question to fast the first time around. if you need .NET, you need the .NET connector, available on http://service.sap.com/connectors (press "SAP connector for Microsoft .NET")

It's free to download, but you still need a developer key/license for the SAP system to use/develop for the connector.

For futher information about the connector, you should check out the class: BIT528 (5 day course, as I recall).

For code samples, check out http://help.sap.com/saphelp_erp2005/helpdata/en/27/3fef6927ad044da62dee1b86d68ec2/content.htm

That depends if you mean event driven data extraction, time driven, or an interactive run.

Interactively, means you need to be able to handle a LOT of possible errors
Event driven means a lot of work in SAP aswell
Time driven is not very flexible.

If you want to do it by time, it's fairly easy. You simply create a report in SAP that'll write the data to a file somewhere, then read the file from ASP or VB.

However, if you want it to be event driven, then you still need the program, but you also need to program an event in SAP, trigger it and read the resulting data.

Though I suppose you COULD interactively read the data by sending information through the API in the R3 DCOM connector, if you know how to do that. The DCOM supports both ASP and VB. Remember to use the latest version of the DCOM connector.
cehrnowAuthor Commented:
Yes, apologies, I should have been clearer - I do mean interactively and sounds like the R3 DCOM API allows a VB.NET or ASP.NET program to make a direct call to SAP to extract necessary data. Is a .NET component available ? Do you have any VB.NET or C# code samples to show the basis idea ?
Is the R3 DCOM freely available or does it cost ?
Many thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.