Step 2.2 : Create Adapter Layer: MSSQL Stored Procedure Adapter

  1. Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. (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
  1. In Stored Procedure Configuration section, select Data Source Profile (Data Source Adapter Name)
  1. Click Next
  2. Select Schema from the list
  1. Select Stored Procedure from the list
  2. Click Next
  3. Click Execute
  4. Verify Input and Output parameters
  5. Click Next
  6. View Input and Output parameters summary
  7. Click Create
  8. Run the test: See more Test MSSQL Database Adapter
  9. Enter Input Parameter (if any)
  10. Click Run Test
  11. View Output Parameter