Executing a stored procedure

The Execute Stored Procedure allows you to call a stored procedure in the target database connection.

On the Configuration tab:

1. Define the procedure to be executed.

2. Click Preview SQL to review the resulting SQL statement.

The most common application is to extend the functionality of Data Guru by calling existing SQL code to further process your data.

Execute a stored procedure

1. Drag the Execute Stored procedure icon onto the design surface.
2. On the Connections tab , enter a Name and a Description to identify the action, then specify the input delimited file and output database table options, then specify the target database.
   • Database Connection – Select the database on which the stored procedure is being run, or choose New Database Connection to establish a new connection.
3. On the Configuration tab:
   • For Call Definition, specify the procedure to be called. You can type it in, or paste it from another source.
   • Click Preview SQL to view the statement that is executed to run the Stored Procedure.