Obtaining Data From SAP

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

Expert Comment

ID: 20027636
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

ID: 20027948
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

Accepted Solution

Twisteddk earned 2000 total points
ID: 20030767
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


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month14 days, 18 hours left to enroll

840 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