idoc to jdbc

[Former Member]

Hi experts..

My scenario is to send the data from SAP R/3 TO oracle data base which updates the data\chages in oracle data base?

Explain me this scenario?

thank you

[former_member200962]

Firstly check the format in which SAP will be sending the data (IDOC/ RFC/ Proxy)

If it is IDOC/ RFC then import the corresponding component into Integration repository.

If it is Proxy then develop a DataType, MessageType, Message Interface....then ask the ABAP person to develop a proxy on this Message Interface.

If it is IDOC/ Proxy then there will be no Communication channel....however for RFC you need to have a Communicatiopn Channel.

For Inserting data into DB you have to develop a Datatype whose format is as explained in this help section:

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

At the target end have a Communication Channel with Adapter Type as JDBC.

If you have any confusion regarding JDBC message format then refer blog by Krishnamoorthy.

Regards,

Abhishek.

[Former Member]

Hi,

Please see this weblog as guideline:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Here instead of file you will have your sap system. Get the data into xi using idoc, proxy or rfc and from there you can follow this table.

Regards,

---Satish

[Former Member]

Hi,

Try to search on SDN for same scenario, you will get so many threads.

Please refer to the below thread, hope it helps you.

Thanks,

Hetal