How to create a Data Service for a RDBMS?

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)


DS

Figure: 1


In the first screen that appears, enter a name for your Data Service('DataServiceSample1').Select 'RDBMS' as 'Data Source' type.(Figure 2)


DS

Figure: 2


Enter values to be used to connect to database.


DS

Figure: 3


Enter query details using which values will be extracted.


DS

Figure: 4


Specify how SQL response is mapped to output XML


DS

Figure: 5


Once you add a query, it will be listed as follows.


DS

Figure: 6


Following query needs two parameters to be supplied for execution. Input Mapping section is used to specify input parameters.


DS

Figure: 7


Create an operation and select a query to be executed when this operation is called.


DS

Figure: 8


When query accepts parameters, there is an additional step. Following screen shows it.


DS

Figure: 9


Existing operations will be listed as follows.


DS

Figure: 10


Click 'Finish' button to complete the wizard.


DS

Figure: 11


Deployed Services will be listed as follows.


DS

Figure: 12


Following statistics are available for a service.


DS

Figure: 13


Options mentioned in lower part of the screen can be applied to a service.


DS

Figure: 14


Click on 'Try it' link and you will be directed to a screen similar to following.


DS

Figure: 15


This is how Try-it shows results after service invocation.


DS

Figure: 16


If there are parameters, Try it allows you to enter them as well.


DS

Figure: 17


WSDL for the service can be viewed by clicking 'WSDL' link.


DS

Figure: 18


WSDL


DS

Figure: 19