This documentation is for WSO2 Data Services Server 3.5.0. View documentation for the latest release.
Generating Data Service using a given Database Structure - Data Services Server 3.5.0 - WSO2 Documentation
||
Skip to end of metadata
Go to start of metadata

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 sourceOnce the datasource is created, follow the steps below to generate a data service.

  1. In the Carbon Datasource field, select a datasource from the drop down list.
  2. 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.

  3. The table structure of the database is displayed. From there, select the preferred table/s and 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 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.
  5. The generated service/s appear on the screen. Click Finish to navigate to the Deployed Services window, from where you can Manage Data Services.
  • No labels