How to configure JDBC Adapter(Sender & Receiver)

[Former Member]

How to configure JDBC Adapter(Sender & Receiver)

Rgds

Ruchitha

[Former Member · Accepted solution]

First go thro'

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

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

Now go thro' the below blog for better understanding!!!

JDBC to JDBC

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

[Former Member · Accepted solution]

Can any one send me the theory part?

Ruchitha

[Former Member · Accepted solution]

Ruchika,

Actually u need tto understand first whats the need of using JDBC adapter and under which circumstances we will go for JDBC related scenario...

The JDBC adapter enables you to connect database systems to the Integration Server . The adapter converts database content to XML messages and the other way around.

Database content can be read with any SQL statement. A special XML format is defined for content coming from the Integration Server or the PCK. This format enables SQL INSERT, UPDATE, SELECT, DELETE, or stored procedure statements to be processed. A message is always processed in exactly one database transaction.

To be able to use the JDBC adapter you must install the JDBC driver for the database that you want to connect to. The required Java libraries are product-specific and must be obtained from the database vendor. Following installation, you must deploy the Java libraries on the J2EE server so that the JDBC adapter can access the required Java classes at runtime.

For FAQs about the JDBC adapter, see SAP Note 831162.

i hope this helped u!!!

regards

biplab

[vikas_agarwal]

Hi Ruchitha,

Check your mail id.

i have send you a Document for configuring JDBC Adapter( Sender and Receiver)

Regards,

Vikas

[Former Member]

Hi ruchitha thakur ,

These r the following web-sites which give u detailed information about configuring of JDBC Adapter(Sender & Receiver)

JDBC is a technical Adapter provided by SAP.

Configuring the Sender JDBC Adapter

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

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6d36d51d-0b01-0010-b3aa-9cb...

SAP XI Utilize SAP Adapters to connect to heterogenous systems

https://wwwn.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3fc4bd90-0201-0010-68bd-ab931b0...

cheers!

gyanaraj

***Pls reward points if u find this useful

[Former Member]

Hi,

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Configure Sender JDBC

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Configure Receiver JDBC

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards,

Shabari

[Former Member]

hi

more help on sender JDBC adapters

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

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

regards

Ramesh P

[Former Member]

Configuring the Sender JDBC Adapter

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

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm