This section explains how a Data Service can be created using a relational database table as a datasource.
One way of starting is by using the graphical wizard. To start the wizard click 'Add' link on your left hand menu. (Figure 1)
Figure: 1
In the first screen that appears, enter a name for your Data Service('DataServiceSample1').Select 'RDBMS' as 'Data Source' type.(Figure 2)
Figure: 2
Enter values to be used to connect to database.
Figure: 3
Enter query details using which values will be extracted.
Figure: 4
Specify how SQL response is mapped to output XML
Figure: 5
Once you add a query, it will be listed as follows.
Figure: 6
Following query needs two parameters to be supplied for execution. Input Mapping section is used to specify input parameters.
Figure: 7
Create an operation and select a query to be executed when this operation is called.
Figure: 8
When query accepts parameters, there is an additional step. Following screen shows it.
Figure: 9
Existing operations will be listed as follows.
Figure: 10
Click 'Finish' button to complete the wizard.
Figure: 11
Deployed Services will be listed as follows.
Figure: 12
Following statistics are available for a service.
Figure: 13
Options mentioned in lower part of the screen can be applied to a service.
Figure: 14
Click on 'Try it' link and you will be directed to a screen similar to following.
Figure: 15
This is how Try-it shows results after service invocation.
Figure: 16
If there are parameters, Try it allows you to enter them as well.
Figure: 17
WSDL for the service can be viewed by clicking 'WSDL' link.
Figure: 18
WSDL
Figure: 19