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:
...
- Download WSO2 DSS from here.
- Extract the zip ZIP file to a location in your computer. This location will be referred to as
<DSS_HOME>
from hereon. - Download the JDBC driver for MySQL from here and copy it to your
<DSS_HOME>/repository/components/lib
directory.
...
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
- On Windows:
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/
Copy this URL to your browser to open the Management Console.
Log in to the management console using the default administrator credentials: admin/admin.
...
- Click Add New Datasource. You can now specify the datasource details.
- In the Datasource ID field, enter 'MyDS'.
- In the Datasource Type field, select RDBMS from the list of values.
- You will now be prompted to enter details of your RDBMS:
- 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)
- Click Save to save the datasource.
- Click Next. This will take you to a new page for adding queries to your service.
...
- Go to Services -> List to open the Deployed Services page.
- 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/ - 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 - The result will be the same as with the TryIt tool:
This concludes the quick start guide for WSO2 DSS 3.5.0. You can find more advanced use cases in the User GuideTutorials.