11 / 2018

Search for Building Visualizations

You can build visualizations from the new search bar. Type, for example, "Sales per region and year" and the Spotfire systems respond with recommendations for visualizations.

Search for Marking Values in your Data

Search and mark values in your data from the new search bar. For example, if you are looking for the sales of a specific sales rep or sales in a specific country, just type in the name and the Spotfire system will mark it.

Search to Drive your Analysis

The search bar also lets you search and run virtually any Spotfire functionality. For example, add a calculated column or similar, even for data stored in the library.

AI-powered Recommendations

Visualization recommendations powered by AI and machine learning help you find relationships in the data. If you select a column in Data in Analysis, the Spotfire system now shows recommended visualizations, including other columns that seem likely to have a relationship to the selected column.

New User Interface

A completely reimagined user experience with a beautiful interface makes it easy to find and work with all functions and tools.

One Place for Connecting to Data

A completely reimagined user experience with a beautiful interface makes it easy to find and work with all functions and tools. "Files and Data" lets the user browse and search for all kinds of data sources, files, data functions, data connections, custom data sources, etc., both locally and in the library.

One Place for Data in Analysis

"Data in Analysis" lets the user see details about the selected column, such as the distribution of values, max, min, unique values, etc., and access various functions for columns.

One Place for Visualizations

"Visualizations" lets the user choose a visualization type and drag-and-drop it on the visualization area.

One Place for Viewing Data Workflow

"Data Canvas" is where users can review and author the data pipeline for each data table in the Source View. Access it using the icon at the bottom of the Authoring bar on the left.

Visual Analytics for Real-time Data

By connecting to the new Spotfire Data Streams software, or TIBCO Live Datamart, Spotfire Analyst can now visualize data from dozens of streaming sources such as Kafka, MQTT, Salesforce Streaming, WITS, OsiPi, many capital market exchanges, and of course, other TIBCO technologies such as TIBCO Messaging.

Limit Streaming Data to a Time Range

For streaming data, you can limit the time range shown in the visualization to the last N minutes or any other time range you want to see.

New Drag-and-Drop Visuals for Visualizations

When creating a visualization from the visualizations flyout, chose one from "Search or Recommended Visualizations" and drag it where you want it on the canvas.

Configurable Preferred Aggregation Method in Spotfire Visualizations

Set a preferred aggregation method for individual columns, but also a globally preferred aggregation for numerical columns.

Add User Name and/or TimeStamp in Prepared PDF Reports Header or Footer

The prepared PDF reports can now be configured to display the current user and/or the current time in the header or footer.

Change Coordinate Reference System in Spotfire Business Author

Spotfire Business Author users can now configure the coordinate reference system (CRS) and projection of a map chart and its associated layers.

Geocoding Coverage Updates

Over 160,000 new cities are now available worldwide. New administrative areas are supported for the US that include area code, borough, CBSA, congressional district, and school district.

The Summary View for Data Wrangling

When adding and replacing data, the Summary View will not only show you how your data will be added, it will also recommend how data should be added.

Define Add Columns and Add Rows without Waiting for Data to Load

Since the Summary View is displayed before data is loaded, you are now able to define Add Columns and Add Rows operations without loading one of the data tables into memory first.

Recommended Add Rows while Adding Data

The recommendation engine is built right into the Summary View and will run across all listed tables. This allows the recommendation engine to work across tables not yet loaded into the analysis file.

Add Columns with Recommended Column Matches while Adding Data

Just like with Add Rows recommendations, you can configure Add columns in one step, before loading data.

Recommendation Engine Support for Links Between Tables

The visualization recommendation engine is now an integrated part of the data panel. There is also a new type of recommendation available, recommended table links.

Categorization of In-database Columns in the Data in Analysis

As with in-memory data tables, in-database data tables are now easier to navigate because their columns are automatically categorized and grouped by numbers, categories, currency, time, location, identifiers, and binary.

Apache Drill Support

A native connector for Apache Drill is now included, available in the "Connect to" list in the Windows Spotfire Analyst client. The connector works in conjunction with the MapR Drill ODBC driver.

Dremio Support

A native connector for Dremio is now included, available in the "Connect to" list in the Windows Spotfire Analyst client. The connector works in conjunction with the Dremio ODBC driver.

New Connector List

A new way to list connectors makes it easier to find the data source you want to connect to. Each connector also has updated help text that helps you instantly find details on working with the connector.

Data Tools Consolidated into One Menu

All data-related menu items are now moved to a Data menu.

Scheduling Automation Services Jobs

In the new Automation Services area of the administration interface, you can schedule Automation Services jobs and monitor the activity of all Automation Services jobs that are run in your Spotfire environment.

The TERR Service

The TERR service is now available as part of the Spotfire environment, along with the existing Web Player service and Automation Services.

Improved Scheduled Update Job Handling

