The WSO2 Application Server provides the "Generate" feature to create data services automatically using a given database structure. When generating the service, the Application Server considers the table structure according to the given table structure. "SELECT", "INSERT", "UPDATE", and "DELETE" operations get automatically created.
First, you need to add a Carbon Data Source to the Application Server. For information on adding a Carbon Data Source, refer to Data Sources in the Configuration section.
Follow the instructions below to generate data services using the Data Source created.
1. Log on to the Application Server Management Console.
2. Click the "Main" tab and select the "Generate" link under "Data Services."
3. The "Select Data Source" page appears. Select the Data Source created earlier and give the database name.
4. Once the database is selected, the table structure will be displayed according to the given database. Select the preferred tables for the data service generation in the "Customize Service Generation" page and click "Next." For example,
5. Once tables are selected, a service generation mode needs to be specified. There are two options to generate the data service.
- As a single service where all operations for each table are given in a single data service.
- 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.
6. Once service generation mode is selected, data services will get deployed. View the deployed services and click finish.
You will be navigated to the "Deployed services" page using which you can manage your service.