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
- 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
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.