How to Install and Configure Tibco Spotfire 10 – Step by Step

BySpotfire Geek

  MAY 18, 2019   Data Analyse, Spotfire, Spotfire 10, Spotfire X, TIBCO, visualize data

As you know the TIBCO Spotfire environment is installed and configured to enable users to analyze their data in
the Spotfire clients. Spotfire Server facilitates the services that make it possible for users to access, blend, and visualize their data, creating analyses that provide actionable insight.

Now let’s walkthrough on how to install and configure the Spotfire environment. Main components are Spotfire Database, Spotfire Server and Node.

The first step is to create the Spotfire Database. The Spotfire database stores the information that Spotfire Server needs to control the Spotfire environment, including users, groups, licenses, preferences, shared analyses, and system configuration data. Before start configuring the Spotfire server the Database should be up and running.

Step 1: Setting up the Spotfire database (ORACLE)

1. Extract the files from the TIB_sfire_server_version number_linux.tar file to a directory on your server. under the script directory, we have both mssql_install & oracle_install.
2. These script needs to run from the DB root folder and you might need the help from the database administrator. If you have access, you can run the script create_databases.sh after setting the below variables.* ROOTFOLDER – Where should the data be stored on the database server
   * CONNECTIDENTIFIER – A connection identifier to the container database.
   * ADMINNAME – a username and password for an administrator in this database
   * ADMINPASSWORD
   * SERVERDB_USER –  Username and password for the Spotfire instance
   * SERVERDB_PASSWORD
   * SERVER_DATA_TABLESPACE=SPOTFIRE_DATA
   * SERVER_TEMP_TABLESPACE=SPOTFIRE_TEMP
3. Once the script run is completed, verify the setting by accessing the Database.

Step 2: Installing the Spotfire Server files (RPM Linux)

1. Go to the directory where you extracted the TIB_sfire_server_version number_linux.tar.
2. Run sudo rpm -ivh tss-<version number>.x86_64.rpm

    

   Spotfire – RPM install
3. Now Run the configure command to set up the initial configurations.  The output will look like below. The script will ask for the port information and you can change the default ports if you want. If you changed the port number, make a note of it as it needed while we configure the Node manager.

    

   Initial-Config-Spotfire
4. You can run the configure-boot script as well if you have the root privilege. This script will enable the startup script in the system boot config file.

Step 3: Setting up the Spotfire Database and basic configurations.

1. Go to /opt/tibco/tss/10.0.0/tomcat/bin/ directory. *Note : – installation directory
2. Run the bootstrap command to se up the Database connection configuration.

   ./config.sh bootstrap 
               --database-url="jdbc:tibcosoftwareinc:oracle://[SERVER]:[PORT];ServiceName=[DATABASE NAME]" 
               --username="spotfire"

   The output of the command looks like the below screenshot. You need to set up the tool password and encryption passwords which will require for the additional configurations.

    

   Spotfire bootstrap Config
3.  Create a default configuration file by using the create-default-config command like below.

   bash-4.2$ ./config.sh create-default-config --force /opt/tibco/tss/10.0.0/tomcat/bin/configuration.xml
   Successfully exported the default server configuration to file /opt/tibco/tss/10.0.0/tomcat/bin/configuration.xml
   bash-4.2$

4. Now Import the configuration to the database by using the import-config command. Tool password is the one which we created with bootstrap command.

   bash-4.2$ ./config.sh import-config --tool-password="admin" --comment="Test config"
   Successfully imported the server configuration with hash: e1e462db0f6dd007a77fdca15a1be0b0f276540c
   The imported configuration has been set as active.
   bash-4.2$
   

5. Create the first user, i.e admin user. this user can be used to login to the Spotfire server.

   ./config.sh create-user --tool-password="admin" --username="sfadmin" --password="sfadmin"

6. Add this user to the admin group by using the promote-admin command.

   ./config.sh promote-admin --tool-password="admin" --username="sfadmin"

Final Step : Start Spotfire Server (LINUX)

1. Run sudo /etc/init.d/tss-<version number> start to start the Spotfire Server. You can find the logs under /opt/tibco/tss/10.0.0/tomcat/logs directory.
2. Check for any error in the Catalina.[DATE].log.

Now Go to the browser and enter the server name with a port to access the Web GUI for the Spotfire server. If all went fine and no errors in logs, you will get a screen like below.

Spotfire-Login page

Hope this helps you guys. Please let me know your doubts and feedback in the comment section below.