In this use case we will show an example of how to dynamically pass source parameters to a Where condition and get the results from the query execution.
Here are the following steps in the orchestration:
- Get parameters from Web Service source client
- Pass these source parameters into the database activity and execute the query
- Take the query resultset and pass it back to the Web Service client as a response
In this example the data integration orchestration would be published as a RESTful API. Please refer to the attached video and the walkthrough file for details. Use the migration utility of Adeptia Suite version 6.1 or higher to import the attached deployable solution into your local Adeptia instance.