cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing Datasource from communication channel

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

.

Former Member
0 Kudos

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

udo_martens
Active Contributor
0 Kudos

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