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, and, if you are using external storage of the library content, backup your external system. Note that from version 12.0 and forward, library content is compressed by default. Items that are currently stored in the Spotfire library in an uncompressed format will be compressed in the background over time, unless you change the default settings for library compression.
- Download the required software from the Spotfire Download site. For details, see Downloading installation software.
- Review the System Requirements for both the Spotfire Server and the services you intend to use, and make sure your system fulfils the requirements.
- For an overview of important changes since the earliest in-support LTS version, see Upgrading between Spotfire LTS versions.
Note: Some versions of Spotfire introduce changes that might require
preparation before you upgrade. Before you upgrade from a version earlier than
the ones listed below, see the following help topics:
- Upgrading to 14.0.8 and 14.5.0: New license management
- Upgrading to 14.0 and later: Migrating from TIBCO-branded JDBC drivers
- Upgrading to 12.5 and later: Granting the privilege to use triggers for Spotfire databases on Oracle
- 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). - Upgrading to 14.0.8 and 14.5.0: New license management
In versions 14.0.8 and 14.5.0 of Spotfire, new functionality has been added to make it easier to manage licenses and license features. Because of underlying changes to how the licenses work, you must upgrade the Spotfire Server before you deploy the new Spotfire client package and update your installed clients and Web Player services. - 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). - Upgrading to 14.0.8 and 14.5.0: New license management
In versions 14.0.8 and 14.5.0 of Spotfire, new functionality has been added to make it easier to manage licenses and license features. Because of underlying changes to how the licenses work, you must upgrade the Spotfire Server before you deploy the new Spotfire client package and update your installed clients and Web Player services. - 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: