Page Comparison

This option helps 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 data source and automatically creates the the SELECT, INSERT, UPDATE and  and DELETE operations operations.

FirstBefore you begin, you must first add a data source. For information, see Managing Datasources.  Once the datasource is created, follow the steps below to generate a data service using it.

1. Log in to the management console and select select Generate under  under Data Service menu menu.
2. Select the data source created before and datasource created before from the drop down list.

3. Give the name of the database, which

   includes

    includes the data you need to expose and click Next. 
   

   Note
   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,

   and click Next

   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 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 click Next.
   • Single Service: Creates a single data services 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 Click Finish to  to navigate to the the Deployed Services window window, from where you can can Manage Data Services.