How to migrate the CABI 6.x Database to a different database cluster

Products

• CA Spectrum

Issue/Introduction

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.

Environment

Release: Any
Component:

Resolution

On the JasperSoft Server:

1. Navigate to $TOMCAT_INSTALL/webapps/jasperserver-pro/META-INF
2. Open the context.xml file in a text editor.
3. Edit / update these values to the new locations:

<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&amp;characterEncoding=UTF-8&amp;autoReconnect=true&amp;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&amp;characterEncoding=UTF-8&amp;autoReconnect=true&amp;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&amp;characterEncoding=UTF-8&amp;autoReconnect=true&amp;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.

4. Restart Tomcat on the Jaspersoft machine