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

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.

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

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

More coordinate reference systems are now supported with greater details.

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.

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

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.

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.

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

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

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

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.

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.

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

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.

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.

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.

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.

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.

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

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.

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

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

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

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.

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.

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.

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.

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

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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

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.

Search for a location on the map and quickly zoom in. Spotfire suggests locations as you type.

Now you can color the text in cross tables and tables when certain conditions are met, as an alternative to coloring the cell background.

Configure cross tables to calculate sub- and grand totals on the values displayed in the cells, as an option to calculating using underlying row level data, for example, when you want to visualize the sum of the category absolute values.

Now you can easily replace any data source from source view without compromising the data wrangling and data mashup you have done. This helps when you have developed the work in non-production environment and want to switch to production with one-click data source replacement.

Previously, Spotfire users had source view access to change data connection configurations like adding and removing tables and columns, adding or modifying custom queries, modifying prompts, and changing column names and other settings.

With this release, it is just as easy to make changes to the data source used by the data connection. The data source holds information regarding source IP, authentication method, time-outs and database, which are all easy to modify now.

For example, it's now easier than ever to move from a test database to a production database. If different table names are used in the databases, Spotfire highlights these differences and makes it easy to select the corresponding table.

Just click on the settings button on the data source node to edit the data connection.

Now you can edit replaced values in an analysis without creating additional transformation steps, so you can go back and modify previously added replacement operations if they are no longer applicable.

By editing already created operations, you can make the analysis cleaner by avoiding transformations that replace the same value over time.

The SAP BW connector now has the option to query SAP BW using the native SAP BAPI API integration without going through the ODBO API.

Not only does it provide better performance and more detailed messages from SAP BW, but also a better user experience, and it allow us to develop new features over time.

We have therefore decided to deprecate support for the ODBO API in a future Spotfire release. Both APIs will be available for a period of time so you can upgrade at your own pace.

Also available when administrators enable the SAP BW's BAPI API:

• Load more than one million SAP BW data cells. Now connect to BEx queries representing more data, and implement more use cases.
• Increase the default 10 minute timeout so you can import and analyze larger data volumes without timing out (also for the previous ODBO API).

Spotfire's SAP HANA connector now supports additional functions. These new functions are found in Spotfire's Custom Expressions UI: Median, Stddev_Pop, Stddev_Samp, Var_Pop, Var_Samp, Bitcount, Months_Between and Years_Between. Details for how to use these functions are documented by SAP and are subject to change over time.

The Teradata connector and Information Services now support Teradata 16.

Now you can load data directly from publicly available TIBCO Spotfire Data Catalogs into TIBCO Cloud Spotfire Business Author and Consumer file.

Files authored in Spotfire Analyst and saved to the TIBCO Cloud Spotfire Library are now available for Business Author and Consumer users, and you can refresh data from individual sources in the source view of Spotfire Business Author.

We have three new features for scheduling and routing to help administrators more easily manage rules and uncached files:

• Prevent users from opening files that are not cached by scheduled updates and take too long to load. Learn more here.
• Recover rules that have been auto-disabled. Now, if a deleted file is imported back to its previous location, any associated routing rules can be re-enabled by updating a setting in the server configuration file, enable-recovered-rules-automatically. Learn more here.
• Copy routing rules and schedules from one site to another. Learn more here.

Spotfire's connector for Apache Spark SQL now supports the thrift transport modes Binary, SASL and HTTP. TLS security settings are on by default for new connections, making it faster to configure data connections securely, e.g., to Databricks data sources.

In certain situations, attaching transformations to data sources can dramatically reduce the size of the analysis file as well as the loading times, based on the fact that Spotfire doesn't save the original data in the analysis file, only the transformed result.

For example, adding a pivot data transformation to the data source only stores the pivoted result table and discards the 200M original rows.

TIBCO Cloud Spotfire users can now use the full power of TERR, TIBCO Enterprise Runtime Engine for R to build and deploy R functions, models and forecasts quickly and easily. Use open source R and integrate and deploy R code without the need to rewrite code. Get started with our library of over 600 CRAN packages, and share your predictive dashboards and apps easily with Business Author and Consumer uses.

Rotate markers on Map Charts and Scatter Plots defined by values in a column or custom expression. Orientation of the markers can be configured to visualize directional data such as the wind’s direction or a ship’s heading.

Save time customizing your analysis by enabling or disabling auto-zoom directly from the Map Chart contextual menu.

Spotfire 7.10 brings a complete overhaul of the Export to PDF feature. Not only will exported visualizations retain the visual theme of the dashboard, but they will be of higher graphical quality. In addition, the export dialog now has a preview to ensure best results. That's not all — there is now a relative scaling option that allows you to adjust the text in your visualizations to best fit your PDF page.

