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;

  1. Transport Layer – Create your database connection
  2. 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.