In my struts based application, we have requirement where
point 1. User selects a name of an employee (click a link) where all his peers and managers name will be displayed in a table on a new page.
point 2. On that new page, we have another link "download details"
point 3. By clicking the link, user will be taken to another page which contains all peer and manager employee information.
point 4. On this page, users can download by clicking "download" link as we provide users to select what information of the employee to download like name, empID, department and so on.
Now, when users selects point 1. then we run a query which gets all the information about employee, peers and managers
when user clicks on link "download details" i.e. point 3. then we run another query by passing the employee, peers and managers information selected in the table.
when user clicks on link "download" point 4. then we run another query which get all the information about employee, peers and managers from the list.
The question is
During point 3. i.e. user clicking on link "download details", can we redirect the request to another server which uses same database?
For eg: The original URL will be https://testserver.com to https://dataserver.com to process the download i.e. point 4..