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.

  1. Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. http://ssq.techberry.com:8380/adapter (Google Chrome is recommended)
  2. Select Data Source on sidebar 
  3. Click + to create a new Data Source adapter
  1. Define adapter name in Adapter Name field
  2. Provide required database server connection properties, username, and password in Basic Configuration section
  3. Click Test Connection
  1. If test connection successfully, click Create