Generating Data Service using a given Database Structure

This option helps create data services automatically using a given database structure. When generating a data service, the server takes its table structure according to the structure specified in the datasource and automatically creates the SELECT, INSERT, UPDATE and DELETE operations.

Before you begin, you must first add a data source. Once the datasource is created, follow the steps below to generate a data service.

1. Log in to the management console and select Generate in the Data Service menu.
2. In the Carbon Datasource field, select a datasource from the drop down list.

3. In the Database Name field, give the name of the database that includes the data you need to expose, and click Next.
   

   Note that in most cases the database name should be the same name used when creating the datasource. If you want to find the database name for the datasource you selected in step 2 above, go to the Configure tab and click Datasources in the navigator. You can then get the details (including the database name) of a datasource by clicking View.
   
   However, some datasources such as Oracle and H2 may not require the exact database name.

4. The table structure of the database is displayed. From there, select the preferred table/s and click Next.  
5. If you selected multiple tables in the previous step, you must select a service generation mode from the two options as follows, and click Next.
   • Single Service: Creates a single data service for operations of all tables. 
   • Multiple Services: Creates a service per table, for operations relevant only to that table.
6. The generated service/s appear on the screen. Click Finish to navigate to the Deployed Services window, from where you can Manage Data Services.