This documentation is for WSO2 Data Services Server 3.2.2. View documentation for the latest release.
Page Comparison - Generating Using a Given Database Structure (v.5 vs v.6) - Data Services Server 3.2.2 - WSO2 Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

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

  1. Select the data source created before and the datasource created before from the drop down list.
  2. 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, go to the Configure tab and click

    Next.

    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.

  3. The table structure of the database is displayed. From there, select the preferred table/s and click click Next.  
  4. 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.
  5. 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.