There may be a time or instance where the JasperSoft database installed with CA Business Intelligence 6.1+ may need to be moved to a different database cluster.
Example:
Upgrading from MS SQL 2012 to a new MS SQL 2014 machine. The databases from 2012 are moved to the 2014 machine.
JasperSoft would need to be told where the new database is located.
Release: Any
Component:
On the JasperSoft Server:
<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="jasper" password="jasper"
driverClassName="org.mariadb.jdbc.Driver"
accessToUnderlyingConnectionAllowed = "true"
testOnBorrow="true"
url="jdbc:mysql://localhost:3306/jaspersoft?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"
factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"
/>
<Resource name="jdbc/sugarcrm" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="jasper" password="jasper"
driverClassName="org.mariadb.jdbc.Driver"
accessToUnderlyingConnectionAllowed = "true"
testOnBorrow="true"
url="jdbc:mysql://localhost:3306/sugarcrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"
factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
<Resource name="jdbc/foodmart" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="jasper" password="jasper"
driverClassName="org.mariadb.jdbc.Driver"
accessToUnderlyingConnectionAllowed = "true"
testOnBorrow="true"
url="jdbc:mysql://localhost:3306/foodmart?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"
factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
If the usernames and passwords are different, those should also be updated in the above sections.
Ultimately the jdbc/jasperserver is all that matters. The sugarcrm and foodmart databases are templates/testing databases for JasperSoft and thus are not required to be moved over if you do not want them to.