Obtaining Data From SAP

Posted on 2007-10-06
Last Modified: 2013-12-08
How can you obtain data from a SAP system using ASP.NET or VB.NET ?
Question by:cehrnow
    LVL 6

    Expert Comment

    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 Comment

    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
    LVL 6

    Accepted Solution

    My appologies.... I read your question to fast the first time around. if you need .NET, you need the .NET connector, available on (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


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now