Spotfire 14.2 introduces enhanced data wrangling capability with data tables relations management from the data canvas, alongside new data access capabilities, including OAuth-enabled SQL Server connections, and additional properties available in the new visualization authoring experience (in preview). Additionally, web-based library permissions management simplifies administrative tasks, and administrators benefit from expanded API functionalities, further enhancing Spotfire's flexibility and control. 

Back to the What's New in Spotfire landing page.

Data Access

Connect to SQL Server with OAuth and Custom Properties

Configure connections to Azure SQL Database and Azure Synapse Analytics with SSO and safe personalized login with OpenID Connect and OAuth 2.0.

Additionally, the Connector for SQL Server now supports custom connection properties for data source or driver specific settings. This allows for customizations, such as tweaking the connection performance, changing the behavior of a connection, or accessing certain data.

View Column Metadata for TIBCO Data Virtualization Tables

When connected to a TIBCO Data Virtualization instance with the data catalog feature, the "view details" panel now shows the list of available columns for a table (in addition to table name and description/annotation), making it easier to identify the right data set without having to load the data.

Data Wrangling

Manage Data Tables Relations from Data Canvas

In the Spotfire data canvas, the new Relations overview provides a visual graph that vividly illustrates how data tables relate to each other. This new interface simplifies the configuration of data table relations and extends this capability to web authors.

The new data tables relations experience also enables defining a relation using multiple pairs of columns which is useful when analyzing data across several data tables that do not have a single column to represent the relation and need multiple criteria for a match. Additionally, error identification is improved to make troubleshooting much easier.

In Spotfire, data table relations shine when working with more than one data table in the analysis. Relations make it possible to carry over marking and filtering between data tables, and foster the creation of details visualizations, empowering users to drill down from one visualization to uncover specifics about selected data in another visualization. See this video demonstration of using the new data relations view:

Visual Analytics

In Preview - The New Visualization Properties Experience

This release introduces enhancements to the new visualization authoring experience (in preview), featuring new properties and appearance cards, and many improvements under the hood.

The new visualization properties panel makes visualization authoring easier, more efficient, and unifies the experience in the web client and the installed client.

• Easy to use: All properties have one consistent design across all visualization types. The panel only shows properties that are applied to the selected visualizations. Simple add more properties to enrich visualizations.
• Searchable: Just use search to find properties and settings to edit or add.
• Efficient: Configure multiple selected visualizations simultaneously. Reuse configurations across visualizations through drag and drop.
• Scalable: The new panel is designed for scale and will allow Spotfire to be extended with more visualization capabilities in the future.

Analysts can try out this new experience in the web client and the installed client. Not all visualization properties are available in the panel, and not all functionality from the old properties dialog have been implemented yet. The old properties dialog remains available and can be used side-by-side with the new experience.

How to enable the new experience

As an administrator, head to Tools > Administration Manager > Preferences in the latest version of the Spotfire Analyst client and set the EnableVisualizationPropertiesPanel preference to True. Then reload the web client or restart the installed client. The old properties dialog remains available and can be used side-by-side with the new experience.

Administration

Manage Library Folder Permissions from the Web UI

It is now possible to manage library folder permissions from the new Permissions tab in the details panel of the Library view, within the web administration pages. The new interface allows you to do the same permissions operations that previously were only were available from the Library Administration tool in the installed client.

Note: You must have a Full control level of access to a folder to edit the folder permissions.

Note: The new configuration property library.show-access-permissions can be used from the command line to disable or enable the library permissions tab.

Information Model API

The Information Model REST API supports the following operations:

• Update the information model element
• Redirects the information model element

Note: For easy documentation reference, you can browse the API with the Swagger UI: https://<my-spotfire-server>/spotfire/api/swagger-ui.html?urls.primaryName=is

Note: For easy development of stubs in any language, You can download the OAS (Open API Specification) from: https://<my-spotfire-server>/spotfire/api/v2/api-docs?group=is

License Management API

The License Management REST API supports the following operations:

• list licenses
• list license functions
• get licenses for group
• get licenses for user
• get license functions for group
• get license functions for user
• remove license for group
• delete license for group

Note: For easy documentation reference, you can browse the API with the Swagger UI: https://<my-spotfire-server>/spotfire/api/swagger-ui.html?urls.primaryName=license

Note: For easy development of stubs in any language, You can download the OAS (Open API Specification) from: https://<my-spotfire-server>/spotfire/api/v2/api-docs?group=license

SCIM API Supports Filtering of Attributes

RFC 7643 defines a SCIM sub-attribute of the groups attribute called type with the defined values direct and indirect. Clients can now request a partial resource representation on any SCIM operation that returns a resource within the response.

You can specify either of the mutually exclusive URL query parameters attributes or excludedAttributes. This is very useful for synchronization of certain users or groups based on custom attributes.

PostgreSQL 16 Supported as Spotfire Database

PostgreSQL 16 is now supported as the Spotfire database.

Note: PostgreSQL 16 was released on September 14, 2023. It will reach EOL on November 9, 2028 (5-year lifecycle). The PostgreSQL Global Development Group releases a new major version containing new features about once a year.

Oracle Database 23c Supported as Spotfire Database

Oracle 23c is now supported as the Spotfire Database.

Note: "Oracle 23c Free - Developer Release" was released on April 2023.  "Oracle Database 23c on OCI Base Database Service" was released on September 2023 and declared LTS. Oracle 23c is the latest Oracle Database with Long Term Support. It will become available on other platforms (cloud and on-premises) starting 1H CY2024.

Google Cloud Storage as Spotfire Library External File Storage

When deploying on the cloud, you may want to use object storage to as the storage for your Spotfire library, which is most cost effective and typically similar performance as in using a database as a cloud service.

Google Cloud Storage is now supported as the Spotfire Library external file storage.

The new Spotfire configuration tool command config-library-external-google-cloud-storage enables configuration of a Google Cloud Storage as the Spotfire external storage.