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:
Open a terminal, navigate to the
<EI_HOME>/bindirectory, and start Start the WSO2 ESB profile.Panel Linux/Mac ./integrator.shWindows integrator.bat --runborderColor #542989 bgColor #ffffff borderWidth 1 Localtabgroup Localtab active true title On MacOS/Linux/CentOS Open a terminal and execute the following command:
Code Block wso2ei-6.3.0-integratorLocaltab title On Windows Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.3.0 Integrator. This will open a terminal and start the ESB profile. - Open the ESB profile's Management Console using
https://localhost:9443/carbon, and log in usingadminas the username and the password. - Click Create under Data Service.
Enter the following name for the data service
Data Service Name EmployeesDataService - Click Next to enter the datasource thedatasource connection details.
Connecting to the datasource
...