When working with large Cross Tables it is now possible to scroll in the hierarchy as well as through the values. There are now three options for configuring scrolling in Cross Tables:

• Freeze row headers is the old behavior, which keeps the row header frozen and lets the user scroll only among the column values.
• Scroll row headers means that the cross table will always scroll through both row headers and column values.
• Adjust automatically is the new default where the cross table will switch automatically between the two above options dependent on the width of the row headers relative to the width of the whole cross table.

The source view introduced in Spotfire 7.6 and all of the data wrangling features added since are now available via the Spotfire API. This allows for new ways of building analytics applications or adapting them on the fly. For example, with API control over the Add Columns operation, you can programmatically edit how data is blended and instantly see the results in the analysis.

When developing and debugging a R data function in Spotfire, you now have the option of sending text output from the data function to the notifications in the lower left of the Spotfire window. By clicking on the notification, you can view the text. Thus, you can use this in order to write debug information as the data function executes.

You asked, and our engineers answered. The most requested SAP BW integration feature now makes it possible to automatically connect SAP BW BEx query variables to Spotfire prompts. Furthermore, you can now connect Spotfire to your cluster of SAP BW systems via the SAP Message Server load balancer.

Spotfire's SAP HANA integration now supports Kerberos authentication in combination with SAP SSO 3.0 in all clients and servers. This enables users analyzing SAP HANA data access without entering their credentials. It also provides a central location for users and roles administration for SAP HANA administrators.

You can now upgrade the node manager from the administration UI. Also, this upgrade is now part of the rollback process in case there is an issue or error with the upgrade.

With one click, you can now up update, rollback, or delete your deployment packages.

Connecting to Oracle Essbase cube just got easier. Now, if your Oracle Essbase cube does not have a dimension tagged as the accounts dimension, you are able to specify which dimension contains the measures.

The Scheduling & Routing page now has pagination. By default, you will see 100 scheduled updates and routing rules, but you also have the option to switch the view to 50 or 150 items per page.

In response to requests from the Spotfire user community, we have greatly improved performance when filtering in external data sources.This applies for both filters in the filter panel and in text boxes.

Spotfire 7.9 adds what has been one of the most anticipated new time-saving features, the ability to edit your data transformations. You can adapt to changes in data sources or tweak new transformations without having to start from scratch.

Now, whenever a data preparation step has encountered a problem in the data source view, Spotfire will notify you with one of several severity-ranked indicators. The indicators enable quick troubleshooting of data transformations, and when paired with the new edit transformation feature, drastically reduce your time to analysis.

The native Salesforce.com connector for Spotfire is now able to load more data, such as the Case Table, which often keeps millions of records.

Spotfire Information Services now supports constrained Kerberos delegation in combination with compatible JDBC drivers.

Data from Amazon Redshift, Azure SQL, and OData can now be viewed in TIBCO Cloud Spotfire Business Author and Consumer.

Issues in your data are most often found once you start visualizing it, so why not fix them right then and there? Spotfire now has new “replace value” and “replace all occurrences” features for easily cleaning up erroneous data values in table charts and the details-on-demand panel.

In Spotfire 7.9  99% of packages on CRAN―almost 10,000 community packages―can be loaded into the built-in R engine. We’ve also made significant improvements to the engine’s performance and to ease of use for creating graphics.

Microsoft Azure HDInsight, APACHE KNOX, SAP SSO, and Google Analytics Web Authentication are all now supported.

You can now right-click anywhere on a map and get geographic coordinates (latitude and longitude) for a location. Nautical miles have also been added as a unit of measurement in addition to the existing imperial and metric units when using radius and rectangle selections.

Analysis Services 2016; PostgreSQL 9.5 and 9.6; MySQL 5.7; SAP BW 7.5; and Apache Spark SQL 2.0 are now supported.

Spotfire now automatically detects and recommends if data you add to an analysis should be added as rows to existing data.

The KPI chart API allows authors and developers to automatically configure KPI Charts from IronPython scripts or custom tools. This enables creating more user friendly and powerful visual analytics applications for end users.

Administrators can now configure a system wide upper limit for the number of rows possible to visualize in a table visualization based on an in-database data table. The configuration is made in Spotfire Analyst Administration Manager, on the Preferences tab, under Data Import Preferences.

Spotfire Server now supports the use of OpenID Connect as a method of authentication.

Your analysis can benefit from on-demand loading when you have access to massive amounts of data, but you only need to work with some parts of the data at a time. When setting up an on-demand data table you can specify conditions based on one or more other data tables to control what to load.

The map chart now supports Web Map Service (WMS) 1.3.0 in addition to the previously existing 1.1.0 and 1.1.1 support.

