We are creating a mirror of niku database so that user can report real-time data without affecting the application. Where Does Jaspersoft store the setting to point to Niku (and PPM-DWH as well). I think pointing to the Mirror server here should be enough. correct me if I am wrong
Nika_Hadzhikidi helped us setup jaspersoft hence mentioning her.
Unfortunately we do not support mirrored database so be careful with your setup and test it very thoroughly. I am aware of issues when running DWH job and others.
If you want to change the setting of PPM/DWH database - these in Jaspersoft are taken from the properties.xml file and database connections there. So for those to be updated you have to run the command:
admin update jasperParameters
This command will update the profile parameters in the Jaspersoft server. After that you could change the properties.xml and not run the command to keep the connections to previous data.
Hope this helps -Nika
Why did you say "After that you could change the properties.xml and not run the command to keep the connections to previous data." ?
Does this mean I have to change DB settings everytime Jaspersoft is restarted?