Scheduled update jobs that cannot be immediately run are now all queued on the Spotfire Server for distribution to Spotfire Web Player instances as they become available. This results in a more robust routing of jobs than before when each service maintained its own job queue after its maximum number of concurrent updates was reached.

Node Manager Performance Monitoring

At the DEBUG logging level, the node manager now produces a performance.monitoring.log file that is similar to the server log file with the same name.

New Commands for Server and Administration

The create-scheduled-jobs command creates scheduled Automation Services jobs from a local JSON file that is created by the administrator. That remove-config-property command modifies the configuration.xml file to remove the value(s) of a specific configuration property.

Preferred Aggregation Method

An API can get or set the preferred aggregation method to be used by plot heuristics when creating aggregated expressions from a data column.

Default Layers for Map Chart

An API can load the default layer, for example, base map layer, TMS layer, or feature layer, when configuring a map chart.

08 / 2018

Insert Rows, Columns, and Data Transformations Before Other Nodes

Now rows, columns, and data transformations can be added anywhere within an existing data table structure.

New Salesforce Connector

Spotfire now has a new and improved Salesforce connector that supports federated authentication and doesn’t need an ODBC driver. It uses Salesforce bulk API for quick access to millions of Salesforce records and allows loading of more than 2000 rows from Salesforce reports.

Cascading Filters are Now Available for In-Database Tables

Spotfire now supports cascading filters also when working with external data in relational databases.

Automatic Coordinate Reference Systems from Shapefile

Spotfire now automatically sets coordinate reference systems by recognizing the projection formats (.prj file) associated with Shapefiles.

More Coordinate Reference Systems

More coordinate reference systems are now supported with greater details.

New Connector Query Log

Spotfire now has a query log dedicated to connectors available for administrators. The log file collects queries from Spotfire Analyst, Node Managers and Automation Services.

Aggregate Calculated Measures in Oracle Essbase

You can now create visualizations that aggregate calculated Oracle Essbase measures.

Load Spatial Objects with Connectors for Oracle, Microsoft SQL Server, and PostgreSQL

The connectors for Oracle, Microsoft SQL Server, and PostgreSQL now support geographical data types allowing you to connect to and extract geographical row-level data into the in-memory data engine with just a few configuration steps.

The SAP HANA Connector Now Supports all Connection Settings

In addition to the new connection timeout setting for SAP HANA, any connection strung parameter can now be set from Spotfire, for example, the fetch size.

Microsoft Analysis Services Command Timeout Support

The maximum MDX query timeout limit can now be raised to allow for queries that take longer time.

Microsoft Analysis Services Username and Password Authentication Support

Username and password authentication is now supported for Microsoft Analysis Services.

Microsoft Azure Analysis Services Support

With the added support for username and password authentication you can now connect Spotfire directly to Microsoft Azure Analysis Services.

Amazon RDS SQL Server Support in Cloud Business Author

TIBCO Cloud Spotfire and the Spotfire on-premises platform can now connect to Amazon RDS SQL Server data using Microsoft SQL Sever connector. This means Spotfire analysis files stored in the Spotfire (Cloud) library can query Amazon RDS SQL Server directly from the web-based clients, Spotfire Business Author and Consumer.

JavaScript API Supports External/Web Authentication

With the new authentication mechanism, JavaScript API can be used on a Spotfire Server that is configured with any external/web authentication. For example, you can now create a mashup with a .dxp file located on the TIBCO Cloud Spotfire library.

API to Insert Data Operations

It is now possible to add data operations (AddRowsOperation, AddColumnsOperation or DataTransformationOperation) to any location within the data table structure (Source View).

06 / 2018

More responsive big data visualizations

Big data visualizations using live queries, especially towards large OLAP data sources like SAP BW and Oracle Essbase, are now much quicker to respond to and also mark changes you make.

Automatically adjusted zoom sliders

Visualizations with zoom-sliders that now auto-zoom when the data changes (e.g, when filtering) and when sliders are at the end of their range.

Color picker is now available in Spotfire Analyst

Spotfire Analyst now has a color picker that makes it easy to create analyses that follow your corporate color scheme, the color scheme of a website or the like. Just pick the color you want from anywhere on your screen and use it in the custom theme editor.

Responsive page layout for mobile devices

The Spotfire page layout is now responsive, so when a page is viewed on a small device like a phone, the layout organizes to suit the screen. The responsive layout enables vertical scrolling if the page is too large to view on the screen directly.

Column selectors look nicer

The column selectors in Spotfire now have an improved look and feel and are only displayed in the visualization over which the mouse pointer is positioned.

Join data in the Spotfire Business Author web client

You can now add columns to a data table using Spotfire Business Author web client.

Edit joins from the Source View

You can edit previously specified Add columns (Join) operations. This makes it really easy to adapt your analysis files to changes in your data sources over time.

Edit on-demand settings on data source level

You can now quickly edit on-demand settings for each individual data source in a data table.

