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:

...

1. Download and install MySQL using Homebrew. 

2. Open a terminal and execute the following command to start your MySQL database:

   Code Block
   mysql.server start

3. Access the MySQL prompt by giving the user name and password. By default the user name is 'root' and the password is blank.

   Code Block
   mysql -u root -p

4. Create the sample database named employeedb using the following command: 

   Code Block
   create database employeedb;

5. Open the employeedb database you just created using the following command:

   Code Block
   use employeedb;

6.  Create one table in the database using the following command:

   Code Block
   create table employee(id VARCHAR(10) NOT NULL PRIMARY KEY, name VARCHAR(100), address VARCHAR(100));

   This command will create the following table in the database:
   

7. Insert employee data into the employee table as follows:

   1. The first employee:

      Code Block
      insert into employee values('01','john','Boston');

   2. The second employee:

      Code Block
      insert into employee values('02','Micheal','Dallas');

   3. The third employee:

      Code Block
      insert into employee values('03','richard','Chicago');

8. You can see the data that you have added to the employee table of the employeedb database by executing the following command:

   Code Block
   SELECT * FROM employee

   The result will be as follow:
   

...

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:
   

...