[Download] | [Documentation Home] | [Release Note]
Introduction
WSO2 Data Services Server provides the feature to create data services automatically using a given database structure. When generating the service, DS Generator will consider the table structure. According to the given table structure "SELECT", "INSERT", "UPDATE", and "DELETE" operations will get automatically created.
Step 1 - Create a Carbon Data Source
Before generating the data services Carbon data source should be created according to the database properties.
Figure 1: Create Carbon Data Source
Step 2 - Select Data Source
To start the ds generation click on 'Generate' link on your left hand menu.
Figure 2: Generate Data Service
In the first screen that appears select the Carbon Data Source and the Database Name as shown below.
Figure 2: Select Data Source
Step 3 - Select Database Schema
After Data Source is selected, DB Schema needs to be selected to identify the needed tables.
Figure 3: Select DB Schema
Step 4 - Select Tables
Once the schema is selected, the table structure will display according to the given schema. Select the preferred tables for the data service generation.
Figure 4: Select Table Set
Step 5 - Select the Service Generation Mode
Once tables are defined, service generation mode needs to be specified. There are two options to generate the data service. 1. as a single service - where all operations for each table are given in a single data service. 2. Multiple services for each table - where for a given table only operations related to that table will be specified. Following example creates a single service for all tables as shown below.
Figure 6: Select DS Generation Mode
Once service generation mode is selcted, data services will get deployed, click next to view deployed services and click finish.
Figure 7: Created Services
Step 8: Service deployed
Now we have created a data service. You can go the deployed services list which is under Manage/Service/List. Created service will be list as follows. If multiple service mode is selected, multiple services will get generated according to the number of tables selected.
Figure 8: Deployed data services
Step 9 - Try your service - Single Service Mode
Click on "Try It" link to invoke the service. As seen in Figure 6, operations (Select, Update, Insert and Delete) for both tables are embedded in the same data service.
Figure 6: Try-it - Single Service Mode
Step 9 - Try your service - Multiple Service Mode
If Multiple service Mode is selected, different data services will get generated per each table.
Figure 6: Try-it - Multiple Service Mode