Regarding Connectivity

[Former Member]

Hi Gurus,

I have requirement like , Non SAP System ( VB.Net ) need to call the SAP sytem through a particular DLL and get the result from the SAP. As of now that DLL calls a stored procedure and get connects to other system.

Please let me know what will be the best way to connect the SAP.Can i write any Stored procedure in Oracle( SAP's Database) and call from the DLL which is in another system .

Regards

Vikranth

[michael_hobbins]

Hello Vikranth,

there are several ways to connect you .net application to SAP either to get data or send data to be processed and stored. With the latest ERP versions, the best approach is a webservice generated from RFC function module. You could use the DCOM Connector, but it's an old technology (though not obsolete) which works using a DLL (the DLL will be referenced on your .net app, and though it you call RFC function modules)

Check this [video|http://www2.um.edu.uy/mhobbins/sdn_forums/complete_demo.zip] to see and end to end demo to get a webservice going and how to use it. A short intro before you watch the video: I made a simple RFC, it receives an ID, and returns two variables: name and surname. Only valid ID is value "1", and that will return name=Michael and surname=Hobbins. The demo starts on Tx SE80 building the webservice (notice I don't check the activate webservice just because it didnit work when I tried to when we started working with webservices). With the webservice created, I activate it from Tx WSCONFIG, from there I move to SICF to add the user and password I want it to run with, and finally check for the webservice URL by testing it and adding "&wsdl=1.1". From there I move on to VS2005 and reference and call the methods provided. Code on VS2005 is C#, if you can't follow and recreate for VB.NET, tell and I'll post an example for VB.NET.

Hope this gets you started

Cheers

Michael