Message protocol is different for sender and receiver JDBC

[Former Member]

In File adapter the message protocol can be either FTP or NFS for both sender as well as receiver. but for JDBC adapter the message protocol is JDBC and for receiver adapter the message protocol is XML SQL Format or native sql string only. Why this is different ? Why cant we use JDBC as message protocol for receiver also ?

I thought JDBC is the message protocol for JDBC adapters irrespective of whether they are sender or receiver. Can someone throw light on this ?

[Former Member]

Hi,

You can find more about JDBC scenario at following links:

Configuring the Sender JDBC Adapter

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

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

Configuring the Receiver JDBC Adapter

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

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

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

Regards,

[Former Member]

Hi Ajith

Sender JDBC adapter is basically doing select query which can pass data to a XML based query format.

Receiver JDBC adaptor rely on XML based or Native query to pass the data and hence PI have only these as message protocol.

XML SQL Format - Table values can be inserted, updated, or deleted in one or more tables. In the database, stored procedures can be called using transfer parameters. In the case of synchronous queries, results from database queries or return values of stored procedures can also be transferred. There are various Document formats that you can get from following link

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

Native SQL String - An arbitrary SQL statement is expected as the message content. This statement is transferred unaltered to the database for processing.

Thanks

Gaurav