A prospect that has completed the software evaluation phase and purchases the product is required to then be moved from the evaluation version to a production installation. The evaluation version of the software comes bundled with a lightweight Apache Derby database (db) which is for evaluation purposes ONLY and is not suitable for a production environment. The Support Services team strongly recommends moving the repository to a more robust/stable database such as MS SQL Server, MySQL, PostgreSQL, or Oracle.
Limitations of Using Derby:
- Only meant for evaluation purposes.
- The database, lightweight, can become unstable once it becomes a certain size ( db >100 charts).
- There is no direct upgrade path and Support will not be able to assist in upgrading your Derby db.
Upgrade Path to a Production Install:
The upgrade path consists of moving the iDashboards repository database to one of the following databases: SQL Server 2005 and above, MySQL, PostgreSQL, or Oracle. This can be done one of two ways:
- Creating a database repository on any of the above-listed Database and merely pointing the current evaluation install to use it as a repository in place of the bundled Derby database.
- Note that performing this type of upgrade will make upgrading Java and Tomcat to a newer version more difficult. Thus Support recommends the next option.
- Download the latest version of the software (CDROM) from the Support Download Site.
- Assuming you have already installed or have available an existing installed database, create a new database named Dashboards in your database server
- Run the respective script available in the ...\iDashboards_CDROM\scripts\database\standard\create_repository folder to create the required repository database.
- Once the repository is ready, update the ivizgroup.properties file to point to the new repository database Dashboards in place of the Apache Derby, ivizgroup.properties should be located: C:\Program Files\Dashboards_SRV\ivizgroup\config
- If you have charts/Dashboards created under evaluation to be migrated to the production install, you will have to export out all the charts/dashboards/picklists/forms from the Derby database as an .zip file before updating the ivizgroup.properties file. Once the installation is pointing to the new repository database, the exported .zip file will then have to be imported from the Admin application to complete the migration.
- Doing a fresh production installation of iDashboards on the Client’s physical or virtual Server in parallel to the evaluation software.
- Manual Install with CDROM:
- Dashboard Admin Manual 3.4 Manual Installation
- Dashboard Admin Manual 3.4 Manual Installation
- iDashboards Production Installer:
- A windows .exe application that needs to be run directly on the server.
- Dashboard Admin Manual 3.2 System Requirements
- Dashboard Admin Manual 3.3 Windows Installation
- A windows .exe application that needs to be run directly on the server.
- Manual Install with CDROM:
For More Information:
- Dashboard Admin Manual 13.8 Importing and Exporting
- Import/Export: Charts, Dashboards, Picklists, Forms
If the above is unable to resolve the issue, then please contact Dashboard Support for further assistance.
Comments
0 comments
Please sign in to leave a comment.