Data Services Server provide support for the following data sources.
Enter query details using which values will be extracted and specify how SQL response is mapped to output XML.
Figure 4: Configure Query Information
Following query needs two parameters to be supplied for execution. Input Mapping section is used to specify input parameters.
Figure 5: Input parameters
Once you add a query, it will be listed as follows.
Figure 6: View query
Create an operation and select a query to be executed when this operation is called.
Figure 7: Add operation
When query accepts parameters, there is an additional step. Following screen shows it.
Figure 8: Add operation with input parameters
Existing operations will be listed as follows.
Figure 9: View operations
Click 'Finish' button to complete the wizard.
Deployed Services will be listed as follows.
Figure 10: Deployed services
Following statistics are available for a service. Options mentioned in lower part of the screen can be applied to a service.
Figure 11: Service statistics
Click on 'Try it' link and you will be directed to a screen similar to following.
Figure 12: Invoke service using Try-it
This is how Try-it shows results after service invocation.
Figure 13: Service invocation
If there are parameters, Try it allows you to enter them as well.
Figure 14: Service invocation-with parameters
WSDL for the service can be viewed by clicking 'WSDL' link.
Figure 15: WSDL
For the RDBMS data source, select the data source type as 'RDBMS' after naming the data source. Enter values to be used to connect to the database.
Figure 16: Creating the data source for RDBMS
For the Carbon data sources, you have to create the carbon data source first.
To create the carbon data source click on the Data Sources menu item under the configuration.
Figure 17: Create Carbon Data Source menu
Click on 'Add Data Source' link in Data Sources page which will direct you to a page where you can enter the details for the data source. You can test the connection by click on 'Test Connection' button on bottom of the page. Add data source page with entered details is showing below.
Figure 18: Creating the Carbon Data Source
Once you have created the carbon data source, you can use it inside the data service. Select the 'Carbon Data Source' as the type of the data source in Add data source page in the data services wizard. Select the carbon data source name which you have created from the drop down list.
Figure 19: Creating the data source for Carbon Data Source
For the JNDI data source, first define a 'JNDI' typed carbon data source. Enter values to be used to connect to the database.
Figure 20: Creating the carbon data source for JNDI
When creating the data service select the data source type as 'JNDI' and enter the values to be used to connect to the previously created JNDI enabled data source.
Figure 21: Creating the data source for JNDI