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>/bin
directory, and start Start the WSO2 ESB profile.Panel Linux/Mac ./integrator.sh
Windows 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-integrator
Localtab 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 usingadmin
as 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
...