Set Up Repository When Using Any Other Database
If you used MySQL, Oracle, PostGres, or SQL Server for your old repository, follow the instructions below.
1. Go to the old_Software AG_directory\Presto\apache-tomee-jaxrs\lib directory and copy the JDBC driver jar file for your database to the new_Software AG_directory\MashZoneNG\apache-tomee-jaxrs\lib directory.
Database | JDBC Driver Jar File |
MySQL | mysql-connector-java-5.1.31.jar |
Oracle | ojdbc6.jar |
PostGres | postgresql-9.2.1004.jdbc4.jar |
SQL Server | jtds-1.3.1.jar |
2. If you used MySQL, Oracle, or SQL Server for the old product, do the following:
a. Go to the new_Software AG_directory\MashZoneNG\apache-tomee-jaxrs\webapps\presto\WEB-INF\lib directory and delete the jackbe-presto-rds-postgre-derby-9.10.jar file.
b. Go to the new_Software AG_directory\MashZoneNG\prestorepository directory and copy the jackbe-presto-rds-oracle-mysql-mssql-9.10.jar file to the new_Software AG_directory\MashZoneNG\apache-tomee-jaxrs\webapps\presto\WEB-INF\lib directory.
3. 3.7, 3.8, 3.9, 9.9, or 9.10 upgrade: Go to the old_Software AG_directory\Presto\apache-tomee-jaxrs\conf directory and copy the tomee.xml file to the new_Software AG_directory\MashZoneNG\apache-tomee-jaxrs\conf directory. Then go to the old_Software AG_directory\Presto\apache-tomee-jaxrs\webapps\presto\WEB-INF\classes directory and copy the rdsJdbc.properties file to the new_Software AG_directory\MashZoneNG\apache-tomee-jaxrs\webapps\presto\WEB-INF\classes directory.
4. 3.6 upgrade: Configure the new Business Analytics to use the existing repository. For instructions, see MashZone NextGen Business Analytics Installation and Administration Guide, and then see the section on getting started with Business Analytics, and then see the section on moving the Business Analytics repositories to a robust database solution. Skip steps 1 through 4, and start with step 5.