Stored procedures are a particularly helpful way of calling multiple SQL commands within 1 statement and may be necessary for database integrity where multiple table references are called.
When calling a database's stored procedure from Umango's ODBC export connector, you will need to reference your procedure with the syntax below (in place of the regular SQL command):
EXEC dbo.MyProcedure @MyParameter=<<MyIndexValue>>
As Umango's ODBC connector can only call 1 SQL query at a time, stored procedures provide a method of performing more complex vested commands using a 1 simple command in Umango.
Link to this article http://umango.com/KB?article=115