Page Comparison

The purpose of this guide is to get you started on creating and invoking a data service using WSO2 Data Services Server (WSO2 DSS) as quickly as possible. See the following topics for details:

...

WSO2 Data Services Server provides a convenient web service interface for data stored in various datasources. That is, data that is stored in various data sources datasources can be decoupled from the infrastructure where it is stored and exposed to external clients as a data service. Datasources such as relational databases, CSV files, Microsoft Excel files and google spread sheets can be easily service enabled using WSO2 DSS.

...

1. Open a terminal and navigate to the <DSS_HOME>/bin directory and execute the DSS startup script using one of the following commands:

   • On Windows: wso2server.bat
   • On Linux: sh wso2server.sh

2. When the product is started, the URL of the Management Console will be shown in the terminal as follows:

    

   INFO {org.wso2.carbon.ui.internal.CarbonUIServiceComponent} -  Mgt Console URL  : https://10.100.5.65:9443/carbon/

3. Copy this URL to your browser to open the Management Console.

4. Log in to the management console using the default administrator credentials: admin/admin.

...

1. Click Add New Datasource. You can now specify the datasource details. 
   1. In the Datasource ID field, enter 'MyDS'.
   2. In the Datasource Type field, select RDBMS from the list of values. 
2. You will now be prompted to enter details of your RDBMS:
   
3. Enter the following details of your MySQL database in the relevant fields as shown above:
   
   • Database Engine: MySql
   • Driver Class: com.mysql.jdbc.Driver
   • URL: jdbc:mysql://localhost:3306/employeedb
   • User Name: root
   • Password: (Leave this blank)
4. Click Save to save the datasource.
5. Click Next. This will take you to a new page for adding queries to your service. 

...

1. Go to Services -> List to open the Deployed Services page.
2. Click the data service (MyFirstDS) to open the service dashboard:
   
   See that the URL of the 'MyFirstDS' data service is listed under Endpoints: https://10.100.5.65:9443/services/MyFirstDS/
3. You can execute the getEmployees operation using the above URL. Simply copy this URL followed by the operation name as shown below.
   https://10.100.5.65:9443/services/MyFirstDS/getEmployees
4. The result will be the same as with the TryIt tool:
   

...