StoredProcedure Processor

The Stored Procedure processor is used to run a set of SQL queries. The user can now invoke stored procedure and functions defined in the database within Gathr. While the input data is passed as an argument to functions and stored procedures, the resultant output can be used to enrich the incoming data.

Instead of sending multiple SQL statements to the database server, an application can send a set of queries in what is called a stored procedure.

A function is a set of SQL statements that perform some operation and return a result.

Processor Configuration #

Connection Name: Connections are the service identifiers. A connection name can be selected from the list if you have created and saved connection details for any supported database earlier. Or create one as explained in the topic - JDBC Connection →

Operation: The two types of operations available are: Stored Procedure and Functions. Upon selection Stored procedure, the user will get to choose from the Stored procedures available in the database. While as, if the user opts for Functions; he can choose the functions. (as shown in the below image)

User can map the operation input with the source and can add subsequent configuration.

Ignore in Inspect: By selecting this option, the updated records will not be changed during inspect.

Stored Procedures: Stored Procedure/Function – Select a procedure or function from the drop down.