How to run a SAP HANA database stored procedure using TaskCentre

 Solution

1) Within Windows: Create a 32 bit DSN to the HANA database

2) Within TaskCentre : Manage > Tools > Execute > Call Stored Procedure (OLEDB), create a connection using the Microsoft OLEDB Provider for ODBC drivers, and reference the DSN created in step 1.

Please see the following link for further instructions on how to create a system DSN:

Setting up an OLE DB call stored procedure that connects to a 32bit ODBC system DSN

You can now execute the stored procedure from within the Call Stored Procedure (OLEDB) tool.