Sending and Receiving data from SAP to SQL server in same program

[Former Member]

Hi,

I am sending data to Microsoft SQL server and it will be saved in a table in SQL server. Then SQL server processes this data in table and saves the results in another table in the same SQL server.

I want to send the data from SAP and get back the results from SQL server in the same transaction/program.

How do I do that in ABAP program? How can I wait in the program to check if the second table in SQL server is ready for reading results?

Thanks,

Ashok.

[Former Member]

Hi Ashok !!

You can do this only if you have yor sap installed on Windows platform. Then you shoul create connection do SQL Server in DBCO transaction, and tehen use native sql in abap program. If you have Sap installed in non-windows platofrm you should install Busiines Connector or XI.

Bussiness Connector is free !!

BR, Jacek