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 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 kann jetzt automatisch erkennen, ob Daten, die Sie zur Analyse hinzufügen, als Zeilen zu den bestehenden Daten hinzugefügt werden sollten und entsprechende Empfehlungen geben.

Durch API für KPI-Diagramme können Autoren und Entwickler KPI-Diagramme automatisch aus IronPython-Skripts oder benutzerdefinierten Tools konfigurieren. So lassen sich benutzerfreundlichere und leistungsstärkere visuelle Analyseanwendungen für Endbenutzer erstellen.

Ab sofort können Administratoren eine systemweite Obergrenze für die Anzahl an Zeilen konfigurieren, die innerhalb einer Tabellenvisualisierung auf der Basis einer In-Database-Datentabelle angezeigt werden können. Diese Konfiguration erfolgt im Spotfire Analyst Administration Manager im Tab „Preferences“ unter „Data Import Preferences“.

Spotfire Server unterstützt jetzt OpenID Connect als Authentifizierungsmethode.

Wenn Sie über enorme Datenmengen verfügen, aber nur mit einem Teil dieser Daten zur selben Zeit arbeiten müssen, ist ein On-Demand-Ladeprozess genau das Richtige für Ihre Analyse. Bei der Einrichtung einer On-Demand-Datentabelle können Sie die Bedingungen auf Basis einer oder mehrerer Datentabellen spezifizieren und so genau bestimmen, welche Daten geladen werden.

Das Kartendiagramm unterstützt ab sofort Web Map Service (WMS) 1.3.0 ergänzend zu den Versionen 1.1.0 und 1.1.1.

Bei der automatisierten Dashboard-Erstellung war es oft nicht so leicht, ein ansprechendes Layout zu erzielen. Mit den neuen Funktionen in der Layout Definition-API können Entwickler - ähnlich wie in der Benutzeroberfläche - die Proportionen bestimmen (vertikal oder horizontal) und so das Layout von Visualisierungen auf einer Seite gezielt gestalten.

Der Spotfire-Konnektor für SQL Server unterstützt ab sofort SQL Server 2016, Azure SQL und Azure SQL Data Warehouse.

Der Spotfire-Server benötigt eine Datenbank, um seine eigenen Daten zu speichern. Ab Spotfire 7.8 kann Microsoft SQL Server 2016 als Option hierfür verwendet werden.

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.

Ahora, Spotfire detecta y recomienda automáticamente si los datos que añade a un análisis deberían añadirse como filas a los datos existentes.

La API de la visualización KPI permite a los autores y desarrolladores configurar automáticamente diagramas KPI desde IronPython scripts o herramientas a medida. Esto permite crear aplicaciones de analisis más sencillas y potentes visualmente

Ahora, los administradores pueden configurar el límite superior del número de filas que pueden visualizarse de una tabla de una base de datos. Los ajustes se realizan en Spotfire Analyst Administration Manager, en la pestaña Preferences , en Data Import Preferences.

Spotfire server ahora soporta el uso de OpenID Connect como método de autenticación.

Sus análisis se pueden beneficiar de una descarga bajo demanda cuando tiene acceso a enormes cantidades de datos, pero solo necesita trabajar con parte de los datos. Al configurar una tabla de datos a demanda, puede especificar condiciones en base a una o más tablas de datos para controlar lo que carga.

Ahora, el diagrama de mapas soporta Web Map Service (WMS) 1.3.0, además de las versiones anteriores existentes 1.1.0 y 1.1.1 soporte.

Conseguir un layout atractivo al automatizar la creación de cuadros de mando a menudo resulta difícil. Con las nuevas prestaciones de la API LayoutDefinition, los desarrolladores pueden especificar proporciones (vertical u horizontalmente) para tener un control total sobre el layout de las visualizaciones en una página, de forma similar a lo que se puede configurar desde la interfaz de usuario.

Ahora, el conector de Spotfire para SQL Server soporta SQL Server 2016, Azure SQL y Azure SQL Data Warehouse.

Spotfire Server necesita una base de datos para almacenar sus propios datos. A partir de Spotfire 7.8, se puede usar Microsoft SQL Server 2016 como opción.