File to Jdbc Stored Procedure

[Former Member]

Hi friends,

I am doing file to JDBC using stored procedure. Could you please send me any Blog's

Thank you

Sam

[Former Member]

hey

have a look at the following

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Thanx

Aamir suhail

[Former Member]

Hi Aamir,

Thank you. Any thing else.

I don't know much about stored procedure. is there any end to end scenario or blog. how they configure for stored procedure.

Thank you

Sam

[Former Member]

hey

they link i gave u earlier actually has Stored procedure on receiver side,its HTTP to stored Procedure(JDBC) scenario.

u just have to replace the HTTP with File ,have a look at the following for File to File scenario

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

for your scenario,first of all u need to have a stored procedure on the Database,then only u can call execute this via XI and post the data.

if you want to pull up the data from database then you need to use BPM coz File cant handle response.

if you are new and are doin the scenario just for practice sake then i would suggest u to start off with File to File and then try the HTTP to Stored proc(JDBC),after that you can practise BPM scenarios

Thanx

Aamir