[Download] | [Documentation Home] | [Release Note]
You can find grammar for Data Service configuration file in the following URL. Data Services Specification
Your feedback on WSO2 WSAS is most appreciated. Please send them to our mailing lists.
In the WSO2 WSAS management console, click on Services on the left hand panel. In the Add New Service panel, click on Define Data Service.
Step 1 :In the Configuration box, from the Data Source dropdown, select RDBMS. A popup window will open up.
Here, Enter Database connection details including driver class, JDBC URL, username and password. The JDBC driver should be available in the WSAS_HOME/lib directory. After entering details, you can click on Test Connection to see whether the connection is functional.
Click OK. Enter a name for the data service if you haven't done so. Click Next.
Step 2 :Click on New Query to create a new query for you data service. You will be presented with the Add New Query popup window.
Here, you can enter the query you want to execute on the database.
Step 3 :Click the Add New Output Mapping button to define mappings for the query output.
Click OK on the popup windows to go back to the Queries panel. Click Next.
Step 4 :In the next panel, click on Add New Operation to define operations for the data service.
In the popup window, the Query dropdown will list the queries you defined in the previous step. You can map them to operations here. Click Finish when done.
Your new data service will now be listed.
Click on your service in the services list to see the service management window.
The following shows what a sample resonse from the data service looks like.