Question:
Can anyone tell me what I need to do in order to get data from an MS SQL Server 2000 database table hosted on a local server into SAP?
I would like to be able to call an RFC function module from within my ABAP program and connect to this external database and get data from it.
Would this require native SQL?
Please help!
KS
Answer:
you need to use a kind of connector (service.sap.com/connectors) to connect from SAP to your legacy system. in this case i would recommend to use .NET connector. With this connector you can easily write a programm that accepts an rfc request from sap and sends back the required data to your SAP system.
Regards
christine
Answer:
Thanks!