Hi ALL,
Below is the scenario where i would require you guys help ---
AS IS scenario -
We have three different clients for which we have created three different tenants and gateway's have been installed on three different machines so that users of above specified three clients dont see the dashboard or reports across each other. i.e. client 1 would see the report in the workspace 1 and client 2 would see the report in the workspace 2 only.
Note - the three data bases requried for the above three clients are on different instnaces and their domain is also different, so the reason that three different tenants were created and three different gateways for the same.
To be process -
Now our organisation is planning to bring the reporting data base from three different instances to a single common instance i.e. Db1 would have (RPT1, RPT2, RPT3) , but still here the common clause would be that the users shouldnt see the data across clients i.e. client 1 would see the report in the workspace 1 and client 2 would see the report in the workspace 2 only.
Now with this database merger apporach that we are planning to take, is there any better way wherein I can re organise my gateways from 3 to 1. Wherein I would have one gateway connected to a single datasource as we are going to have all the reporting db's on single instance. With the expection that with new approachas well users should not see the data across clients i.e. client 1 would see the report in the workspace 1 and client 2 would see the report in the workspace 2 only.
Kindly request you to suggest a approach.
