Adapter Layer: MSSQL Database Adapter

MSSQL Stored Procedure Adapter requires configuration of both transport and adapter layers of the adapter. To create adapter layer of MSSQL Stored Procedure Adapter:

Requirements for MSSQL Database Adapter

Adapter Name
Adapter name will be listed in Properties of MSSQL Database Node on SSQUARE Toolkit. See more about Adapter Name Concept: Logical and Physical Reference

Data Structure
Before calling a stored procedure, input and output parameters must be mapped. So SSQUARE knows what parameters will be passed to the stored procedure and what will get in return. On SSQUARE Adapter Management, you can simply follow the steps in the Stored Procedure Configuration section to automatically retrieve input and output parameters of the stored procedure.

Create MSSQL Database Adapter

  1. Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. http://ssq.techberry.com:8380/adapter (Google Chrome is recommended)
  2. Select MSSQL Database on sidebar 
  3. Click + to create a new MSSQL Database adapter
  4. Define adapter name in Adapter Name field
  5. In Stored Procedure Configuration section, select Data Source Profile (Data Source Adapter Name)
  6. Click Next
  7. Select Schema from the list
  8. Select Stored Procedure from the list
  9. Click Next
  10. Click Execute
  11. Verify Input and Output parameters
  12. Click Next
  13. View Input and Output parameters summary
  14. Click Create

Now your MSSQL Database adapter is all set, ready to use as a reference on MSSQL Database node. To use your adapter, you will find and select your adapter in Adapter Name field on Properties setting of MSSQL Database Node.