We help IT Professionals succeed at work.

Obtaining Data From SAP

559 Views
Last Modified: 2013-12-08
How can you obtain data from a SAP system using ASP.NET or VB.NET ?
Comment
Watch Question

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.

Author

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
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.