how to cofigure the JDBC Sender adaptor

[Former Member]

how to cofigure the JDBC Sender adaptor,

i want to do the scenario JDBC>XI>SAP

Thanks & Regards,

priya reddy

[Former Member]

This message was moderated.

[Former Member]

Hi guru's,

All of u thank you,my question has been answered,once again thank u.

Thanks & Regards,

priya reddy

[Former Member]

This message was moderated.

[Former Member]

Priya,

From your Date of registration in SDN I see you are quite new to SDN. Questions are always welcome in SDN forums. But please do some searching before posting a new question. There have been a zillion times such topics were discussed in SDN before.

Also I strongly suggest you read the Rules of Engagement in SDN /people/michael.schwandt/blog/2008/06/23/moving-to-strict-rules-to-improve-quality-and-control

Regards,

Jaishankar

[Former Member]

HI

Database (JDBC) Adapter

The JDBC Adapter allows access to any DB that allows a JDBC driver to access the DB. This driver is not supplied with the adapter but must come from the DB provider or a 3rd party. The adapter converts database content to XML and vice versa.

Database content can be read with any SQL statement using a special XML format. This format enables SQL INSERT, UPDATE, SELECT, DELETE or even stored procedures. A message is always processed in one database transaction.

Refer the following links for further assistance

JDBC ADAPTER:

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Use thes step by step guidese

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

https://wiki.sdn.sap.com/wiki/display/XI/XMLFile2XMLFile

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

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm for sender side JDBC configuration.

Follow this link

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

cheers

reward points if found useful

[Former Member]

Hi ,

Based on your database like Microsoft DB or Oracle DB you need to deploy compatible version JDBC driver for the specific database on XI server.

Check whether it is deployed successfully or not using Visual Administrator.

After sucessfully deployment of JDBC driver,

provide the following information to the JDBC sender adapter channel configuration.

eg : for Oracle database

JDBC Driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin:@<DB IP>:<DB port>:<hoststring>

user :

pwd :

Query SQL statement :

Update SQL statement :

Provide the correct values to these parameters.

This will help you to correctly configure the sender JDBC adapter channel.

Regards

Ashwin Kumar Dhakne

[Former Member]

hi,

Check these links.

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

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

check this for receiver too..

JDBC Receiver Adapter -- Synchronous Select – Step by Step

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

Thanks,

Vijaya.

[Former Member]

Hi,

In the sender side choose JDBC adapter and give the select query in that corresponding field and write update statement in the corresponding update field.

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm for sender side JDBC configuration.

Follow this link

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

At the receiver side you may use the IDoc/BAPI/RFC to connect the SAP

[former_member537867]

Hi,

Plz do follow the below links to have an idea regarding SENDER JDBC

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Use thes step by step guidese

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

https://wiki.sdn.sap.com/wiki/display/XI/XMLFile2XMLFile

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

Regards,

Vinod.

[Former Member]

Configuring the Sender JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

*********Reward points,if found useful