Step 2.1 : Create Transport Layer: Data Source Adapter
Make sure that you have the stored procedure already and then you can create the Data Source Adapter to use with 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 Data Source on sidebar
- Click + to create a new Data Source adapter
- Define adapter name in Adapter Name field
- Provide required database server connection properties, username, and password in Basic Configuration section
- Click Test Connection
- If test connection successfully, click Create