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.

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. 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

Doc: Spotfire.Dxp.Worker.Host.exe.config file

• https://docs.tibco.com/pub/spotfire_server/7.11.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-603D7F88-AFE4-487D-9513-BBBD64F10300.html

Doc: Manually editing the service configuration files

• https://docs.tibco.com/pub/spotfire_server/7.11.1/doc/html/TIB_sfire_server_tsas_admin_help/GUID-958A3AB5-7243-4837-9AEA-78AA274A6F7E.html