Upgrading Spotfire
Follow these steps to upgrade your Spotfire environment to the new version of Spotfire. Note that, in most situations, you will do an upgrade to the latest version (for Innovation releases) or to the latest service pack version (the third version number, for LTS versions) instead of applying any separate hotfixes to the system.
About this task
Before you begin
- Before upgrading, create a working backup of your Spotfire database.
- Download the required software from the TIBCO eDelivery website. For details, see Downloading installation software.
- For an overview of important changes since the earliest in-support LTS version, see Upgrading between Spotfire LTS versions.
In Spotfire Server version 14.0, the previously included TIBCO-branded DataDirect JDBC drivers were removed. If you use any of those drivers for connectivity in your environment, you must switch to other JDBC drivers. Before you upgrade, read the following:
In Spotfire Server version 12.5, support for saving items as favorites in the library was introduced. Due to this change, the Spotfire database now needs to use triggers to store the favorites. If you are upgrading a Spotfire Server using Oracle as the Spotfire database, you must manually add another grant to the spotfire database user before upgrading to version 12.5 or later (from a version before 12.5). Read the following topic before you upgrade:
Upgrading to 12.5 and later: Granting the privilege to use triggers for Spotfire databases on Oracle
In Spotfire version 12.3, the included Microsoft JDBC Driver for SQL Server was upgraded to a version with important changes to the default settings for encryption. If you upgrade Spotfire from a version earlier than 12.3, and you use the Microsoft JDBC Driver for SQL Server in your environment (to connect to the Spotfire database, the action logging database, Information Services data sources, or the default join database), read the following topic before you upgrade Spotfire:
Upgrading to 12.3 and later: Fixing Microsoft SQL Server JDBC driver-related issues
Procedure
- Installation of Spotfire Server during upgrade
When you install Spotfire Server, the upgrade tool is installed as well. - Upgrading a cluster of Spotfire Servers
Spotfire Server clustering is enabled by default. - Run the Spotfire Server upgrade tool
The server upgrade tool updates the database. You can run the upgrade tool interactively, or silently by using the command-line interface. - Start Spotfire Server
After running the server upgrade tool, start the Spotfire Server. - Upgrading nodes and services
To upgrade the nodes, deploy new node manager and service or client package distributions to the server. - Upgrading service configurations
Service configuration changes require manual updates if you do not want to use their default values. - Upgrading to 12.3 and later: Fixing Microsoft SQL Server JDBC driver-related issues
In Spotfire Server version 12.3, the included Microsoft JDBC Driver for SQL Server was updated to a version in which the default values for some encryption settings were changed. Due to this change, you might have to make some changes if you use the driver in your environment, for example for the connection to the Spotfire database, Information Services data sources, the action logging database, or for a default join database. In this article, you can find information about the issues that might occur, and what changes you must make. - Upgrading to 12.5 and later: Granting the privilege to use triggers for Spotfire databases on Oracle
In Spotfire Server version 12.5, support for saving items as favorites in the library was introduced. Due to this change, the Spotfire database now needs to use triggers to store the favorites. Previously, the privilege to use triggers was not granted by the installation script for the Spotfire database. If you are upgrading a Spotfire Server using Oracle as the Spotfire database, you must manually add another grant to the spotfire database user before upgrading to version 12.5 or later (from a version before 12.5). - Migrating from TIBCO-branded DataDirect JDBC drivers
The TIBCO-branded versions of Progress DataDirect JDBC drivers, which came pre-installed with Spotfire Server until version 12.5, are removed. The following drivers are no longer included, or supported in Spotfire:
- Installation of Spotfire Server during upgrade
When you install Spotfire Server, the upgrade tool is installed as well. - Upgrading a cluster of Spotfire Servers
Spotfire Server clustering is enabled by default. - Run the Spotfire Server upgrade tool
The server upgrade tool updates the database. You can run the upgrade tool interactively, or silently by using the command-line interface. - Start Spotfire Server
After running the server upgrade tool, start the Spotfire Server. - Upgrading nodes and services
To upgrade the nodes, deploy new node manager and service or client package distributions to the server. - Upgrading service configurations
Service configuration changes require manual updates if you do not want to use their default values. - Upgrading to 12.3 and later: Fixing Microsoft SQL Server JDBC driver-related issues
In Spotfire Server version 12.3, the included Microsoft JDBC Driver for SQL Server was updated to a version in which the default values for some encryption settings were changed. Due to this change, you might have to make some changes if you use the driver in your environment, for example for the connection to the Spotfire database, Information Services data sources, the action logging database, or for a default join database. In this article, you can find information about the issues that might occur, and what changes you must make. - Upgrading to 12.5 and later: Granting the privilege to use triggers for Spotfire databases on Oracle
In Spotfire Server version 12.5, support for saving items as favorites in the library was introduced. Due to this change, the Spotfire database now needs to use triggers to store the favorites. Previously, the privilege to use triggers was not granted by the installation script for the Spotfire database. If you are upgrading a Spotfire Server using Oracle as the Spotfire database, you must manually add another grant to the spotfire database user before upgrading to version 12.5 or later (from a version before 12.5). - Migrating from TIBCO-branded DataDirect JDBC drivers
The TIBCO-branded versions of Progress DataDirect JDBC drivers, which came pre-installed with Spotfire Server until version 12.5, are removed. The following drivers are no longer included, or supported in Spotfire: