on 07-11-2005 12:48 PM
Guru,
I've creates a datasource in JDBC Connecter and tested the connection successfully. Now i want use this datasource in my communication channel to send and retrieve data from database. I'm not sure how i can go about, did anybody tried the same? Please help me how i can achive this.
Thanks in advance.
Uday Singh
Hi Uday,
Please go through this link:
File to JDBC by anirban ghatak
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30
also you can study about Stored Procedures by Mr. Siva Marnani:
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
I hope it helps,
Thanks & Regards,
Varun Joshi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to all gurus.
I've been to this links but no link tells me how to use the defined DataSource in the communication channel. My question is instead of providing the driver, connection, user and password while creating communication channel can't i use the DataSource which i created in Visual Administrator under Service -> JDBC Connector -> Resource ->DataSource ->MyDs.
Uday
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Uday
Configuration link for Sender Adapter
<b>http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm</b>
Configuration link of Reciever Adapter
<b>http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm</b>
XML Document Format for the Message Protocol XML SQL Format
<b>http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm</b>
Hope it helps.For further doubts u are free to post
Regards
Arpit Seth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Uday,
set up a JDBC sender channel. Put connection, driver, user and password. Use a pollinterval, how often to request.
Put your Request-Statement (Query SQL), give name and namespace for your xml message.
Finally put Update-Statement, so that you don't read twice.
Regards,
Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.