Versions Compared

Key

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

Nested queries help you to use the result of one query as an input parameter of another, and the queries executed in a nested query works in a transactional manner. Follow the steps given below to add a nested query to a data service.

...

Let's create a data service using the Create Data Service wizard:

  1. Open a terminal, navigate to the <EI_HOME>/bin directory, and start Start the WSO2 ESB profile.

    Panel
    Linux/Mac./integrator.shWindowsintegrator.bat --run
    borderColor#542989
    bgColor#ffffff
    borderWidth1
    Localtabgroup
    Localtab
    activetrue
    titleOn MacOS/Linux/CentOS

    Open a terminal and execute the following command:

    Code Block
    wso2ei-6.3.0-integrator
    Localtab
    titleOn Windows
    Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.3.0 Integrator. This will open a terminal and start the ESB profile.
  2. Open the ESB profile's Management Console using https://localhost:9443/carbon, and log in using admin as the username and the password.
  3. Click Create under Data Service.
  4. Enter the following name for the data service

    Data Service NameEmployeesDataService
  5. Click Next to enter the datasource thedatasource connection details.

Connecting to the datasource

...