Stored procedure by a JDBC sender

[deepaksamtaney]

Hi,

My scenario involves accessing an SQL server to XI to APO.

I need to invoke a stored procedure residing on SQL server in order to get the data into XI.

Can somebody suggest how i acheive this.

It has to be done every month...so is there a way i can schedule the JDBC sender adapter

Thanks,

Vineet

[Former Member]

Hi Vineet,

Yes, of course you can invoke Stored Procedures on SQL server using XI. The link you are looking for is this:

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

The only limitation is that you can have only one SELECT statement in the Stored Procedure.

Regards,

Puloma.