Data Connection Settings - Performance Settings

Option

Description

Save to Library

[Only available for embedded data connections.]

Allows you to publish an embedded data connection to the library, so that it may be reused in other analyses or by other people. The state of the data connection in the current analysis will become Shared in library.

Embed in Analysis

[Only available for connections shared in library.]

In order to make any changes to the data connection settings within the context of an analysis, the connection must first be embedded in the analysis. Click on this button to embed the connection. (The shared instance of the data connection will still remain in the library.)

Once a connection has become embedded it can be edited and then re-saved to the library using either the same name or a different one.

Replace

Allows you to replace the current data connection with another one from the library.

If your company switches to another database system, it is possible to replace a data connection with a connection of a different type, as long as the view name and column names match.

Connection state

Shows the current state of the data connection. Either it is Embedded in analysis which means it is available for editing or it is Shared in library.

Enable cascading filters for any in-database data tables from this connection

[Only applicable if one or more data tables in the connection are configured for in-database loading.]

Select this check box to enable cascading filters for any in-database data tables in the selected connection, making the filters work more similar to the way filters work in imported data tables.

When cascading filters are enabled, the values displayed in filters are dependent on any other filter selections you have made. Only relevant values are available, and any values that have already been filtered out by filter selections in other filters are not displayed.

Caution: Enabling the cascading behavior for filters for in-database data tables results in an additional query load on the external data source. It is the user's responsibility to ensure that the external data source can handle the extra query load.

Manually add columns for table visualizations

[This option only affects in-database data tables from the selected connection.]

Determines whether to include and show all columns, when you create a new table visualization of an in-database data table in the connection.

By default, this option is cleared. When you create a new table visualization, all columns in the data table are selected and shown in the visualization.

When you select this option, new table visualizations are empty. You must manually select what columns to show in the visualization. To select columns, open the Data in analysis flyout and drag-and-drop the columns to the visualization. You can also select columns in the Visualization properties dialog.

Note: This option also affects the Details-on-Demand. To select columns manually, right-click the Details-on-Demand and select Properties. In the Properties dialog, go to the Columns tab.

Enable caching of data retrieved from this connection

No, always get fresh data from the external source

Use this option if you do not want to cache data from the data connection. Note that it can put a very high load on the database server to always get fresh data if many users are working with data from the same server simultaneously.

Yes, but let the cached data expire after

Use this option to cache data from the data connection, but to refresh if the cached data is older than the specified time limit.

Yes, but let the cached data expire every [day or day of the week] at [time]
 

Use this option to cache data from the data connection, but to refresh once every day or on a specified day every week, at the specified time.

Share cached data between all concurrent users of the Spotfire web client

[This option is only available if the preference AllowSharingOfCachedDataBetweenUsers is set to True for your Spotfire user group. If the preference is set to False, the check box is not available, and sharing of cached data is disabled.]

Select this option if you want to enable sharing of cached data for the data connection between users on Spotfire web clients.

Note: If the external data source has been set up so that the data available for each user depends on who you are, then you should not allow sharing of cached data.