TIBCO Cloud Spotfire now supports Apache Spark SQL

You can store analysis files in the TIBCO Cloud Spotfire library and query Databricks Cloud and Apache Spark SQL directly from the web-based clients Spotfire Business Author and Consumer.

TIBCO Cloud Spotfire now supports Microsoft HDInsight Hive

TIBCO Cloud Spotfire now connects to Microsoft HDInsight Hive. You can store analysis files in the Spotfire Cloud Library and let them query Microsoft HDInsight directly from the web-based clients Spotfire Business Author and Consumer.

Support for Amazon EMR

TIBCO Cloud Spotfire and the Spotfire on-premise platform now support Amazon EMR via Hive and Apache Spark SQL.

Timeout setting for Cloudera Impala connector

A timeout setting has now been added to the Cloudera Impala connector. This allows you to let Impala queries run for longer. For example, this allows running queries to complete when you are extracting result data sets into the in-memory data engine of Spotfire.

REST API to run Automation Services jobs

Execution of Automation Services jobs can now be triggered from an external application using a REST API. A job can either be stored in the Spotfire library or passed as an argument. The API uses an OAuth2 based authentication/authorization mechanism.

OAuth2 support for the Web Service (SOAP) API

The Web Service (SOAP) APIs (LibraryService, UserDirectoryService, UpdateAnalysisService, InformationModelService, LicenseService and SecurityService) now uses a OAuth2 based authentication/authorization mechanism. This means that the API client only needs to support a single authentication method that will work with any Spotfire Server authentication configuration.

Simplified workflow when building Spotfire .Net extensions

Spotfire now has an updated and simplified procedure for building .NET extensions for Spotfire. The package building functionality is now integrated with Visual Studio® along with templates.

Single distribution file

It is now possible to ship a bundled solution, containing several Spotfire packages, as a single distribution file (.sdn).

Work with multiple versions of Spotfire Analyst

The Spotfire deployment mechanism now supports both upgrading and downgrading of the installed Spotfire client when you connect to a server (and a specific deployment area), making it easier to work with multiple Spotfire versions simultaneously.

03 / 2018

Export prepared reports to PDF

It's easy to export one or more prepared reports to PDF in an open DXP file from the Export menu, as well as from the job builder in TIBCO Spotfire Automation Services.

Export themed Spotfire analysis to PowerPoint and Image

Now your visual theme is included when exporting, with a higher resolution making the visualizations and text clearer.

Maximize visualization temporarily

You can now temporarily maximize a visualization to take a closer look without distorting the original layout as well as rotate the view between all visualizations on the page.

Improved scrolling on mobile devices

Two-finger scroll is now possible on mobile devices, very useful when viewing a page larger than the screen and when looking at a visualization with its own scroll capability, like a table or a map. Two fingers scroll the page, one scrolls the visualization.

Fixed height or width of text areas and visualizations

Now you can fix the width or height of a text area or visualization, useful for avoiding scroll bars on small screens. The icon in the toolbar locks the settings, and the small icon menu provides more options.

Increased number of labels on scatter plots and maps

We have increased the limit for number of labels in a scatter plot or a map chart to up to 3,000, especially useful for centered data labels where markers don't overlap significantly.

Remove individual data sources

In the source view, you can remove individual data sources using the new trash can button. Spotfire provides a preview of the result as you mouse-over the trash can. The undo feature, of course, allows you to reinstate the node.

Data source information now lists added and ignored columns

Joining data tables with Insert Columns now stores which columns you chose to ignore and which to add, listing them in the data table properties dialog of the source view. This is very useful when many data transformation and Insert Columns operations are in your analysis.

The Teradata connector now supports macros

With Spotfire's connector for Teradata, you can now browse and connect to data represented by Teradata macros. A macro allows you to name a set of one or more SQL statements, providing a shortcut for executing groups of frequently run SQL statements in Teradata.

The Apache Spark SQL connector now supports temporary views

As a Spark developer you might publish results of Spark jobs in temporary views. With this release of Spotfire, you can connect directly to those views using the self-service live query connector and instantly visualize the result.

Export to PDF with the Spotfire .Net API and JavaScript API

Now you can export a prepared PDF with the Spotfire .Net API, including custom workflows with C# extensions or IronPython scripts.

API to render pages and visualizations to PNG images

The Spotfire .Net API page renderings and visualizations now result in PNG images that use the visual theme, and the API includes settings to adjust resolution and visibility of attributes like annotations, axis labels, legend, and title. This API is useful when creating export tools to support customized layouts or output formats.

WMS layer authentication including Spotfire .Net API support

The Spotfire .Net API now supports configuring a WMS layer with username and password.

API to remove data operation

The Data Table Source View API (introduced with the 7.10 release) now lets you remove individual data sources or other operations, such as add columns operations or add rows operations.


Earlier Releases

Learn more about features released in earlier versions.