To upload data from Ms-SQL into R/3

[Former Member]

Hi Guys,

Suppose client have two systems one is R/3 and the other is MS SQL database server, now what is the ideal way of uploading the MS SQL data into R/3. Please let me know what are all the possible ways of uploading data from MS SQL server into R/3.

Thank you,

Venkat.

[bhavesh_kantilal]

Sri,

You can have a SENDER JDBC adapter that will poll over the database , then seletc the data from your SQL Server Dataabse and push it to the R3 system.

The data can be sent into the R3 system using ABAP Proxies or an RFC modules

To get data out oif your Database, using a Sender JDBC adapoter is the best approach.

Regards,

Bhavesh

[bhavesh_kantilal]

Hi,

For sender JDBC adapter,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

ABAP Proxies,

/people/siva.maranani/blog/2005/04/03/abap-server-proxies

Regards,

Bhavesh