Useing a Idoc an Oracle database Can be update useing JDBC Adapter

[Former Member]

Hi Guys,

Can you help me on the above topic..

Regd's

Raj

[Former Member · Accepted solution]

Hi Raj,

An R/3 system to Oracle database integration is feasible. Please have a look at the following weblogs to give you a brief idea. I think you simply have to start working on the scenario and get bac here if you have any specific queries.

You will have to import the IDoc, create a datatype for the target side, configure only a receiver JDBC adapter. Ofcourse, if you hav any specific stateful processing to be cdone, then you will have to perhaps use a BPM.

Blogs:-

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Sushumna

[Former Member]

Hi Raj,

here is the message-type for your insert:

<MessageTypeNode>

<dbTablename> : no Mapping neccesary

<attribute action> map to constant value = "insert"

<table> : map constant with name of table you want to insert

<access> 0: unbounded

<tablefield1>

<tablefield2>

<tablefieldn>

Regards Mario

[Former Member]

Hi,

Just refer the following links for IDOC-XI-JDBC Scenario

JDBC

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

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes - JDBC DATATYPES

IDOCS

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters - IDoc to File

/people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping - Any flat file to any Idoc

/people/pooja.pandey/blog/2005/07/27/idocs-multiple-types-collection-in-bpm - Collection of IDoc to Single File

regards

Mahesh

[Former Member]

Hi Raj,

You can use the Idoc Adapter on the sender side and JDBC on the reciever side. After you have configured your scenario, you should be able to write data into the oracle database.

For the strucutre of your Datatype for insertion , just check this link,

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

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Or on the JDBC end you can write a stored procedure to make your data update more efficient.

Go through this blog for stored procedures.

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

I hope this helps.

Regards,

Abhy