oracle db - XI - R/3

[Former Member]

hi,

we have a table in the oracle 10g database..... i have to take a few fields and update it into R/3 system.

i found out that i need to use jdbc adapter only...

can anyone give me a small breif on what should be done...

if i can use IDOC's r BAPI's.... r what should be done in both the ends...

[Former Member]

Hi,

You need to have a JDBC Sender adapter, which will poll ur database for delta records and send it to XI , where in u can manipulate the data using Transformations provided by XI.

You can post the data to R/3 through BAPI or IDOC using RFC or IDOC receiver channel respectively.

The choice of BAPI or IDOC totally depends on you.

You can find enough documents regarding configuring JDBC Sender Adapter and RFC , IDOC receiver adapter within SDN as well in SAP Help.

Regards

Shailesh

[Former Member]

Hi Mithun,

You need to use Sender JDBC adapter at Oracle->XI and XI>R3 you can use IDOc's RFC or you can go for Proxy where you have to write your own code to update the tables at R3 side.

Kindly find the below links to handle JDBC sender side

Tips and Tutorial for Sender JDBC Adapter

[Former Member]

Hi,

Use JDBC Adapter to pull the data from Oracle Application side and

You can use the Idoc(if u have standard one) or RFC( if it is Sync) or Proxies(if u dont have Idoc and ur WAS >=6.20) Accordingly to ur requirement

JDBC-File_Using Adapter Scheduling

For this first you have to Install the JDBC Drivers on XI Server

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

Regards

Seshagiri

[Former Member]

use BAPI if you have Standard BAPI with implicit Commit and if you require Response from R/3.

Use IDOC if you have Standard IDOC and u dont need Response from R/3

[Former Member]

Hi ,

You need to use JDBC as the sender as your source system is oracle. and you need to use BAPI as you are updating it to SAP tables....

Thanks,

Madhu