The WSO2 Application Data Services Server provides the "Generate" feature to create data services automatically using a given database structure. When generating the service, the Application Data Services 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 Data Services Server. For information on adding a Carbon Data Source, refer toAdding a Data SourcesSource in the Configuration section.
Follow the instructions below to generate data services using the Data Source created.
1. Log on to the Application Data Services 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 (refer to Adding a Data Source) 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 , let's create a single service for all tables.
6. Once the service generation mode is selected, data services will get deployed. View the deployed services and click finish.
7. You will be navigated to the "Deployed services" page using which page.
From this page, you can manage your service.