Configuring TIBCO Spotfire Statistics Services (TSSS) URL and its credentials if authentication is enabled on TSSS to allow data function execution from the TIBCO Spotfire Web Player.

Configuring TIBCO Spotfire Statistics Services (TSSS) URL and its credentials if authentication is enabled on TSSS to allow data function execution from the TIBCO Spotfire Web Player.

book

Article ID: KB0080925

calendar_today

Updated On:

Products Versions
Spotfire Statistics Services 7.5 and higher

Description

When TIBCO Spotfire Statistics Services (TSSS) has authentication enabled, the TSSS URL and corresponding username and password must be configured in the Web Player service configuration file Spotfire.Dxp.Worker.Host.exe.config to allow the execution of data functions and statistical tools from the Web Player service. If the TSSS server is configured for anonymous authentication, which is the default configuration, then the additional steps in this article are not required.

Issue/Introduction

This article describes steps to be performed at Spotfire end in order to execute Data Functions from web player if authentication is enabled on TSSS.

Resolution

Follow the steps below.

1). Open a command-line interface and export the service configuration from Spotfire Server by using the export-service-config command. Specify the Web Player capability and the deployment area.  Example:
config export-service-config --capability=WEB_PLAYER --deployment-area=Production
 
The following configuration files are exported. By default, these files are located in the <TSS install dir>\tomcat\bin\config\root directory.
  •     Spotfire.Dxp.Worker.Core.config
  •     Spotfire.Dxp.Worker.Host.exe.config
  •     Spotfire.Dxp.Worker.Web.config
    2). Open the Spotfire.Dxp.Worker.Host.exe.config file in a plain text editor.
    From the section configuration/applicationSettings/Spotfire.Dxp.Web.Properties.Settings, following section will be visible.
    <Spotfire.Dxp.Web.Properties.Settings>
          <!--Authentication settings for TIBCO Spotfire Statistics Services -->
          <!--  A list of URLs -->
          <setting name="TibcoSpotfireStatisticsServicesURLs" serializeAs="Xml">
            <value>
              <ArrayOfString>
                <string/>
              </ArrayOfString>
            </value>
          </setting>
     
          <!--A list of usernames for each of the URLs above-->
          <setting name="TibcoSpotfireStatisticsServicesUsernames" serializeAs="Xml">
            <value>
              <ArrayOfString>
                <string/>
              </ArrayOfString>
            </value>
          </setting>
     
          <!--A list of passwords for each of the usernames and URLs above-->
          <setting name="TibcoSpotfireStatisticsServicesPasswords" serializeAs="Xml">
            <value>
              <ArrayOfString>
                <string/>
              </ArrayOfString>
            </value>
          </setting>

    3). Change the above sections with TSSS URL, username, and password in the sections TibcoSpotfireStatisticsServicesURLs, TibcoSpotfireStatisticsServicesUsernames, and TibcoSpotfireStatisticsServicesPasswords respectively.

    If you have multiple instances of TSSS with authentication enabled on each one, all the entries should be in proper sequence. Here is an example:
    <!--Authentication settings for TIBCO Spotfire Statistics Services -->
          <!--  A list of URLs -->
          <setting name="TibcoSpotfireStatisticsServicesURLs" serializeAs="Xml">
            <value>
              <ArrayOfString>
               <string><TSSS_URL1></string>
               <string><TSSS_URL2></string>
                </ArrayOfString>
            </value>
          </setting>
    
          <!--A list of usernames for each of the URLs above-->
          <setting name="TibcoSpotfireStatisticsServicesUsernames" serializeAs="Xml">
            <value>
              <ArrayOfString>
                <string><Username_for_TSSS_URL1></string>
                <string><Username_for_TSSS_URL2></string>
              </ArrayOfString>
            </value>
          </setting>
    
          <!--A list of passwords for each of the usernames and URLs above-->
          <setting name="TibcoSpotfireStatisticsServicesPasswords" serializeAs="Xml">
            <value>
              <ArrayOfString>
                <string><Password_for_TSSS_URL1></string>
                <string><Password_for_TSSS_URL2></string>
              </ArrayOfString>
            </value>
          </setting>
    4). Save the changes to file.

    5). In the command-line interface, import the configuration file back into the Spotfire Server and name the configuration by using the import-service-config command.  Example: 
    config import-service-config --config-name=TSSSAuth


    6). In the command-line interface, assign the created Spotfire Web Player configuration to the Spotfire Server to make it possible to use for the service: Example:

    config set-service-config --service-id=value –config-name=TSSSAuth

    Additional Information

    Doc: Spotfire.Dxp.Worker.Host.exe.config file Doc: Manually editing the service configuration files