For analyses in scheduled updates, it is a good idea to keep the cache as long as the update interval.

00:00:00 = infinity, 1.00:00:00 = 24 hours, 7.00:00:00 = 1 week, 01:00:00 = 1 hour, and so on.

A list of credentials profiles for connectors.

Add credentials for data sources as credentials profiles that you can use in data connections, if the connector authentication mode is set to WebConfig. You can add multiple profiles with different credentials.

<entry profile="MyFirstCredentialsProfile">
 <allowed-usages>
   <entry server-regex="example\.com" />
 </allowed-usages>
  <username>username</username>
 <password>password</password>
</entry>
<entry profile="MySecondCredentialsProfile">
 <allowed-usages>
   <entry server-regex="example\.com" />
 </allowed-usages>
  <username>username</username>
 <password>password</password>
</entry>

To learn more, see Credentials profiles for connectors.

The path to a directory on the computer that runs the service, where you can store files containing credentials profiles for connectors.

The path can be fixed or relative. Relative paths are relative to the location of the Spotfire.Dxp.Worker.Host.exe.config file on the service.

Each file in the directory represents one credentials profile. The filename is the profile name, and the file should have no file extension.

Example

Filename: credentials_profile_name

<entry>
 <allowed-usages>
   <entry server-regex="example\.com" />
 </allowed-usages>
  <username>username</username>
 <password>password</password>
</entry>

To learn more, see Credentials profiles for connectors.

Set to -1 to disable the Exhausted limit.

Note that this setting is applicable to both Web Player services and Automation Services.

Note that this setting is applicable to both Web Player services and Automation Services.

Set to -1 to disable the strained limit.

Note that this setting is applicable to both Web Player services and Automation Services.

Note that this setting is applicable to both Web Player services and Automation Services.

Note that this setting is applicable to both Web Player services and Automation Services.

These settings should not be edited unless instructed by Spotfire Support.

These settings should not be edited unless instructed by Spotfire Support.

These settings should not be edited unless instructed by Spotfire Support.

For information about the possible values for this setting, refer to the .NET enum SecurityProtocolType.

If you leave the value for this setting blank, the allowed TLS versions will be 'SystemDefault'. If you remove the setting from the configuration file, the allowed TLS versions will be the default value; 'Tls, Tls11, Tls12'.

Set to -1 to disable the exhausted limit.

Set to -1 to disable the strained limit.

Provide the full path to directories or files on a local disk that you want to access in the web clients.

Specify each file or directory in a separate <string> tag.

Provide the full path to directories or files that should be loaded in-process, instead of out-of-process, when accessed in the web clients.

Specify each file or directory in a separate <string> tag.

To be accessed in the web clients, the files or directories must also be included in the AllowedFilePaths setting.

Determines how often to refresh data in streaming data connections, when the CPU load exceeds specified limits.

Add multiple rules for variable levels of throttling.

Enter throttling rules in the following format:

<ArrayOfString>
   <string>CPU_LOAD, REFRESH_INTERVAL</string>   
   <string>CPU_LOAD, REFRESH_INTERVAL</string>
</ArrayOfString>

CPU_LOAD is an integer for CPU load percentage.

REFRESH_INTERVAL is an integer for refresh interval time in milliseconds.

For example:

 <string>50, 30000</string>

A value of '50, 30000' means that when the CPU load is over 50%, data is refreshed every 30 second.

By default, there are no throttling rules in the setting. Then streaming data connections refresh data continuously.

Settings for adding OAuth credentials for the Spotfire Web Player from a registration in TIBCO Cloud.

Used to enable the authentication method TIBCO Cloud™ Authentication for the TIBCO Spotfire Data Streams connector in the Web Player.

Example

<Spotfire.Dxp.Data.Access.Adapters.Settings>
   <setting name="OAuth2ClientRegistrations" 
             serializeAs="Xml">
      <value>
         <registrations>
            <registration issuer="My 
                    issuer region1">
                <client-information>My registration 
                    information region1</client-information>
            </registration>
            <registration issuer="My issuer region2">
                <client-information>My registration 
                    information region2</client-information>
            </registration>
         </registrations>
      </value>
   </setting>
</Spotfire.Dxp.Data.Access.Adapters.Settings>

For more information about how to obtain these settings, see Client registration command register-as-tibco-cloud-client.

• WebConfig – Select this to require all users to connect with the credentials specified in the Spotfire.Dxp.Web.Properties.Settings/DataAdapterCredentials section.
• Kerberos – Select this if your system is configured to authenticate users with Kerberos.
• Prompt – Select this to prompt the users for a username and password for the external data source.
• ServiceAccount – Select this to make all users connect to the external data source using the computer account or dedicated user account that is used to run the node manager.

Settings for the Microsoft SharePoint Online connector. The settings determine what registered app in Microsoft Azure that Spotfire uses to access SharePoint Online data.

Use these settings to be able to access data with the Microsoft SharePoint Online connector in the web client.

TenantId

Settings for adding OAuth credentials for Spotfire from a Google Cloud Platform project.

Used to enable Google BigQuery and Google Analytics connectors in the web clients.

Settings for adding OAuth credentials for Spotfire from a Salesforce connected app.

Used to enable the authentication method Log in with Salesforce and federated authentication for the Salesforce connector in the web clients.

Determines whether you can use Kerberos authentication with constrained delegation when you access data from connections to SAP BW.

Determines if data connections to SAP BW are run in-process.

Settings profiles for data connections to Amazon Redshift.

With a settings profile you can store settings from the Settings for authentication method table (see Details on Amazon Redshift Connection in the Spotfire Analyst User's Guide). Store settings and their values without having to store the settings in the analysis file. The settings are used automatically when you open the connection in a web client or Automation Services.

A settings profile is similar to a credentials profile. The main difference is that a settings profile does not include the username and password. That means that you can store some settings, which you do not want to store directly in the analysis file, and still have the user enter the username and password when they open the connection.

<setting name="SettingProfiles" serializeAs="Xml">
  <value>
    <profiles>
      <entry profile="MySettingsProfile">
        <setting name="SecretAccessKey">MyAccessKey</setting>
        <setting name="ClientID">MyClientID</setting>
      </entry>
      <entry profile="AnotherSettingsProfile">
        <setting name="SecretAccessKey">MyAccessKey</setting>
        </entry>
      </profiles>
  </value>
</setting>

If you need to use proxy handling for communication from the Web Player service or Automation Services to Spotfire Server, you must add the following proxy setting inside the defaultProxy tag:

<proxy
proxyaddress="http://MyProxyServer:3128"
scriptLocation="MyScriptLocation"
/>

The proxy setting is a part of .NET. You can find more information about this configuration at the Microsoft Developer Network (MSDN).

These settings should not be edited unless instructed by Spotfire Support.

These settings should not be edited unless instructed by Spotfire Support.