MSSQL Stored Procedure Adapter
Instead of replicating a series of SQL statements, stored procedure is a great way to securely call a group of database statements that often reuse in your API services. If you have a stored procedure in Microsoft SQL Server and want to integrate it in service flow, a few steps needed to create MSSQL Stored Procedure Adapter.
Before you begin
Herein SSQUARE, stored procedure adapter is decoupled its configuration into 2 layers;
- Transport Layer – Create your database connection
- Adapter Layer – Select schema and stored procedure you want to use
You will need to create Data Source Adapter and MSSQL Database Adapter respectively to call a stored procedure in service flow on SSQUARE.