Stored Procedure 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.
| Field | Description |
|---|---|
| Connection Name | Choose the database by selecting a connection from the connection name drop down. Supports Oracle and MSQL. |
| 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. |
If you have any feedback on Gathr documentation, please email us!