SAP R3 to Oracle Database Interface

[Former Member]

Hello Experts,

I have a requirement to pull data from some external Oracle Database(Not related to SAP) Table data and put it into R3 Table.

Is there any standard interface available like SAP BW DB-Connect or what is the standard way for SAP R3?

Please let me know the How to Guide.

Best Regards

Arun Prasad

[Former Member]

Hello Murthy,

Could you please provide or Point me to some How-to Documents for Oracle extraction scenario for SAP R3?

E-mail : reachuarun@gmail.com

Thank you

Arun Prasad

[moorthy]

Hi,

Probably I dont have exact guide , but this will help you to get the data into XI-

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea...

In this doc, they mentioned about Lookup from Mapping, instead of this , you can configure JDBC adapter as a Sender to get the data into XI and then map it and send it to R/3..

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards,

Moorthy

[moorthy]

Hi,

Some options are:

One option you can think of is pulling the data from Oracle table with JDBC adapters and then pushing the data to SAP thru ABAP proxy.

like JDBC->XI->ABAP proxy/RFCs etc

One more option is go for Services from Oracle application as an Webservice and using that in XI and then proxy /rfcs etc..

Regards,

Moorthy