on 07-28-2008 6:33 AM
Hi,
What are the important parametres to be remembered while working with sender and receiver JDBC Adapters
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in Access Node.. u need to specify field names...
in Action Attribute.. u need to assign a constant like UPDATE_INSERT like tat
in Key1... u need to specify where conditions...
thanks ragu
is the given answers and the properties where you have specified are common for any scenario
Hi Amruth ,
The following websites wil answer u'r question in detail:
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...
Example Scenario...
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC
<removed by moderator>
Edited by: Mike Pokraka on Jul 28, 2008 5:07 PM
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
Document Formats for the Receiver JDBC Adapter
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
in Receiver JBDC...
DT should have format
Statementname subnode table name subnode. then action attribute..
Access subnode contain Fieldname , which is inserted..
key1 node is where conditions
Hi ragu,
With which field the data will be stored in Database.
in Sender JDBC,
u need to write a Select Query in Sender JBDC Comm Channel and Update statement in CC and need to give polling Interval...
in Datatype...
Statementname... subnode ROW then SubElements Fields selected in Select Query in Sender JDBC CC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.