Step 2.2 : Create Adapter Layer: MSSQL Stored Procedure Adapter
- Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. http://ssq.techberry.com:8380/adapter (Google Chrome is recommended)
- Select MSSQL Database on sidebar
- Click + to create a new MSSQL Database adapter
- Define adapter name in Adapter Name field
- In Stored Procedure Configuration section, select Data Source Profile (Data Source Adapter Name)
- Click Next
- Select Schema from the list
- Select Stored Procedure from the list
- Click Next
- Click Execute
- Verify Input and Output parameters
- Click Next
- View Input and Output parameters summary
- Click Create
- Run the test: See more Test MSSQL Database Adapter
- Enter Input Parameter (if any)
- Click Run Test
- View Output Parameter