Getting a nice layout when automating dashboard creation has often been cumbersome. With the new capabilities in the LayoutDefinition API, developers can specify proportions (vertically or horizontally) to get full control over the layout of the visualizations on a page, similar to what is possible to configure from the user interface.

Spotfire's connector for SQL Server now supports SQL Server 2016, Azure SQL and Azure SQL Data Warehouse.

The Spotfire Server needs a database to store its own data. As of Spotfire 7.8, Microsoft SQL Server 2016 can be used as an option.

Add context to your KPI charts with Sparklines that visualize the trend over time.

Use TERR to define your own Spotfire aggregations in R.

Business Author users can now create and configure KPI chart visualizations using a simple drag and drop method.

A new task, Export Data to File, has been added in Automation Services, and new features have been added to the Send Email task.

When using the Zoom Visibility property to create geographic drill-downs, map layers interactivity switches automatically as you zoom-in/out the map.

Create and edit connections to Google Analytics and Salesforce in the web authoring client.

Create great mobile Spotfire dashboards and reports that scale with your screen.

Improved BEX variable handling and ability to configure how the SAP BW characteristics are displayed in the Spotfire UI.

Create custom panels in the web client to visualize contextual information, adding controls or other domain specific functionality to Spotfire.

Create more compact and better looking tables and cross tables, with better control over cell width, alignment, and absolute sorting.

Easily monitor and maintain your scheduled updates and your web player resources from new web UIs. Easier deployment of data connectors to Spotfire Analyst users.

Create map charts with multiple layers of data. Use your favorite map background. Visualize map layers from GIS.

Attivio has the ability to identify, integrate, unify and provision virtually any type and amount of structured data and unstructured content. Spotfire's new self-service connector to Attivio makes it easy for business users to connect to, search and analyze the result in Spotfire.

Leverage the new Web Panel API to create custom panels in the web client to visualize contextual information.

See real-time business performance metrics at a glance—on your phone, your tablet, or your computer.

New support for Tile Map Services (TMS) means you can more easily use the base map background of your choice.

Set a map chart to automatically zoom-in to the filtered data.

Spotfire data panel now has a built-in unpivot option on the right-click menu.

Business Author users can now automatically connect to Salesforce.com.

Import data from two major in-memory NoSQL databases without any external applications or platforms.

Change individual column width, text alignment, and orientation to make your tables more compact and readable.

In addition to rectangle and lasso selection tools, the new radius tool lets you mark data around a location.

From both the source view and the library, you can now select between "Always New Data,” "Stored Data,” and "New Data When Possible.”

Spotfire® Business Author and Spotfire® Analyst can incorporate Google Analytics data with ease and speed.

Amazon Redshift, Hortonworks, Oracle and Oracle MySQL, Pivotal Greenplum, Pivotal HAWQ, and Postgres SQL.

Control how resources are scaled, isolated, and used with rules that route users to specific resources.

A chat box within the visualization helps groups focus, bring insights, and make decisions.

Quickly see how parts of the whole negatively or positively affect the total.

An improved data panel let's you get a quick overview of your data and easily make adjustments.

Spotfire has certified connectivity with Apache Spark so you can perform large-scale data analysis.

Spotfire now has an improved integration with SAP HANA Analytics. Expanded support for SAP HANA Information Views and Attribute Views promotes a greater navigability of the data, in addition to overall performance enhancements when handling SAP HANA Analytics.

In a few clicks you can split a column with multiple values in its cells into columns for each of the distinct values.

Press Refresh while in a Spotfire Cloud analysis for the latest updates to the data.

You can use much of the Comprehensive R Archive Network (CRAN) with Spotfire out-of-the-box.

ODBC Drivers for TIBCO Spotfire Analyst are now available directly in the 'My Downloads' section of Spotfire Cloud.

he Spotfire Analyst client now runs on 32-bit operating systems and no longer requires Internet Explorer 10+.

Comments that can explain and draw attention to key points in your visualization.

Interacting with a visualization in one browser window automatically updates the other windows.

Deliver more information with horizontal lines on whiskers, single diamonds for median values, or dotted lines for averages.

Change the data order and categorization, create new columns, fill in empty values, and format on the fly.

The new driver makes it easy to browse your Salesforce data and answer questions fast.

View data table sources and what’s been done to the data, and preview the results from each of the intermediate steps.

The streamlined filter selector allows quick selection and deselection of filters to get the view you need faster.

Column names and data are sorted in time sequence (not alphabetically), with local culture settings upheld.

Improvements to connectors for Microsoft SQL Server Analysis Services, SAP BW.

Embed Spotfire visualizations in HTML for an interactive data analysis experience on the web.