TIBCO Spotfire 7.11 Launched

banner-spotfire-cloud-2x

Source: TIBCO

TIBCO Cloud™ Spotfire®, which was just launched with version 7.11 of TIBCO Spotfire®. A new TERR-as-a-Service capability allows cloud users to have the full power of building R functions and models in the cloud. Check out what’s new in the product release for version 7.11 to learn more.

Search and zoom in Map Charts

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

Conditional text color in cross tables and tables

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

Subtotals in cross tables and tables

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.

Replace data source from Source View

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.

Edit relational data connection data sources from Source View

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.

Edit replace value transformations from Source View

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.

SAP BW connectivity using New SAP BAPI API

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

Enhanced support for SAP HANA functions

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.

Support for Teradata 16

The Teradata connector and Information Services now support Teradata 16.

Spotfire Cloud Business Author and Consumer can load public data from Spotfire Data Catalog datamarts

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

Files authored in Spotfire Analyst and saved to the Spotfire Cloud 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.

Enhancements in Spotfire Server

Clustering is now implemented using Apache Ignite and will replace Hazelcast and TIBCO ActiveSpaces. Apache Ignite clustering is faster and requires no manual configuration. Upgrading to 7.11 will move any clusters to the new method.

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.

Support for new thrift transport modes in Apache Spark SQL

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.

Add transformation to data source

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.