How to point JasperReports Server to another database

Document ID : KB000116575
Last Modified Date : 28/09/2018
Show Technical Document Details
In some circumstances administrators have to point JasperReports Server to another database e.g. disaster recovery, moving the database server or any other maintenance action.
How to point JasperReports Server to another database?
JasperReports Server 6.3.0
IMPORTANT: Make sure Apache Tomcat is stopped before any action.

Go to C:\Program Files\CA\SC\CA Business Intelligence\buildomatic

Edit (search for the js.dbName parameter):

Edit the js.dbName parameter for the database name you want to configure. Make sure the dbUsername and dbPassword are the same and there is no change for those parameters. If you need to change the password, you can enter the new password as plain text in the dbPassword parameter. If you are doing that, make sure the encrypt.done=true to encrypt=true.

User-added image

Run the command js-ant refresh-config in order to create a new context file:

User-added image

The result should be:

User-added image

Now you can restart JasperReports Server pointing to the new database.