Migrate JDBC connections of Presto to MashZone NextGen
You can import the JDBC connections of Presto (version 3.9 and 9.9) in MashZone NextGen.
Procedure
This upgrade is relevant for MashZone legacy JDBC connections.
1. Copy all drivers located in the jdbcdrivers folder of your Presto installation into thejdbcdrivers folder of the MashZone NextGen installation and restart the MashZone NextGen Server .
2. Check if the MashZone tab exists in the Admin Console of Presto. If not, open the presto.config file located in <Presto installation>\apache-tomcat\webapps\mashzone\WEB-INF\classes\ and set the mashzone.administration.disabled=false flag and restart the Presto server.
3. Export the required connections in the Presto Admin Console (Admin Console -> MashZone -> Database Connections tab. You have to export each connection separately. See Presto online help for details.
The exported JDBC connections are stored as mzp files, starting with A_DATABASE…, in the importexport folder of your Presto installation.
4. Copy all database related mzp files in the importexport folder of your Presto installation to the dbconnections subfolder of the importexport folder in your MashZone NextGen installation.
5. Start the MashZone NextGen server if not already done. Then go to the runtool folder (located under Presto\mashzone\tools), open a dos command line and call:
migrationtool -user Administrator -password manage -folder dbconnections
All JDBC connections from the dbconnections folder will be imported into MashZone NextGen.
In the MashZone NextGen Admin Console the JDBC connections are separated in two parts, the driver part and the data source part. You can find all JDBC related items in the JDBC Configuration tab of the Admin Console.
If you need to upgrade a connection using a JDBC driver that consists of multiple JAR files, you will have to create a new driver JAR which bundles all the individual files into one single file. After that, you will have to copy the newly created JAR file to the MashZone NextGen installation.